kenvac’s gists

kenvac / pyscopg2_decorator.py

Created August 9, 2018 10:57 — forked from travishathaway/pyscopg2_decorator.py

Postgres Connections with Python Decorators

	####################
	# Define Decorator #
	####################
	def psycopg2_cursor(conn_info):
	"""Wrap function to setup and tear down a Postgres connection while
	providing a cursor object to make queries with.
	"""
	def wrap(f):
	@wraps(f)
	def wrapper(args, *kwargs):

kenvac / pgcursor.py

Last active August 9, 2018 11:21

Passing connections to functions using a decorator

	import psycopg2
	from functools import wraps
	from contextlib import contextmanager
	from psycopg2.pool import ThreadedConnectionPool

	PSQL_CONN = {
	'host': '127.0.0.1',
	'port': '5432',
	'user': 'user',
	'password': 'password',

kenvac / addaptkey.sh

Last active August 14, 2018 10:12

Add apt repository key on debian based distro

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 9BDB3D89CE49EC21

kenvac / README.md

Created August 17, 2018 10:03 — forked from franciscocpg/README.md

Export/import gpg key

Export

gpg --output mygpgkey_pub.gpg --armor --export [email protected]
gpg --output mygpgkey_sec.gpg --armor --export-secret-key [email protected]

Import

gpg --import mygpgkey_pub.gpg
gpg --allow-secret-key-import --import mygpgkey_sec.gpg

kenvac / postgres_queries_and_commands.sql

Created August 29, 2018 06:48 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

kenvac / git.txt

Created February 14, 2019 13:27

Git Commands

	========== Delete all merged local branches ==========
	# Courtesy: https://stackoverflow.com/questions/6127328/how-can-i-delete-all-git-branches-which-have-been-merged
	git branch --merged \| egrep -v "(^\*\|master\|dev)" \| xargs git branch -d

	==========Oneline log decorate with stat ==========
	git log --decorate --stat --oneline

kenvac / lock.sql

Last active April 4, 2019 14:35

Lock table postgresql

	-- Lock table db_table in database
	lock TABLE db_table in access exclusive mode ;

kenvac / bbcradiolinks.txt

Last active June 3, 2019 09:37

Online BBC radio links

	# BBC Asian Network
	http://bbcmedia.ic.llnwd.net/stream/bbcmedia_asianet_mf_p
	# BBC Radio 2
	http://bbcmedia.ic.llnwd.net/stream/bbcmedia_radio2_mf_p
	# BBC Radio 6 Music
	http://bbcmedia.ic.llnwd.net/stream/bbcmedia_6music_mf_p
	# BBC Radio One
	http://bbcmedia.ic.llnwd.net/stream/bbcmedia_radio1_mf_p
	# BBC Radio Xtra
	http://bbcmedia.ic.llnwd.net/stream/bbcmedia_radio1xtra_mf_p

kenvac / exportRoles.sql

Last active February 13, 2020 12:55

Export PG roles to new database

	# Debian console command
	$ sudo su postgres
	$ pg_dumpall -v --globals-only -f "/path/to/useraccts.sql"


	# Restore command
	$ psql -h localhost -d postgres -U postgres -f "/path/to/useraccts.sql"

kenvac / git-cleanup-repo

Created September 24, 2021 14:59 — forked from robmiller/git-cleanup-repo

A script for cleaning up Git repositories; it deletes branches that are fully merged into `origin/master`, prunes obsolete remote tracking branches, and as an added bonus will replicate these changes on the remote.

	#!/bin/bash
	# git-cleanup-repo
	#
	# Author: Rob Miller <[email protected]>
	# Adapted from the original by Yorick Sijsling

	git checkout master &> /dev/null

	# Make sure we're working with the most up-to-date version of master.
	git fetch

Kinner Vachhani kenvac

Export

Import