Site Tools


Hotfix release available: 2024-02-06a "Kaos". upgrade now! [55.1] (what's this?)
New release available: 2024-02-06 "Kaos". upgrade now! [55] (what's this?)
onny:notizen:programmierung

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
onny:notizen:programmierung [2022/02/22 13:26] – [postgresql] 46.223.163.98onny:notizen:programmierung [2023/11/07 15:40] (current) – [sql] 127.0.0.1
Line 56: Line 56:
 date = datetime.datetime.now().strftime("%d.%m.%Y") date = datetime.datetime.now().strftime("%d.%m.%Y")
 </code> </code>
 +
 requests requests
 +
 <code python> <code python>
 import requests import requests
Line 66: Line 68:
 if (upstream_head.headers['content-type'] == "text/html;charset=UTF-8" or upstream_head.headers['content-type'] == "text/html; charset=UTF-8"): if (upstream_head.headers['content-type'] == "text/html;charset=UTF-8" or upstream_head.headers['content-type'] == "text/html; charset=UTF-8"):
     upstream_response = upstream_response.replace("//thepiratebay.org","")     upstream_response = upstream_response.replace("//thepiratebay.org","")
 +</code>
 +
 +class example
 +
 +<code python>
 +class Planday:
 +  auth_url = 'https://id.planday.com/connect/token'
 +  client_id = '1234'
 +  access_token = ''
 +
 +  def authenticate(self):
 +    payload = {
 +      'client_id': self.client_id,
 +      'refresh_token': 'qyS6qt9yNEqygE1mMQtRzA',
 +      'grant_type': 'refresh_token'
 +    }
 +    headers = {
 +      'Content-Type': 'application/x-www-form-urlencoded'
 +    }
 +    session = requests.session()
 +    session.trust_env = False
 +    response = session.request("POST", self.auth_url, headers=headers, data=payload)
 +    response = json.loads(response.text)
 +    self.access_token = response['access_token']
 +
 +planday = Planday()
 +planday.authenticate()
 </code> </code>
 ==== ponyorm ==== ==== ponyorm ====
Line 176: Line 205:
 </code> </code>
 ===== javascript ===== ===== javascript =====
 +
 split up javascript files split up javascript files
 +
 <code javascript> <code javascript>
 var MODULE = (function (my) { var MODULE = (function (my) {
Line 192: Line 223:
 }(MODULE || {})); }(MODULE || {}));
 </code> </code>
-jquery select by attribute content + 
-<code javascript> +on document ready 
-$( "tr[data-id='"+data[station]["stationid"]+"']" ).remove(); +
-</code> +
-jquery select dynamicly loaded ajax elements+
 <code javascript> <code javascript>
-$('body').on('click','.btn + :not([class=disabled])', function() { +document.addEventListener("DOMContentLoaded", function() { 
-  var link = $(this).attr('src'); +  your_function(...);
-  load_page(link);+
 }); });
 +
 </code> </code>
-jquery set background color + 
-<code javascript> +change content text 
-$(this).parent().css("background-color", "yellow"); +
-</code> +
-print mixed objects +
-<code javascript> +
-console.log('%d: %s', i, value); +
-</code> +
-javascript document ready +
-<code javascript> +
-$(document).ready(function(){ +
-  console.log('ready'); +
-}); +
-</code> +
-vanilla js change content text+
 <code javascript> <code javascript>
     var webgl_field = document.getElementById('webgl');     var webgl_field = document.getElementById('webgl');
Line 226: Line 243:
     }     }
 </code> </code>
-vanilla js ajax post form+ 
 +ajax post form 
 <code javascript> <code javascript>
     document.getElementById('form').onsubmit = function (evt) {     document.getElementById('form').onsubmit = function (evt) {
Line 244: Line 263:
     }     }
 </code> </code>
