adi leveled

leveled / insert_dict_into_sql_table.py

Created December 20, 2021 18:28

Using python to insert a dictionary into an SQL table

	placeholders = ', '.join(['%s'] * len(myDict))
	columns = ', '.join(myDict.keys())
	sql = "INSERT INTO %s ( %s ) VALUES ( %s )" % (table, columns, placeholders)
	# valid in Python 2
	cursor.execute(sql, myDict.values())
	# valid in Python 3
	cursor.execute(sql, list(myDict.values()))

leveled / run_32_on_64_linux.sh

Created December 19, 2021 01:42

Run 32 bit programs on 64 bit Linux machines

	sudo apt-get update
	sudo apt-get dist-upgrade

	sudo dpkg --add-architecture i386
	sudo apt-get update

	dpkg --print-foreign-architectures
	sudo dpkg --remove-architecture i386

leveled / files_modified_in_commit.sh

Created December 17, 2021 18:39

Find files affected by a commit from an id with Git

	#programmatic way
	$ git diff-tree --no-commit-id --name-status -r bd61ad98
	index.html
	javascript/application.js
	javascript/ie6.js

	#user facing way
	$ git show --pretty="" --name-only bd61ad98
	index.html
	javascript/application.js

leveled / bytes_to_hex_string.py

Created December 14, 2021 01:24

convert bytes to hex string and vice-versa

leveled / print_raw_bytes.py

Created December 13, 2021 13:49

Print raw bytes to stdout with python

	import sys

	sys.stdout.buffer.write(bytes([0xAA]))

leveled / print_without_newline.py

Created December 13, 2021 13:38

Print without newline in python

print("Hello there!", end = '')

leveled / grep_in_gdb.sh

Created December 13, 2021 00:14

Grep in GDB

	(gdb) set logging on
	(gdb) print *this
	(gdb) set logging off
	(gdb) shell grep attribute gdb.txt

leveled / cross_compile_run_arm64.sh

Created December 12, 2021 01:50

Install cross-compile libs and run ARM64 binaries

	sudo apt update -y && sudo apt upgrade -y
	sudo apt install qemu-user qemu-user-static gcc-aarch64-linux-gnu binutils-aarch64-linux-gnu binutils-aarch64-linux-gnu-dbg build-essential

	#compile statically
	aarch64-linux-gnu-gcc -static -o hello64 hello.c

	#compile dynamically
	aarch64-linux-gnu-gcc -o hello64dyn hello64.c
	qemu-aarch64 -L /usr/aarch64-linux-gnu ./hello64dyn

leveled / retrieve_hostname_from_ssh_config.sh

Created December 8, 2021 00:38

Retrieve hostname information from SSH config

ssh -G database | awk '/^hostname / { print $2 }'

leveled / delete_extended_attributes_from_directory.sh

Created November 13, 2021 18:24

Delete extended attributes from a directory

sudo xattr -r -d com.apple.quarantine <directory>