Skip to content

Instantly share code, notes, and snippets.

@Wikinaut
Wikinaut / fax-a-video.sh
Last active December 19, 2022 19:23
fax-a-video
#!/bin/bash
# Script to create one or more images of a number n of equally spaced frames of video.
# Adding a caption with a prefix and counting number.
# this version 20221219
# init 20210321
# Licence: WTFPL
@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 / patch-parsed-twitter-archive.sh
Last active December 19, 2022 12:10
patch-parsed-twitter-archive
#!/usr/bin/bash
# Patch parsed Twitter Archiv Parser
# To clarify: the script does not patch the parser, but the twitter-archive-parser-parsed archive
# It is not modifying the parsed files themselves, but creating copies with the extension .body
# Postprocessor for files generated by https://github.com/timhutton/twitter-archive-parser
# init 18.12.2022
@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 / 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.