Adam Zwakenberg adamzwakk

## pgsqlvacuumstat.sh
#!/bin/bash

PGSQL_HOST="localhost"
PGSQL_PORT="5432"
PGSQL_DATABASE="postgres"
PGSQL_USERNAME="postgres"
export PGPASSWORD="passwd"
TMP_FILE="/tmp/pgsqlchk.out"
ERR_FILE="/tmp/pgsqlchk.err"
HOST=$(hostname)

## pg_recovery_progress.sh
ls -l $(sudo lsof -p $(ps aux | grep postgres | grep startup | awk '{print $2}') | grep wal | awk '{print $9}') | awk '{print $6" "$7" "$8}'

## slackpost.sh
#!/bin/bash

## Defaults
SLACK_TOKEN="YOUR TOKEN"
CHANNEL="YOUR CHANNEL"
IN=""
MESS=""

while getopts c:m: flag
do

## get_blocking_queries.sh
#!/bin/bash

PGSQL_HOST="localhost"
PGSQL_PORT="5432"
PGSQL_DATABASE="postgres"
PGSQL_USERNAME="postgres"
export PGPASSWORD="passwd"
xmins=()
queries=""

## nb_get.py
import requests
import json

s = requests.Session()
resp = s.get('{notebook URL}/login', verify = False)
xsrf_cookie = resp.cookies['_xsrf']

params = {'_xsrf':xsrf_cookie,'password': '{notebook password}'}
l = s.post('{notebook URL}/login?next=/api/sessions', data=params, verify = False, allow_redirects=True).json()

## psqlactiveq.sh
#!/bin/bash

PGSQL_HOST="localhost"
PGSQL_PORT="5432"
PGSQL_DATABASE="postgres"
PGSQL_USERNAME="postgres"
export PGPASSWORD="passwd"
THISHOST=`hostname`
INFLUXLINES=""

## UT2004SetupPublicDLs.sh
compress_ut_file() {
  f=$(basename $1)
  if [ ! -d "$file" -a ! -f "/var/www/ut2004/${f}.uz2" ] && [ "$file" != "*" ]; then
    ./ucc-bin compress -nohomedir $1
    mv "${1}.uz2" /var/www/ut2004/
  fi
}

export -f compress_ut_file

## generate-map.js
// node .\tools\generate-map.js --bigfile .\src\fullmap.jpg --endpath .\public\grid\ --zoom 7

const fs = require('fs');
const sharp = require('sharp');
const argv = require('yargs').argv;
const _cliProgress = require('cli-progress');

const endPresentFile = argv.bigfile;
const gridPath = argv.endpath;
const bar1 = new _cliProgress.SingleBar({}, _cliProgress.Presets.shades_classic);

## backlight.sh
#!/bin/bash

# You can call this script like this:
# $./backlight.sh up
# $./backlight.sh down

function get_brightness {
    cat /sys/class/backlight/intel_backlight/brightness;
}

## volume.sh
#!/bin/bash

# You can call this script like this:
# $./volume.sh up
# $./volume.sh down
# $./volume.sh mute

function get_volume {
    amixer get Master | grep '%' | head -n 1 | cut -d '[' -f 2 | cut -d '%' -f 1
}
	#!/bin/bash

	PGSQL_HOST="localhost"
	PGSQL_PORT="5432"
	PGSQL_DATABASE="postgres"
	PGSQL_USERNAME="postgres"
	export PGPASSWORD="passwd"
	TMP_FILE="/tmp/pgsqlchk.out"
	ERR_FILE="/tmp/pgsqlchk.err"
	HOST=$(hostname)
	#!/bin/bash

	## Defaults
	SLACK_TOKEN="YOUR TOKEN"
	CHANNEL="YOUR CHANNEL"
	IN=""
	MESS=""

	while getopts c:m: flag
	do
	import requests
	import json

	s = requests.Session()
	resp = s.get('{notebook URL}/login', verify = False)
	xsrf_cookie = resp.cookies['_xsrf']

	params = {'_xsrf':xsrf_cookie,'password': '{notebook password}'}
	l = s.post('{notebook URL}/login?next=/api/sessions', data=params, verify = False, allow_redirects=True).json()
	compress_ut_file() {
	f=$(basename $1)
	if [ ! -d "$file" -a ! -f "/var/www/ut2004/${f}.uz2" ] && [ "$file" != "*" ]; then
	./ucc-bin compress -nohomedir $1
	mv "${1}.uz2" /var/www/ut2004/
	fi
	}

	export -f compress_ut_file
	// node .\tools\generate-map.js --bigfile .\src\fullmap.jpg --endpath .\public\grid\ --zoom 7

	const fs = require('fs');
	const sharp = require('sharp');
	const argv = require('yargs').argv;
	const _cliProgress = require('cli-progress');

	const endPresentFile = argv.bigfile;
	const gridPath = argv.endpath;
	const bar1 = new _cliProgress.SingleBar({}, _cliProgress.Presets.shades_classic);
	#!/bin/bash

	# You can call this script like this:
	# $./backlight.sh up
	# $./backlight.sh down

	function get_brightness {
	cat /sys/class/backlight/intel_backlight/brightness;
	}
	#!/bin/bash

	# You can call this script like this:
	# $./volume.sh up
	# $./volume.sh down
	# $./volume.sh mute

	function get_volume {
	amixer get Master \| grep '%' \| head -n 1 \| cut -d '[' -f 2 \| cut -d '%' -f 1
	}