Skip to content

Instantly share code, notes, and snippets.

@gabrielke
gabrielke / gist:abde69e2def47f8f97846392ae066f4d
Last active October 30, 2023 05:19
Home assistant repair sequences
select setval ('event_data_data_id_seq',(select max(data_id) from event_data ));
select setval ('event_types_event_type_id_seq',(select max(event_type_id) from event_types ));
select setval ('events_event_id_seq',(select max(event_id) from events ));
select setval ('recorder_runs_run_id_seq',(select max(run_id) from recorder_runs ));
select setval ('schema_changes_change_id_seq',(select max(change_id) from schema_changes ));
select setval ('state_attributes_attributes_id_seq',(select max(attributes_id) from state_attributes ));
select setval ('states_meta_metadata_id_seq',(select max(metadata_id) from states_meta ));
select setval ('states_state_id_seq',(select max(state_id) from states ));
select setval ('statistics_id_seq',(select max(id) from "statistics" ));
select setval ('statistics_meta_id_seq',(select max(id) from statistics_meta ));
@gabrielke
gabrielke / gist:83bd67ad2f1ea7365bdd9f5f6e5e1d6a
Created November 16, 2021 22:15
jmeter if controller groovy expression
${__groovy("${cart_id}"!="")}
${__groovy("${cart_id}"=="")}
and the cart_id user defined variable has to be defined
@gabrielke
gabrielke / gist:b4b28fa2ce59f6a9b39a424b0f049d20
Created November 8, 2021 14:12
git hist with light colors
git config --global alias.hist "log --pretty=format:'%C(yellow)[%ad]%C(reset) %C(green)[%h]%C(reset) | %C(white)%s %C(bold white){{%an}}%C(reset) %C(cyan)%d%C(reset)' --graph --date=short"
@gabrielke
gabrielke / launch.json
Created October 3, 2021 13:00
Visual Studio Code C99 development on Mac M1
{
// Use IntelliSense to learn about possible attributes.
// Hover to view descriptions of existing attributes.
// For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387
"version": "0.2.0",
"configurations": [
{
"name": "clang - Build and debug active file",
"type": "cppdbg",
"request": "launch",
find . -maxdepth 1 -type d -exec du -sh {} \;|sort -h
@gabrielke
gabrielke / backup-docker-secrets.sh
Created March 14, 2021 07:27 — forked from kwonghung-YIP/backup-docker-secrets.sh
Shell script for export all secrets defined in docker swarm
#!/bin/bash
service_name="backup-all-secrets"
secret_list=( `docker secret ls --format "{{ .Name }}"` )
cmd="docker service create \
--name $service_name \
--constraint node.hostname==`hostname` "
for secret in "${secret_list[@]}"
@gabrielke
gabrielke / route.conf
Created December 19, 2020 09:09
hetzner_proxmox_sysctl
net.ipv4.ip_forward=1
net.ipv6.conf.all.forwarding=1
net.ipv4.conf.all.send_redirects=0
@gabrielke
gabrielke / createdir.sh
Created April 23, 2020 14:57
bash create folder with timestamp as name
DN=`date "+%y%m%d-%H%M%S"`
mkdir $DN
@gabrielke
gabrielke / gist:95810a4d034f9e34e89c4d204d94c263
Created April 15, 2020 20:41
docker run different entrypoint
docker run -it --entrypoint=sh justb4/jmeter:5.1.1a
@gabrielke
gabrielke / gist:8d4cf05bac69c89d118f9bc81ce61408
Created April 9, 2020 19:32
Create bootable USB from CDROM-only ISO
apt install genisoimage
geteltorito -o bios.img oldschool_bios_updater.iso
dd if=bios.img of=usb-stick status=progress conv=sync