-vanilla js change style element+ 
 +change style element 
 <code javascript> <code javascript>
     function show_create_post() {     function show_create_post() {
Line 257: Line 278:
  
 trim string to max length trim string to max length
 +
 <code javascript> <code javascript>
 var string = string.substring(0,100); var string = string.substring(0,100);
 +</code>
 +
 +onclick class element
 +
 +<code javascript>
 +document.getElementsByClassName('navbar-burger')[0].onclick = function(){
 +  console.log('ready');
 +};
 +</code>
 +
 +onclick on all class elements
 +
 +<code javascript>
 +# old: var anchors = document.getElementsByClassName('wp-block-navigation-item__content');
 +let allCheckBox = document.querySelectorAll('.shapes')
 +
 +  allCheckBox.forEach((checkbox) => { 
 +  checkbox.addEventListener('change', (event) => {
 +    if (event.target.checked) {
 +      console.log(event.target.value)
 +    }
 +  })
 +})
 +</code>
 +
 +remove class from element
 +
 +<code javascript>
 +var element = document.getElementsByClassName('wp-block-navigation__responsive-container')[0];
 +element.classList.remove("is-menu-open");
 +</code>
 +
 +get url and pathname
 +
 +<code javascript>
 +console.log(window.location.url)
 +console.log(window.location.pathname)
 +</code>
 +
 +querySelector, get child element
 +
 +<code javascript>
 +var h3 = document.querySelector('div.multicolumn ul li:nth-child(1) h3')
 +console.log(h3.textContent);
 +h3.querySelector('span');
 +</code>
 +
 +querySelectorAll
 +
 +<code javascript>
 +var productAccordion = document.querySelectorAll('div.product__accordion');
 +productAccordion[1].style.display = "none";
 +</code>
 +
 +get next or previous element
 +
 +<code javascript>
 +document.getElementById('foo2').nextSibling; // #foo3
 +document.getElementById('foo2').previousSibling; // #foo1
 </code> </code>
 ==== vuejs ==== ==== vuejs ====
Line 433: Line 514:
       }       }
 </code> </code>
-===== css ===== 
-sweet font styling 
-<code css> 
-font-family: consolas,Menlo-Regular,Menlo,Monaco,monospace; 
-    font-size: 125%; 
-    line-height: 135%; 
-</code> 
-media queries, page greater than 600px 
-<code css> 
-      @media (min-width: 600px) { 
-        article { 
-          min-width: 600px; 
-        } 
-      } 
-</code> 
-popover menu 
-<code css> 
-.main-navigation ul li ul.sub-menu { 
- opacity: 0; 
- position: absolute; 
-  box-shadow: 0 2px 5px 0 rgba(0, 0, 0, 0.26); 
- transition:opacity 250ms ease-out; 
- padding: 20px; 
- z-index: 2; 
- left: 17px; 
- background: white; 
-} 
  
-.main-navigation ul li:hover ul.sub-menu { 
- opacity: 1; 
- transition:opacity 250ms ease-out; 
-} 
-</code> 
- 
-responsive grid layout 
-<code> 
-ul { 
- display: grid; 
- grid-gap: 50px 40px; 
- grid-template-columns: repeat(auto-fit, minmax(290px, 1fr)); 
-} 
-</code> 
 ===== php ===== ===== php =====
 enable debugging / error log enable debugging / error log
Line 571: Line 611:
  
                 [...]                 [...]
 +                
 +endif;
 +
 +add_action( 'after_setup_theme', 'iaro_setup' );
 </code> </code>
  
Line 605: Line 649:
 } }
 </code> </code>
-===== sql ===== + 
-Update field+custom menu walker, only printing <a> tags without list items 
-<code sql+<code php> 
-update forwardings set destination='alex.bloss@online.dewhere 'destination=bloss@bigwood.de';+class Nav_Footer_Walker extends Walker_Nav_Menu { 
 + 
 +    function start_lvl( &$output, $depth 0, $args array() ) { 
 +        $indent str_repeat("\t", $depth); 
 +        $output ."\n$indent\n"; 
 +    } 
 + 
 +    function end_lvl( &$output, $depth 0, $args array() ) { 
 +        $indent str_repeat("\t", $depth); 
 +        $output ."$indent\n"; 
 +    } 
 + 
 +    function start_el( &$output, $item, $depth 0, $args array(), $id = 0 ) { 
 +        $indent = ( $depth ) ? str_repeat( "\t", $depth ) ''; 
 + 
 +        $class_names = $value = ''; 
 + 
 +        $classes = empty( $item->classes ) ? array() : (array) $item->classes; 
 +        $classes[] = 'menu-item-' . $item->ID; 
 + 
 +        $class_names = join( ' ', apply_filters( 'nav_menu_css_class', array_filter( $classes ), $item, $args ) ); 
 +        $class_names = $class_names ? ' class="' . esc_attr( $class_names ) . '"' : ''; 
 + 
 +        $id = apply_filters( 'nav_menu_item_id', 'menu-item-'. $item->ID, $item, $args ); 
 +        $id = $id ? ' id="' . esc_attr( $id ) . '"' : ''; 
 + 
 +        $output .= $indent . ''; 
 + 
 +        $attributes  = ! empty( $item->attr_title ) ? ' title="'  . esc_attr( $item->attr_title ) .'"' : ''; 
 +        $attributes .= ! empty( $item->target )     ? ' target="' . esc_attr( $item->target     ) .'"' : ''; 
 +        $attributes .= ! empty( $item->xfn )        ? ' rel="'    . esc_attr( $item->xfn        ) .'"' : ''; 
 +        $attributes .= ! empty( $item->url )        ? ' href="'   . esc_attr( $item->url        ) .'"' : ''; 
 + 
 +        $item_output = $args->before; 
 +        $item_output .= '<a class="navbar-item" '. $attributes .'>'; 
 +        $item_output .$args->link_before . apply_filters( 'the_title', $item->title, $item->ID ) $args->link_after; 
 +        $item_output .'</a>'
 +        $item_output .$args->after; 
 + 
 +        $output .= apply_filters( 'walker_nav_menu_start_el', $item_output, $item, $depth, $args ); 
 +    } 
 + 
 + 
 +    function end_el( &$output, $item, $depth = 0, $args = array() ) { 
 +        $output .= "\n"; 
 +    } 
 + 
 +
 + 
 +wp_nav_menu( array( 
 +    'menu'            => 'primary', 
 +    'container_id'    => 'mainNavbar', 
 +    'container_class' => 'navbar-menu', 
 +    'items_wrap'      => '<div class="navbar-end">%3$s</div>', 
 +    'walker'          => new Nav_Footer_Walker(), 
 +) );
 </code> </code>
