Skip to content

Instantly share code, notes, and snippets.

View nad2000's full-sized avatar
🇳🇿
Working from New Zealand

Radomirs Cirskis nad2000

🇳🇿
Working from New Zealand
19 followers · 67 following
View GitHub Profile
@nad2000
nad2000 / obfuscate_emails.sql
Last active July 3, 2025 00:39
Obfuscate email addrsses in a clone of a production data base
-- Create email list:
WITH v AS (SELECT
'SELECT ' || C.COLUMN_NAME || ', left(' || C.COLUMN_NAME || ', 1)||left(md5(' || C.COLUMN_NAME || '), 16)||''@mailinator.com'' FROM ' || C.TABLE_NAME || CASE
WHEN (ROW_NUMBER() OVER ()) = 1 THEN ''
ELSE ' UNION '
END AS st
FROM
INFORMATION_SCHEMA.COLUMNS AS C
WHERE
C.COLUMN_NAME ~ 'email'
@nad2000
nad2000 / signals.go
Created April 16, 2025 23:22
Using SIGINT to gracefully shut down a service
package main
import (
"fmt"
"os"
"os/signal"
"time"
)
func main() {
@nad2000
nad2000 / delete_records.sh
Created February 26, 2025 02:14
How to delete Sqlite3 records that violatie referencial integrity
sqlite3 db.sqlite3 'pragma foreign_key_check;' | tail -n +3 | sed 's/\(\w*\)\s*\(\w*\).*/delete from \1 where id=\2;/' | sqlite3 db.sqlite3
@nad2000
nad2000 / fastest_mirrors.sh
Last active April 19, 2025 12:35
Find the best Arch Linux mirrors (repositories) #arch #mirrors #repo
sudo reflector -c NZ -c AU -c SG -p https -a 12 --sort rate --save /etc/pacman.d/mirrorlist && cat /etc/pacman.d/mirrorlist
@nad2000
nad2000 / create_directories_in_loop.sh
Created June 2, 2020 10:32
create a list of directories in loop
i in {6..20} ; do mkdir $(printf '%02d\n' $i) ; done
@nad2000
nad2000 / queue_and_threading_demo.py
Created November 26, 2018 05:47
queue and threading demo
from time import sleep
from queue import Queue
from threading import Thread
q = Queue(2)
Thread(target=lambda:(sleep(10), q.put(42))).start()
q.get()
@nad2000
nad2000 / jmeter.sh
Created October 29, 2018 11:30
./apache-jmeter-4.0/bin/jmeter.sh -n -t ./load_test/simple.jmx
@nad2000
nad2000 / mutable.py
Created July 29, 2018 11:21
Python tricks
visited = [[False] * m] * n
visited
=> [[False, False, False, False], [False, False, False, False], [False, False, False, False]]
visited[0]
=> [False, False, False, False]
visited[0][0]
@nad2000
nad2000 / slowest.sh
Created July 6, 2018 00:27
TOP 12 slowest requests form Apache access_log
# Make sure you are collectin the time it takes to hadle the request
# LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-agent}i\" %D" combined_with_response_time
# CustomLog logs/access_log combined_with_response_time
grep -E $(cut -d\ -f 21 access_log | sort -n | tail -12 | tr -d '\r' | tr '\n' '|')99999 orcidhub_log
@nad2000
nad2000 / bash-history-to-zsh-history.py
Created September 5, 2017 07:24
migrate bash history to zsh...
#!/usr/bin/env python
# -*- coding: utf-8 -*-
HOME = os.path.join(home = expanduser("~")
import sys, os
def main():
bash_history = open(os.path.join(HOME, ".bash_history"), 'r')
zsh_history = open(os.path.join(HOME, ".zsh_history"), 'a')