Andy Robb arobb

## BigQuery-Load-Troubleshooting
# s is the offset provided in the BQ load error
# filename.ext is your file's name
python -c "s=12345; f=open('filename.ext'); f.seek(s); print(f.readline())"

## bash-applog-example.sh
# Logging
OFF=0
FATAL=100
ERROR=200
WARN=300
INFO=400
DEBUG=500
TRACE=600
ALL=1000000

## Check if command exists
if command -v echo >/dev/null; then echo "exists"; else echo "doesn't exist"; fi

## tar-and-encrypt
# Include files that have been symlinked
tar -czf backup.tar.gz --dereference ./backup

gpg --armor --output backup.tar.gz.gpg --symmetric --cipher-algo AES256 backup.tar.gz

# Decrypt for a bunch of files
read -s -p "Enter Password: " pw
echo -ne "\033[0K\r"

echo "$pw" | gpg --batch --passphrase-fd 0 --output backup.tar.gz --decrypt backup.tar.gz.gpg

## Rii keyboard type pipe character
Fn + P

## raspbian-build-config.txt
# Done on Debian Stretch
# Configure local user as 'pi'
# Source for build process: https://github.com/RPi-Distro/pi-gen/blob/master/README.md

# Install sudo

# /etc/sudoers.d/010-pi
pi ALL=(ALL) ALL

# Dependencies

## Identify mac vs linux
#
# Determine which OS we are in
#
platform='unknown'
unamestr=$(uname)

case $unamestr in
  Darwin)
      platform='mac'
      ;;

## random-text-mac-and-linux.sh
# Bash for macOS and Linux
LC_CTYPE=C tr -cd '[:alnum:]' < /dev/urandom | fold -w30 | head -n1

# Python
import binascii, os
length=10
binascii.b2a_hex(os.urandom(length)).decode('utf-8')[0:length]

## Change MacOS Bash version with MacPorts
# https://apple.stackexchange.com/a/70189
sudo port install bash
Add /opt/local/bin/bash to /etc/shells
chsh -s /opt/local/bin/bash
Open a new tab and check echo $BASH_VERSION

## Arbitrary large random file
https://superuser.com/questions/792427/creating-a-large-file-of-random-bytes-quickly

Slight modification to watch progress
dd if=<(openssl enc -aes-256-ctr -pass pass:"$(dd if=/dev/urandom bs=128 count=1 2>/dev/null | base64)" -nosalt < /dev/zero) \
 bs=1M count=7000 iflag=fullblock \
 | pv -pterb > random-7G.txt
	# s is the offset provided in the BQ load error
	# filename.ext is your file's name
	python -c "s=12345; f=open('filename.ext'); f.seek(s); print(f.readline())"
	# Logging
	OFF=0
	FATAL=100
	ERROR=200
	WARN=300
	INFO=400
	DEBUG=500
	TRACE=600
	ALL=1000000
	# Include files that have been symlinked
	tar -czf backup.tar.gz --dereference ./backup

	gpg --armor --output backup.tar.gz.gpg --symmetric --cipher-algo AES256 backup.tar.gz

	# Decrypt for a bunch of files
	read -s -p "Enter Password: " pw
	echo -ne "\033[0K\r"

	echo "$pw" \| gpg --batch --passphrase-fd 0 --output backup.tar.gz --decrypt backup.tar.gz.gpg
	# Done on Debian Stretch
	# Configure local user as 'pi'
	# Source for build process: https://github.com/RPi-Distro/pi-gen/blob/master/README.md

	# Install sudo

	# /etc/sudoers.d/010-pi
	pi ALL=(ALL) ALL

	# Dependencies
	#
	# Determine which OS we are in
	#
	platform='unknown'
	unamestr=$(uname)

	case $unamestr in
	Darwin)
	platform='mac'
	;;
	# Bash for macOS and Linux
	LC_CTYPE=C tr -cd '[:alnum:]' < /dev/urandom \| fold -w30 \| head -n1

	# Python
	import binascii, os
	length=10
	binascii.b2a_hex(os.urandom(length)).decode('utf-8')[0:length]
	# https://apple.stackexchange.com/a/70189
	sudo port install bash
	Add /opt/local/bin/bash to /etc/shells
	chsh -s /opt/local/bin/bash
	Open a new tab and check echo $BASH_VERSION
	https://superuser.com/questions/792427/creating-a-large-file-of-random-bytes-quickly

	Slight modification to watch progress
	dd if=<(openssl enc -aes-256-ctr -pass pass:"$(dd if=/dev/urandom bs=128 count=1 2>/dev/null \| base64)" -nosalt < /dev/zero) \
	bs=1M count=7000 iflag=fullblock \
	\| pv -pterb > random-7G.txt