fy2

#!/opt/tools/bin/perl

use strict;
use warnings;
use Getopt::Long;
use Pod::Usage;

use Foo::Bar;

# Parse the command line options:

fy2

#!/bin/bash

# This script will open all files from a git diff or a git show in vim.

# My bash skills are a bit primitive so this can probably be done more intelligently

# Usage:
#   gitopen -- opens all added files that have changed since HEAD
#   gitopen diff HEAD -- these are the default parameters
#   gitopen diff master -- opens files that have changed from master

fy2

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), 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(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

fy2

#!/bin/sh

matches=$(git diff --cached | grep -E '\+.*?FIXME')

if [ "$matches" != "" ]
then
        echo "'FIXME' tag is detected."
        echo "Please fix it before committing."
        echo "  ${matches}"
        exit 1

fy2

[client]
user = root
password = root
[mysql]
pager = vim -

fy2

# shortform git commands
alias g='git'

# cherry pick range of commits, starting from the tip of 'master', into 'preview' branch
git rev-list --reverse --topo-order master... | while read rev; do git checkout preview; git cherry-pick $rev || break; done

# create tracking branches for all remote branches
git branch -a | grep -v HEAD | perl -ne 'chomp($_); s|^\*?\s*||; if (m|(.+)/(.+)| && not $d{$2}) {print qq(git branch --track $2 $1/$2\n)} else {$d{$_}=1}' | csh -xfs;

# git reset newly added files