Jay Caines-Gooby jaygooby

## example output
    add_index :attachments, :parent_id
    add_index :attachments, :asset_id
    add_index :domain_names, :user_id
    add_index :domain_names, :event_id
    add_index :event_memberships, :user_id
    add_index :event_memberships, :event_id
    remove_index :attachments, :parent_id
    remove_index :attachments, :asset_id
    remove_index:domain_names, :user_id
    remove_index:domain_names, :event_id

## combine-pdf.sh
#!/bin/bash
#
# Props to http://www.lornajane.net/posts/2011/combining-pdf-files-with-pdftk
# found via http://stackoverflow.com/questions/19122448/bash-escaping-spaces-in-filename-in-variable#comment42365877_19122448
#
# here the sort is used because the pdfs are named something like page 01.pdf page 02.pdf and the -z means the whitespace
# doesn't cause any issues

find ./somepath -name "*.pdf" -print0 | sort -z | xargs -0 -J % pdftk % cat output out.pdf

## s3rep.sh
#!/bin/sh
#
#  S3rep.sh version 1.0
#  Copyright 2009 Matthew Staver
#
#    This program is free software: you can redistribute it and/or modify
#    it under the terms of the GNU General Public License as published by
#    the Free Software Foundation, either version 2 of the License, or
#    (at your option) any later version.
#

## gist:269604
        RED="\[\033[0;31m\]"
     YELLOW="\[\033[0;33m\]"
 	  GREEN="\[\033[0;32m\]"
       BLUE="\[\033[0;34m\]"
  LIGHT_RED="\[\033[1;31m\]"
LIGHT_GREEN="\[\033[1;32m\]"
      WHITE="\[\033[1;37m\]"
 LIGHT_GRAY="\[\033[0;37m\]"
 COLOR_NONE="\[\e[0m\]"


## school_type count
select lea,  SUM(CASE WHEN school_type like '%primary%' THEN 1 ELSE 0 END) as `primary`, SUM(CASE WHEN school_type like '%secondary%' THEN 1 ELSE 0 END) as `secondary` from schools group by lea

## .screenrc
# None of my own work. Munged from various other .screenrc recipes
#
# Don't use CTRL-A as the trigger because its stops the bash
# cli navigation like CTRL-A for start of line to stop working
escape ^Gg

# We'd like to scroll in an xterm please
defscrollback 1024

# http://superuser.com/questions/126606/how-to-get-mac-os-x-terminal-app-and-screen-vim-scrolling-to-play-nice/316900#316900

## Sebastian Coe spam.txt
From: <Sebastian Coe> sebastiancoe389215@msn.com

Dear Sir/Madam
I am an Agent to London 2012 Olympics organising commitee (LOCOG). I play an intermediary role between local organizing committee (LOC) and any interested foreign company in any international competitive tender and my commission is usually 2%
of the total contract value.

I wish to know if your company or you as an individual will be interested to participate in an international Tender for the supply of the following items:

1) T-shirt
2) Umbrellas/Tents,

## Gemfile
gem 'apn_sender', :require => 'apn'
gem 'daemons'

## gist:2700905
We've received a report that your instance(s):

 Instance Id: i-9ab75ffa
 IP Address: 174.129.162.143


has been port scanning remote hosts on the Internet; check the information provided below by the abuse reporter.

This is specifically forbidden in our User Agreement: http://aws.amazon.com/agreement/

## invite.xml
<message to="secret-chat@groups.staging.bonfire.im" id="ab23a" >
<x xmlns="http://jabber.org/protocol/muc#user">
<invite to="twitter.60173@staging.bonfire.im" />
</x>
</message>
	add_index :attachments, :parent_id
	add_index :attachments, :asset_id
	add_index :domain_names, :user_id
	add_index :domain_names, :event_id
	add_index :event_memberships, :user_id
	add_index :event_memberships, :event_id
	remove_index :attachments, :parent_id
	remove_index :attachments, :asset_id
	remove_index:domain_names, :user_id
	remove_index:domain_names, :event_id
	#!/bin/bash
	#
	# Props to http://www.lornajane.net/posts/2011/combining-pdf-files-with-pdftk
	# found via http://stackoverflow.com/questions/19122448/bash-escaping-spaces-in-filename-in-variable#comment42365877_19122448
	#
	# here the sort is used because the pdfs are named something like page 01.pdf page 02.pdf and the -z means the whitespace
	# doesn't cause any issues

	find ./somepath -name "*.pdf" -print0 \| sort -z \| xargs -0 -J % pdftk % cat output out.pdf
	#!/bin/sh
	#
	# S3rep.sh version 1.0
	# Copyright 2009 Matthew Staver
	#
	# This program is free software: you can redistribute it and/or modify
	# it under the terms of the GNU General Public License as published by
	# the Free Software Foundation, either version 2 of the License, or
	# (at your option) any later version.
	#
	RED="\[\033[0;31m\]"
	YELLOW="\[\033[0;33m\]"
	GREEN="\[\033[0;32m\]"
	BLUE="\[\033[0;34m\]"
	LIGHT_RED="\[\033[1;31m\]"
	LIGHT_GREEN="\[\033[1;32m\]"
	WHITE="\[\033[1;37m\]"
	LIGHT_GRAY="\[\033[0;37m\]"
	COLOR_NONE="\[\e[0m\]"
	# None of my own work. Munged from various other .screenrc recipes
	#
	# Don't use CTRL-A as the trigger because its stops the bash
	# cli navigation like CTRL-A for start of line to stop working
	escape ^Gg

	# We'd like to scroll in an xterm please
	defscrollback 1024

	# http://superuser.com/questions/126606/how-to-get-mac-os-x-terminal-app-and-screen-vim-scrolling-to-play-nice/316900#316900
	From: <Sebastian Coe> sebastiancoe389215@msn.com

	Dear Sir/Madam
	I am an Agent to London 2012 Olympics organising commitee (LOCOG). I play an intermediary role between local organizing committee (LOC) and any interested foreign company in any international competitive tender and my commission is usually 2%
	of the total contract value.

	I wish to know if your company or you as an individual will be interested to participate in an international Tender for the supply of the following items:

	1) T-shirt
	2) Umbrellas/Tents,
	We've received a report that your instance(s):

	Instance Id: i-9ab75ffa
	IP Address: 174.129.162.143



	has been port scanning remote hosts on the Internet; check the information provided below by the abuse reporter.

	This is specifically forbidden in our User Agreement: http://aws.amazon.com/agreement/
	<message to="secret-chat@groups.staging.bonfire.im" id="ab23a" >
	<x xmlns="http://jabber.org/protocol/muc#user">
	<invite to="twitter.60173@staging.bonfire.im" />
	</x>
	</message>