Skip to content

Instantly share code, notes, and snippets.

View shaneshifflett's full-sized avatar

Shane Shifflett shaneshifflett

42 followers · 40 following
View GitHub Profile
@shaneshifflett
shaneshifflett / create_local_remote_branches.sh
Created February 17, 2011 06:07
Track all remote GIT branches locally
for remote in `git branch -r | grep -v master `;
do git checkout --track $remote ;
done;
@shaneshifflett
shaneshifflett / change_mysql_engine_type.sh
Created February 16, 2011 20:27
Change the engine types of all tables in a mysql db from the command line
mysql -u<USERNAME> -p<PASSWORD> <DB_NAME> -e "show tables" | \
grep -v Tables_in|awk '{print "ALTER table",$1" ENGINE=InnoDB;"}'
@shaneshifflett
shaneshifflett / dump.txt
Created September 18, 2015 02:47
tracker investigation local
| results | BASE TABLE |
| resultview3 | VIEW |
| resultview_sub1 | BASE TABLE |
| resultview_sub2 | BASE TABLE |
| resultview_sub3 | BASE TABLE |
| resultview_sub3a | BASE TABLE |
RESULTSVIEW3 is confirmed to be a view
mysql> select * from trackertouse;
@shaneshifflett
shaneshifflett / routes.geojson
Created September 1, 2015 03:53
sfmtaroutes
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@shaneshifflett
shaneshifflett / gdoc_to_timeline_converter.rb
Created February 21, 2014 23:37
convert a google spreadsheet to a json file that can be read by timeline.js
task :jsonify_timeline => :environment do
require 'csv'
require 'json'
require 'open-uri'
def scrub(text)
if text.include? '--'
text = text.gsub(/--/, '&mdash;')
end
return text