Skip to content

Instantly share code, notes, and snippets.

@Wikinaut
Wikinaut / strip-metadata.sh
Created December 17, 2022 15:38
strip metadata
#!/usr/bin/bash
# https://stackoverflow.com/questions/38964861/how-to-remove-all-metadata-using-ffmpeg
ffmpeg -i "$1" -c copy -fflags +bitexact -flags:v +bitexact -flags:a +bitexact -write_xing 0 -id3v2_version 0 "${1%.*}.id3stripped.${1#*.}"
@Wikinaut
Wikinaut / extract-audio-strip-metadata.sh
Last active December 19, 2022 17:23
Extract audio from video and strip all metadata
#!/usr/bin/bash
# 20221216 init
# published as https://berlin.social/@wikinaut/109541495757480127
compressionquality="-q:a 7 -joint_stereo 1"
mono="-ac 1"
red="\e[1;31m"
@Wikinaut
Wikinaut / getedekaangebote.js
Last active April 25, 2022 16:00
Get EDEKA Angebote
const puppeteer = require('puppeteer');
/*
node getedekaangebote.js | grep -E -i "bier|pils"
oder
node getedekaangebote.js | \
sed -n -e '/bier\|pils/I{G};x' -e 's/\([0-9]\+\)[.]\([0-9][0-9]\)/\1,\2/;/^$/d;s/EINKAUFSLISTE/---/g' -e '/bier\|pils/I,/---/p' x.txt
@Wikinaut
Wikinaut / add-audio-to-video.sh
Created April 23, 2022 01:34
Add audio to a video, loop the video 2 times
ffmpeg \
-stream_loop 2 \
-i F74.mp4 \
-i "yes-it's-puzzling-i-don't-think-i've-ever-seen-anything-quite-like-this-before.mp3" \
-c copy -map 0:v:0 -c:a aac -map 1:a:0 \
f74puzzling.mp4
#!/usr/bin/bash
# create a semi-transparent circle image with an annotation text
echo "circle <text> <circlesize> <fillcolor> <opacity>"
magick -size "$2"x"$2" \
xc:none -stroke black -strokewidth 2 -fill "$3" \
-draw 'circle %[fx:w/2],%[fx:h/2] %[fx:w/2],%[fx:h]' \
-alpha set -channel A -evaluate Multiply "$4" +channel \
-set pt %[fx:h/1.5] \
# curl -q https://raw.githubusercontent.com/davidak/wortliste/master/wortliste.txt 2>/dev/null | sed -n "s/[Rr]ad/🚲/gp" > rad.txt
Absende🚲resse
Aktions🚲ius
All🚲
All🚲antrieb
All🚲fahrzeug
all🚲getrieben
All🚲ler
Alterskame🚲
@Wikinaut
Wikinaut / wikidata-query-without-and-with-aggregation.txt
Last active December 20, 2021 11:09
Wikidata query with aggregation
Without aggregation. with dates
# Wikidata SPARQL-Query for nuclear power plants, research reactors, waste facilities
# regardless of their status
# one result line per location - check columns count and types
# 20200612 with service entry/retirement dates; no aggregation
# 20200518
# 20200509 initial version
# Paste this code into the code input box of https://query.wikidata.org/
Bkat Stand: 09.11.2021 – 14. Auflage
Quelle: https://www.kba.de/DE/Themen/ZentraleRegister/FAER/BT_KAT_OWI/btkat_node.html
------ Grundregeln - § 1 StVO
TBNR 101000 35,00 €
Sie kamen von der Fahrbahn ab und verursachten Sachschaden.
TBNR 101006 35,00 €
Sie gerieten ins Schleudern und verursachten Sachschaden.
@Wikinaut
Wikinaut / buergerbot.py
Created July 2, 2021 10:26
Bürgeramt-Terminfinder
#!/usr/bin/env python
# kleiner Bürgeramt-Terminfinder
#
# 20210702 init
# basierend auf https://gist.github.com/jaysonsantos/0ef66e0677be32050574
import subprocess
import time
@Wikinaut
Wikinaut / extend-crop-background.sh
Last active April 17, 2021 18:25
Extend (or crop) the canvas background of an image to a multiple of a modulus (such as 32)
#!/bin/bash
if [ $# -lt 1 ]; then
echo "extend-crop-background <imagefile> [modulus [extent]]"
echo "Extend or crop image to a multiple of modulus ±'extent'"
echo
echo "modulus: default 32"
echo "extent: default=modulus"
echo
echo "Examples:"