onny:notizen:programmierung
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
onny:notizen:programmierung [2022/10/25 10:58] – [javascript] 10.100.0.1 | onny:notizen:programmierung [2023/11/07 15:40] (current) – [sql] 127.0.0.1 | ||
---|---|---|---|
Line 56: | Line 56: | ||
date = datetime.datetime.now().strftime(" | date = datetime.datetime.now().strftime(" | ||
</ | </ | ||
+ | |||
requests | requests | ||
+ | |||
<code python> | <code python> | ||
import requests | import requests | ||
Line 66: | Line 68: | ||
if (upstream_head.headers[' | if (upstream_head.headers[' | ||
upstream_response = upstream_response.replace("// | upstream_response = upstream_response.replace("// | ||
+ | </ | ||
+ | |||
+ | class example | ||
+ | |||
+ | <code python> | ||
+ | class Planday: | ||
+ | auth_url = ' | ||
+ | client_id = ' | ||
+ | access_token = '' | ||
+ | |||
+ | def authenticate(self): | ||
+ | payload = { | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | } | ||
+ | headers = { | ||
+ | ' | ||
+ | } | ||
+ | session = requests.session() | ||
+ | session.trust_env = False | ||
+ | response = session.request(" | ||
+ | response = json.loads(response.text) | ||
+ | self.access_token = response[' | ||
+ | |||
+ | planday = Planday() | ||
+ | planday.authenticate() | ||
</ | </ | ||
==== ponyorm ==== | ==== ponyorm ==== | ||
Line 265: | Line 294: | ||
<code javascript> | <code javascript> | ||
- | var anchors = document.getElementsByClassName(' | + | # old: var anchors = document.getElementsByClassName(' |
- | for(var i = 0; i < anchors.length; i++) { | + | let allCheckBox |
- | var anchor | + | |
- | | + | allCheckBox.forEach((checkbox) |
- | console.log(' | + | |
+ | if (event.target.checked) { | ||
+ | console.log(event.target.value) | ||
} | } | ||
- | } | + | |
+ | }) | ||
</ | </ | ||
Line 288: | Line 320: | ||
</ | </ | ||
- | querySelector | + | querySelector, get child element |
<code javascript> | <code javascript> | ||
- | var multicolumnHeadline | + | var h3 = document.querySelector(' |
+ | console.log(h3.textContent); | ||
+ | h3.querySelector(' | ||
</ | </ | ||
Line 299: | Line 333: | ||
var productAccordion = document.querySelectorAll(' | var productAccordion = document.querySelectorAll(' | ||
productAccordion[1].style.display = " | productAccordion[1].style.display = " | ||
+ | </ | ||
+ | |||
+ | get next or previous element | ||
+ | |||
+ | <code javascript> | ||
+ | document.getElementById(' | ||
+ | document.getElementById(' | ||
</ | </ | ||
==== vuejs ==== | ==== vuejs ==== | ||
Line 473: | Line 514: | ||
} | } | ||
</ | </ | ||
- | ===== css ===== | ||
- | sweet font styling | ||
- | <code css> | ||
- | font-family: | ||
- | font-size: 125%; | ||
- | line-height: | ||
- | </ | ||
- | media queries, page greater than 600px | ||
- | <code css> | ||
- | @media (min-width: 600px) { | ||
- | article { | ||
- | min-width: 600px; | ||
- | } | ||
- | } | ||
- | </ | ||
- | 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: | ||
- | padding: 20px; | ||
- | z-index: 2; | ||
- | left: 17px; | ||
- | background: | ||
- | } | ||
- | .main-navigation ul li:hover ul.sub-menu { | ||
- | opacity: 1; | ||
- | transition: | ||
- | } | ||
- | </ | ||
- | |||
- | responsive grid layout | ||
- | < | ||
- | ul { | ||
- | display: grid; | ||
- | grid-gap: 50px 40px; | ||
- | grid-template-columns: | ||
- | } | ||
- | </ | ||
===== php ===== | ===== php ===== | ||
enable debugging / error log | enable debugging / error log | ||
Line 746: | Line 746: | ||
</ | </ | ||
===== sql ===== | ===== sql ===== | ||
- | Update field: | ||
- | <code sql> | ||
- | update forwardings set destination=' | ||
- | </ | ||
- | Insert field: | ||
- | <code sql> | ||
- | insert into forwardings (source, destination) VALUES (' | ||
- | insert into forwardings VALUES (' | ||
- | </ | ||
- | Delete row: | ||
- | <code sql> | ||
- | delete from domains where domain=' | ||
- | </ | ||
<code sql> | <code sql> | ||
mysql> \P / | mysql> \P / | ||
Line 803: | Line 790: | ||
UPDATE wp_options SET option_value = ' | UPDATE wp_options SET option_value = ' | ||
</ | </ | ||
- | ==== postgresql ==== | ||
- | drop database | ||
- | <code bash> | ||
- | sudo -u postgres -i | ||
- | dropdb onlyoffice | ||
- | </ | ||
- | |||
- | list databases | ||
- | < | ||
- | psql# \l | ||
- | </ | ||
- | |||
- | create and delete user | ||
- | < | ||
- | DROP ROLE gitlab; | ||
- | CREATE USER gitlab WITH PASSWORD ' | ||
- | </ | ||
- | |||
- | grant permissions | ||
- | < | ||
- | ALTER USER gitlab SUPERUSER; | ||
- | CREATE DATABASE gitlabhq_production OWNER gitlab; | ||
- | ALTER DATABASE gitlabhq_production OWNER TO gitlab; | ||
- | </ |
onny/notizen/programmierung.1666695513.txt.gz · Last modified: 2022/10/25 10:58 by 10.100.0.1