Skip to content

Instantly share code, notes, and snippets.

View saerdnaer's full-sized avatar

Andreas Hubel saerdnaer

71 followers · 43 following
View GitHub Profile
@saerdnaer
saerdnaer / items_by_ids.sql
Last active December 12, 2022 22:52
CREATE INDEX "items_alternate_ids_idx" ON "items" USING GIN ("alternate_ids");
CREATE OR REPLACE FUNCTION items_by_ids(ids text[], is_published boolean DEFAULT NULL)
RETURNS SETOF items
AS $$
SELECT items.*
FROM unnest($1) WITH ORDINALITY t(value, ord), items
WHERE (
items.core_id = t.value
OR items.id = CASE WHEN isnumeric(t.value) THEN t.value::integer ELSE null END
@saerdnaer
saerdnaer / parse-wordpress-usermeta.php
Created April 7, 2021 23:57
<?php
/*
SELECT meta_value, u.user_login, u.user_registred, u.display_name
FROM wp_usermeta um LEFT JOIN wp_users u ON u.id = um.user_id
WHERE um.meta_key = 'session_tokens';
*/
$file = file('wp-usermeta.csv');
@saerdnaer
saerdnaer / yt2text.py
Last active May 29, 2021 08:09
download german transcript from youtube and convert to better readable text
'''
Downloads YouTube subtitles to human readable text, while fixing casing of german words.
Example usage:
python3 yt2text.py _RlwgfYd65Q > ultraschall5.txt
'''
import argparse
from youtube_transcript_api import YouTubeTranscriptApi
@saerdnaer
saerdnaer / control-display.sh
Last active January 12, 2020 17:49
control hdmi display via cec from raspberry pi
#/bin/bash
# see https://www.screenly.io/blog/2017/07/02/how-to-automatically-turn-off-and-on-your-monitor-from-your-raspberry-pi/#cec-client
# and crontab -e (of user "pi") --Andi
case "$1" in
on)
echo 'on 0' | cec-client -s -d 1
;;
off)
echo 'standby 0' | cec-client -s -d 1
@saerdnaer
saerdnaer / api.php
Created November 9, 2017 21:21
<?php
define('DOKU_INC', '../dokuwiki/');
define('DOKU_PLUGIN', '../');
require_once(DOKU_INC . 'inc/load.php');
require_once(DOKU_PLUGIN.'sqlite/helper.php');
class data_api {
@saerdnaer
saerdnaer / controllers.application.js
Last active August 28, 2017 12:25
ember-paper bug: button inside of leaflet opup
import Ember from 'ember';
export default Ember.Controller.extend({
appName: 'Ember Twiddle'
});
@saerdnaer
saerdnaer / gist:bf674dd0f6bb6090f6e6a2ec29cc942e
Last active May 8, 2016 12:14
# coding=utf-8
import config
from flask import Flask, Response, request, json
import requests
import ssl
app = Flask(__name__)
@saerdnaer
saerdnaer / gist:946d9d3fc2e936143646
Last active January 31, 2016 21:41
# basiert auf https://twitter.com/realgiggls/status/693081083211051008
date
for ((i=25;i>0;i--)); do
echo $i
sleep 60
done
say -v Anna "Timer abgelaufen"
xmessage "Timer abgelaufen $(date '+%H:%m')"
@saerdnaer
saerdnaer / convert.py
Last active January 13, 2016 17:28
# -*- coding: UTF-8 -*-
#import requests
import json
from collections import OrderedDict
def main():
data = None
session = "7306" #wget https://lab.dsst.io/32c3-slides/slides/7306.json
@saerdnaer
saerdnaer / engel-auswerung.py
Created January 8, 2016 19:14
from collections import OrderedDict
import json
def main():
#https://engelsystem.de/31c3/?p=shifts_json_export&key=7ae550dcafee0f084dc4e76d6d3088ca
#&start_day=2014-12-27&start_time=00%3A00&end_day=2014-12-30&end_time=23%3A59
#&rooms[]=25&rooms[]=20&rooms[]=7&rooms[]=26&rooms[]=12&rooms[]=10&rooms[]=8&rooms[]=9&rooms[]=13&rooms[]=2&rooms[]=3&rooms[]=19&rooms[]=21&rooms[]=18&rooms[]=6&rooms[]=4&rooms[]=22&rooms[]=5&rooms[]=16&rooms[]=17&rooms[]=15&rooms[]=24&rooms[]=14&rooms[]=32&rooms[]=33&rooms[]=28&rooms[]=34&rooms[]=11&rooms[]=31&rooms[]=23
#&types[]=34&types[]=33&types[]=11&types[]=12
#&types[]=4&filled[]=1&filled[]=0&export=user_shifts