Skip to content

Instantly share code, notes, and snippets.

@kenvac
kenvac / .zshrc
Created May 9, 2023 08:59
macOS virtualenv and git branch
# Scripts
parse_git_branch() {
git branch 2> /dev/null | sed -n -e 's/^\* \(.*\)/[\1]/p'
}
COLOR_DEF='%f'
COLOR_USR='%F{243}'
COLOR_DIR='%F{197}'
COLOR_GIT='%F{39}'
NEWLINE=$'\n'
setopt PROMPT_SUBST
@kenvac
kenvac / python guide.md
Created October 4, 2021 15:38 — forked from asaah18/python guide.md
a python guide/cheat-sheet for mind refreshing and looking for specific info

Python Guide

This python guide is intended to those who already know python and want a mind refresh or looking for a specific syntax
-as this guide doesn't elaborate in explaining thing that a programmer would already know -like: variable, function, csv, json-.

additionally, this guide is not intended to be a replacement for reading official Python documentation.

@kenvac
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 <rob@bigfish.co.uk>
# 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
@kenvac
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
kenvac / bbcradiolinks.txt
Last active June 3, 2019 09:37
Online BBC radio links
@kenvac
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
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
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
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 mail@mail.com
gpg --output mygpgkey_sec.gpg --armor --export-secret-key mail@mail.com

Import

gpg --import mygpgkey_pub.gpg
gpg --allow-secret-key-import --import mygpgkey_sec.gpg
@kenvac
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