-Insert field: + 
-<code sql+customizer add option custom text 
-insert into forwardings (source, destinationVALUES ('markus.heim@wew-heim.de', 'heimmarkus@yahoo.de'); +<code php
-insert into forwardings VALUES ('markus.heim@wew-heim.de', 'heimmarkus@yahoo.de');+function theme_customize_register$wp_customize 
 + 
 +    $wp_customize->add_setting( 'fachwerksauna_footer-text', array( 
 +        'default=> '', 
 +        'type' => 'option', 
 +        'capability' => 'edit_theme_options' 
 +    ),); 
 + 
 +    $wp_customize->add_controlnew WP_Customize_Control( 
 +        $wp_customize, 'footer-text_control', array( 
 +            'label'      => __( 'Footer text', 'fachwerksauna' ), 
 +            'description' => __( 'Text in footer area', 'fachwerksauna' ), 
 +            'settings'   => 'fachwerksauna_footer-text', 
 +            'priority'   => 10, 
 +            'section'    => 'title_tagline', 
 +            'type'       => 'text', 
 +        ) 
 +    ) ); 
 + 
 +
 + 
 +add_action( 'customize_register', 'theme_customize_register' );
 </code> </code>
-Delete row: + 
-<code sql+add custom javascript js 
-delete from domains where domain='alex-vt.de';+ 
 +<code php
 +function twentytwentytwo_enqueue_custom_js() { 
 +    wp_enqueue_script('custom', get_stylesheet_directory_uri().'/inc/js/main.js'); 
 +
 + 
 +add_action( 'wp_enqueue_scripts', 'twentytwentytwo_enqueue_custom_js' );
 </code> </code>
 +===== sql =====
 <code sql> <code sql>
 mysql> \P /usr/bin/less mysql> \P /usr/bin/less
Line 639: Line 766:
  
 ==== mysql ==== ==== mysql ====
- 
-Dump database 
-<code bash> 
-mysqldump -u root -p Tutorials > tut_backup.sql 
-</code> 
- 
-Backup everything 
-<code bash> 
-mysqldump -u root -p --all-databases > alldb.sql 
-</code> 
- 
-Import database 
-<code> 
-mysql> CREATE DATABASE wordpress; 
-sudo mysql -u root wordpress < wordpress.sql 
-</code> 
- 
-Setup 
-<code bash> 
-systemctl stop mysqld 
-mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql 
-systemctl start mysqld 
-mysql_secure_installation 
-</code> 
  
 delete specific row delete specific row
Line 674: Line 777:
 </code> </code>
  
-==== postgresql ==== +adjust permissions to table 
- +<code sql
-drop database +CREATE USER 'ninja'@'http.pi' IDENTIFIED BY '****'; 
-<code bash+GRANT ALL PRIVILEGES ON ninja.* TO 'ninja'@'http.pi' identified by '123'; 
-sudo -u postgres -i +GRANT ALL PRIVILEGES ON ninja.* TO 'ninja'@'http.pi'; 
-dropdb onlyoffice+FLUSH PRIVILEGES;
 </code> </code>
  
-list databases +update statement
-<code> +
-psql# \l +
-</code>+
  
-dump database +<code sql
-<code> +UPDATE wp_options SET option_value = 'info@example.org' WHERE option_name = 'admin_email';
-pg_dump -U gitlab gitlabhq_production > /tmp/gitlab.pgsql+
 </code> </code>
  
-import database 
-<code> 
-psql# CREATE DATABASE gitlabhq_production 
-psql -U gitlab gitlabhq_production < gitlab.pgsql 
-</code> 
- 
-create and delete user 
-<code> 
-DROP ROLE gitlab; 
-CREATE USER gitlab WITH PASSWORD '5V0hD0KWX81g5dhKGHsbqU4a'; 
-</code> 
onny/notizen/programmierung.1645536385.txt.gz · Last modified: 2022/02/22 13:26 by 46.223.163.98