Differences

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

--- onny:notizen:programmierung [2022/03/02 09:37] – [postgresql] 2a02:8071:3ecc:6e00:1a9:a89f:404c:a243
+++ onny: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")
 </code>
 requests
 <code python>
 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"):
     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>
 ==== ponyorm ====
@@ Line 176: / Line 205: @@
 </code>
 ===== javascript =====
 split up javascript files
 <code javascript>
 var MODULE = (function (my) {
@@ Line 192: / Line 223: @@
 }(MODULE || {}));
 </code>
-jquery select by attribute content
+on document ready
 <code javascript>
-$( "tr[data-id='"+data[station]["stationid"]+"']" ).remove();
+document.addEventListener("DOMContentLoaded", function() {
-</code>
+  your_function(...);
-jquery select dynamicly loaded ajax elements
-<code javascript>
-$('body').on('click','.btn + :not([class=disabled])', function() {
-  var link = $(this).attr('src');
-  load_page(link);
 });
 </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>
     var webgl_field = document.getElementById('webgl');
@@ Line 226: / Line 243: @@
     }
 </code>
-vanilla js ajax post form
+ajax post form
 <code javascript>
     document.getElementById('form').onsubmit = function (evt) {
@@ Line 244: / Line 263: @@
     }
 </code>
-vanilla js change style element
+change style element
 <code javascript>
     function show_create_post() {
@@ Line 257: / Line 278: @@
 trim string to max length
 <code javascript>
 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>
 ==== vuejs ====
@@ Line 433: / Line 514: @@
       }
 </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 =====
 enable debugging / error log
@@ Line 571: / Line 611: @@
                 [...]
+endif;
+add_action( 'after_setup_theme', 'iaro_setup' );
 </code>
@@ Line 605: / Line 649: @@
 }
 </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.de' where '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>
-Insert field:
-<code sql>
+customizer add option custom text
-insert into forwardings (source, destination) VALUES ('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_control( new 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>
-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>
+===== sql =====
 <code sql>
 mysql> \P /usr/bin/less
@@ Line 639: / Line 766: @@
 ==== 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
@@ Line 674: / Line 777: @@
 </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>
-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>
-dump all
-<code>
-pg_dumpall > /tmp/dump_file_name.tar
 </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>
-grant permissions
-<code>
-ALTER USER gitlab SUPERUSER;
-CREATE DATABASE gitlabhq_production OWNER gitlab;
-ALTER DATABASE gitlabhq_production OWNER TO gitlab;
-</code>