Matt Henkel guildencrantz

## XCode .gitignore
_Store
*.swp
*~.nib
._*

build/
*.xcodeproj/*
!*.xcodeproj/project.pbxproj

## C# Operating System Check
C# (Mono and .Net) Operating System runtime version check: parse Environment.OSVersion.ToString().

http://www.developmentnow.com/g/36_2003_12_0_0_203951/Detecting-OS-mono-NET.htm

## List Oracle Tables
SELECT * FROM all_tables; <- all tables you have access to
SELECT * FROM user_tables; <- all tables owned by currently logged in user
SELECT * FROM dba_tables; <- all tables in database

And, to desc a table through jdbc:
select COLUMN_NAME, DATA_TYPE, DATA_LENGTH, NULLABLE from USER_TAB_COLUMNS where TABLE_NAME='mytable' order by column_id;

## KeePass 2 Target Window Regex (Prod)
//(?<!((int)|(tst)|(dev))((\.lan)|(\.dfs))?)\.returnpath\.net\(mhenkel\)://

## Bash Default Variable Value
output=${1-text}
echo $output

## vimrc save scripts as executable
au BufWritePost * if getline(1) =~ "^#!" | if getline(1) =~ "/bin/" | silent !chmod +x <afile> | endif | endif

## Delete overwrites
grep "X-MailPolish: " */header.txt | awk '{ print $2; }' | uniq -d | xargs -I{} grep -l -m 1 {} */header.txt | xargs -I{} dirname {} | xargs | awk '{ for (i=1; i<NF; i++) { print "deleting " $i; system("sudo rm -rf " $i); }}'

## Watch Render Queues
for i in *; do echo $i " " `ls -1 $i/new | wc -l`; done | sort -nrk 2

## gist:976812
:w !sudo tee %

## .bashrc
PS1="\n\[\e[0m\][\[\e[32m\]\u\[\e[0m\]@\[\e[36m\]\h\[\e[0m\] \[\e[35m\](\t)\[\e[0m\]:\[\e[33m\]\w\[\e[0;31m\]\$(__git_ps1 ' (%s)')\[\e[0m\]]\n\\$ "
	_Store
	*.swp
	*~.nib
	._*

	build/
	.xcodeproj/
	!*.xcodeproj/project.pbxproj
	C# (Mono and .Net) Operating System runtime version check: parse Environment.OSVersion.ToString().

	http://www.developmentnow.com/g/36_2003_12_0_0_203951/Detecting-OS-mono-NET.htm
	SELECT * FROM all_tables; <- all tables you have access to
	SELECT * FROM user_tables; <- all tables owned by currently logged in user
	SELECT * FROM dba_tables; <- all tables in database

	And, to desc a table through jdbc:
	select COLUMN_NAME, DATA_TYPE, DATA_LENGTH, NULLABLE from USER_TAB_COLUMNS where TABLE_NAME='mytable' order by column_id;