README is empty
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATE kort.user | |
SET name = sub.name, | |
username = sub.username, | |
koin_count = sub.koin_count, | |
token = sub.token, | |
oauth_provider = sub.oauth_provider, | |
oauth_user_id = sub.oauth_user_id, | |
pic_url = sub.pic_url, | |
secret = sub.secret | |
FROM (SELECT name, username, koin_count, token, oauth_provider, oauth_user_id, pic_url, secret |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# create a new DB dump | |
mysqldump -u USERNAME -p --skip-extended-insert --skip-quick DB_NAME > dump.sql | |
# replace the domain name in the dump, this is needed if you plan to use the dump on another domain | |
sed 's/www\.example\.com/stage.example.com/g' < dump.sql > updated_dump.sql | |
# optional: re-create the database | |
mysql -u root -e"show databases;" | grep DB_NAME && mysql -u root -e"drop database DB_NAME;" | |
mysql -u root -e"create database DB_NAME;" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Named regex groups | |
import re | |
sentence = "\"The Hitchhiker's Guide to the Galaxy\" was published in 1979" | |
regex = "\"([\w ']+)\" was published in (\S+)" | |
print "find_all: %s"%(re.findall(regex, sentence)) | |
match = re.search("\"(?P<book>[\w ']+)\" was published in (?P<year>\S+)", sentence) | |
print "match groups: %s"%(str(match.groups())) | |
print "match group1: %s"%(str(match.group(1))) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
/** | |
* WordPress Query Comprehensive Reference | |
* Compiled by luetkemj - luetkemj.com | |
* | |
* CODEX: http://codex.wordpress.org/Class_Reference/WP_Query#Parameters | |
* Source: https://core.trac.wordpress.org/browser/tags/3.9/src/wp-includes/query.php | |
*/ | |
$args = array( |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* Caluculate quartiles to get limits */ | |
proc univariate data=work.ZaehlstelleZeit_&num. noprint; | |
var AnzFahrzeuge; | |
output out=work.ZaehlstelleStat_&num. p25=q1 p75=q3; | |
run; | |
data work.ZaehlstelleStat_&num.; | |
set work.ZaehlstelleStat_# | |
ZSID = "&name"; | |
iqr = q3 - q1; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# This script shows how to authenticate with OAuth2 with a backend application | |
# The token is saved to disk in $HOME/.osmapi/token.json and can be reused until it's revoked or expired. | |
# install oauthlib for requests: pip install oauthlib requests-oauthlib | |
from requests_oauthlib import OAuth2Session | |
import json | |
import webbrowser | |
import osmapi | |
from dotenv import load_dotenv, find_dotenv | |
import os |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// ==UserScript== | |
// @name E3 Improver | |
// @namespace https://metaodi.ch | |
// @version 0.28 | |
// @description Make E3 even better :) | |
// @author Stefan Oderbolz | |
// @match https://e3online.prd.szh.loc/ | |
// @icon https://www.google.com/s2/favicons?sz=64&domain=szh.loc | |
// @grant GM_setValue | |
// @grant GM_getValue |
OlderNewer