aks

-- this query will probe all tables for any ID columns prefixed with "new_" that are different
-- than the corresponding original columns.
-- it reports the tables containing such columns as they are being checked
DO $$
DECLARE
  temp record;
  stmt varchar;
  recs integer;
BEGIN
  FOR temp IN

aks

#!/usr/bin/env bash
# run-migrations-singly

PROG=${0##*/}
DIR=${0%/*}

export PATH=$PATH:$HOME/bin:$HOME/lib
# see github.com/aks/bash-lib
source talk-utils.sh
source run-utils.sh

aks

#!/usr/bin/env bash
# squash-all [BASE_BRANCH]

PROG="${0##*/}"
DIR="${0%/*}"

talk() { echo 1>&2 "$*" ; }
vtalk() { (( verbose )) && talk "$*" ; }
error() { talk "$*" ; exit 1 ; }

aks

#!/bin/bash
PROG="${0##*/}"

def_config="-C config/sidekiq.yml"
def_log="-L log/sidekiq.log"
def_pid="-P tmp/pids/sidekiq.pid"
def_queue="-q data_migration"

usage() {
  cat <<MSG

aks

#!/usr/bin/env bash
# collect-bucket-info
PROG="${0##*/}"
DIR="${0%/*}"

usage() {
  cat 1>&2 <<EOF
usage: $PROG [options]
This script collects bucket names and encryption configuration for each bucket, and produces
a report of the differences against the previous run.  If -m ADDR is given, the report is

aks

#!/usr/bin/env ruby
#
# THOR template

$PROG = File.basename($PROGRAM_NAME)
$DIR  = File.dirname($PROGRAM_NAME)

# Possibly modify the LOAD_PATH
# $LOAD_PATH << File.join(__dir__, '..', 'lib/migrations')

aks

ActiveRecord::Migration API Notes

The ActiveRecord::Migration class is used to manage Rails migration scripts. When writing these scripts, there are many class methods that can be used to make schema changes, which are described below in several sections.

Migration Methods

Create Methods	Arguments	Notes	Rev
create_join_table	table1, table2, options	Creates a join table	Y
create_table	name, options	Creates a table	Y

aks

#!/bin/bash

# wanted to remove "doc" directory and all of it's contents
git filter-branch -f --index-filter 'git rm --cached --ignore-unmatch -r -f doc'

aks

#!/usr/bin/env bash
# my-script some-args

# set the name and directory of this program
PROG="${0##*/}"
DIR="${0%/*}"

# include ~/bin and ~/lib to get my bash scripts
export PATH=$PATH:$HOME/bin:$HOME/lib

aks

-- 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%'