Khaliq khaliqgant

## install.bash
npm install nango@npm:@nangohq/cli@0.0.1-2e8ad3b5da52183bc8d2644594adcc52e3d1ad83

Installs the package nangohq/cli@0.0.1... under the alias nango

## info.sheet
=C8*GOOGLEFINANCE("CURRENCY:ILSUSD")

## action.yaml
"contains(github.event.head_commit.message, 'deploy!')"

# https://stackoverflow.com/questions/63619329/github-action-get-commit-message

## files.bash
git rev-list --objects --all |
  git cat-file --batch-check='%(objecttype) %(objectname) %(objectsize) %(rest)' |
  sed -n 's/^blob //p' |
  sort --numeric-sort --key=2 |
  cut -c 1-12,41- |
  $(command -v gnumfmt || echo numfmt) --field=2 --to=iec-i --suffix=B --padding=7 --round=nearest


# source https://stackoverflow.com/questions/10622179/how-to-find-identify-large-commits-in-git-history

## resize.bash
# mount temp
sudo mount -o size=10M,rw,nodev,nosuid -t tmpfs tmpfs /tmp

# Resize root volume, find correct name by running lsblk
sudo growpart /dev/nvme0n1 1
sudo resize2fs /dev/root

# Resize data volume
sudo resize2fs /dev/nvme1n1

## snip.py
print(queryset.query)

## issue.sh
gh issue create --title "My new issue" --body "Here are more details." --assignee @khaliqgant --project "Web Development Sprint"

# the cli only supports classic projects for now: https://github.com/cli/cli/issues/4547

# docs: https://cli.github.com/manual/gh_issue_create

## cp.bash
aws s3 cp --sse AES256 s3://my-bucket/image/p_2/1647967203002.jpg s3://images-production/p_3/1647967203002.jpg

## upgrade.bash
# check expiration
kubeadm alpha certs check-expiration

kubeadm alpha certs renew all
cp -i /etc/kubernetes/admin.conf $HOME/.kube/config

# https://stackoverflow.com/questions/49885636/kubernetes-expired-certificate

## kill.sql
SELECT * FROM pg_stat_activity WHERE state = 'active';

SELECT pg_cancel_backend(<PID>);

SELECT pg_terminate_backend(<PID>);


-- kill all active except active one
SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
	npm install nango@npm:@nangohq/cli@0.0.1-2e8ad3b5da52183bc8d2644594adcc52e3d1ad83

	Installs the package nangohq/cli@0.0.1... under the alias nango
	"contains(github.event.head_commit.message, 'deploy!')"

	# https://stackoverflow.com/questions/63619329/github-action-get-commit-message
	git rev-list --objects --all \|
	git cat-file --batch-check='%(objecttype) %(objectname) %(objectsize) %(rest)' \|
	sed -n 's/^blob //p' \|
	sort --numeric-sort --key=2 \|
	cut -c 1-12,41- \|
	$(command -v gnumfmt \|\| echo numfmt) --field=2 --to=iec-i --suffix=B --padding=7 --round=nearest


	# source https://stackoverflow.com/questions/10622179/how-to-find-identify-large-commits-in-git-history
	# mount temp
	sudo mount -o size=10M,rw,nodev,nosuid -t tmpfs tmpfs /tmp

	# Resize root volume, find correct name by running lsblk
	sudo growpart /dev/nvme0n1 1
	sudo resize2fs /dev/root

	# Resize data volume
	sudo resize2fs /dev/nvme1n1
	gh issue create --title "My new issue" --body "Here are more details." --assignee @khaliqgant --project "Web Development Sprint"

	# the cli only supports classic projects for now: https://github.com/cli/cli/issues/4547

	# docs: https://cli.github.com/manual/gh_issue_create
	# check expiration
	kubeadm alpha certs check-expiration

	kubeadm alpha certs renew all
	cp -i /etc/kubernetes/admin.conf $HOME/.kube/config

	# https://stackoverflow.com/questions/49885636/kubernetes-expired-certificate
	SELECT * FROM pg_stat_activity WHERE state = 'active';

	SELECT pg_cancel_backend(<PID>);

	SELECT pg_terminate_backend(<PID>);


	-- kill all active except active one
	SELECT pg_terminate_backend(pid)
	FROM pg_stat_activity