mattmc3

if object_id('tempdb..#{{table}}') is not null drop table #{{table}}

mattmc3

select pg_terminate_backend(pid) from pg_stat_activity where datname='$DB_NAME';
DROP DATABASE "$DB_NAME";

mattmc3

select 'union all select ''' + isc.COLUMN_NAME + ''' as cn, max(len(' + isc.COLUMN_NAME + ')) as length, ' + convert(varchar(5), isc.CHARACTER_MAXIMUM_LENGTH) + ' as maxlen from {{table}} having max(len(' + isc.COLUMN_NAME + ')) > ' + convert(varchar(5), isc.CHARACTER_MAXIMUM_LENGTH) + ''
from INFORMATION_SCHEMA.COLUMNS isc
where isc.TABLE_NAME = '{{table}}'
and isc.CHARACTER_MAXIMUM_LENGTH is not null

mattmc3

tail -n +2 $FILE > $FILE.new

mattmc3

#!/usr/bin/env bash

mattmc3

#!/usr/bin/env python

mattmc3

#!/usr/bin/env awk -f

mattmc3

find . -type d ! -path "*.git*" -empty -exec touch '{}'/.gitkeep \;

mattmc3

# use .DS_Store as notorious example
find . -type f -name '.DS_Store' -delete

mattmc3

# use infamous .DS_Store as example. Use `-type d` for dirs
find . -type f -name '.DS_Store' -print -exec rm -rf {} \;