Skip to content

Instantly share code, notes, and snippets.

View Capncavedan's full-sized avatar

Dan Buettner Capncavedan

15 followers · 19 following
View GitHub Profile
@Capncavedan
Capncavedan / gist:8803953
Created February 4, 2014 13:55
SQL to find data in a MySQL table that is non-ASCII
SELECT whatever
FROM tableName
WHERE columnToCheck <> CONVERT(columnToCheck USING ASCII)
@Capncavedan
Capncavedan / timezonezipificator.rb
Created January 5, 2014 03:37
Script to add time zone where possible
This file has been truncated, but you can view the full file.
require 'zip-codes'
time_zones_by_zip = {
"00501" => "America/New_York",
"00544" => "America/New_York",
"01001" => "America/New_York",
"01002" => "America/New_York",
"01003" => "America/New_York",
"01004" => "America/New_York",
"01005" => "America/New_York",
@Capncavedan
Capncavedan / example.rb
Created October 28, 2013 19:16
Number to currency calculator, faster than ActiveSupport (due to no translation?)
def quick_number_to_currency(num)
left, right = sprintf("%.2f", num).split('.')
1 while left.sub!(/(\d)(\d\d\d)\b/, '\1' + ',' + '\2')
"$#{left}.#{right}"
end
it "turns 1000 into $1,000.00" do
@rt.quick_number_to_currency(1000).should eql("$1,000.00")
end
@Capncavedan
Capncavedan / gist:4157673
Created November 27, 2012 22:41
Powerball stats 7 Jan 2009 to 27 Nov 2012 
Getting Powerball drawing data from 11/27/2012 back to 01/07/2009 ...
Got 641775 bytes of Powerball data. Stand by for parsing.
Examining results of 406 drawings...
Top 5 numbers: 20, 41, 32, 59, 22
Top Powerball: 23

Detail:

Regular numbers
@Capncavedan
Capncavedan / gist:3176635
Created July 25, 2012 15:03
mysql> select * from types_of_work where id < 10 order by bond_category limit 9;
+----+------------+-------------------+-----------------------------+---------------+------+
| id | rate_class | general_type | specific_type | bond_category | code |
+----+------------+-------------------+-----------------------------+---------------+------+
| 3 | A | All Other Class A | Airports - site preparation | 1 | 49 |
| 5 | A | All Other Class A | Airports - site preparation | 2 | 49 |
| 1 | A | All Other Class A | Airports - site preparation | 3 | 49 |
| 2 | A | All Other Class A | Airports - site preparation | 4 | 49 |
| 4 | A | All Other Class A | Airports - site preparation | 5 | 49 |
| 7 | A | All Other Class A | Airports - site preparation | 6 | 49 |
@Capncavedan
Capncavedan / fast_spec.rb
Created July 20, 2012 14:08
A fast spec
describe "truth" do
100000.times do
it "should not be false" do
true.should_not be_false
end
end
end
@Capncavedan
Capncavedan / gist:3144555
Created July 19, 2012 15:05
Rdiscount installation / Jruby 1.6.7

Continuously have problems installing rdiscount under Jruby on Mac OS X 10.7 with the Apple Developer Tools.

LD linked library error regarding not being able to find -lbundle.o

The cc compiler is using /usr/local/lib and bundle.o is instead in /usr/lib

The below adds /usr/lib as a path the compiler will check for shared libraries

gem install rdiscount -- --with-ldflags="-R /usr/lib"

@Capncavedan
Capncavedan / gist:3144391
Created July 19, 2012 14:40
How to run a JRuby delayed job worker

RAILS_ENV=production QUEUE=jruby bundle exec rake jobs:work

@Capncavedan
Capncavedan / gist:3044949
Created July 4, 2012 02:44
CenturyLink DNS servers
dns-auth-3.centurylinkservices.net 207.14.235.234 Primary
dns-auth-4.centurylinkservices.net 67.238.98.162 Secondary
dns-auth-5.centurylinkservices.net 74.4.19.187 Secondary
@Capncavedan
Capncavedan / gist:2844679
Created May 31, 2012 16:46
Analyze MySQL binary log file
# from http://dzone.com/snippets/analyse-binary-log
# cat /bin/mylog
#!/bin/sh
# usage:
#$ mylog /mysql-bin-log/db-bin.000223
# 2132 insert into customers
# 1887 update userlog_access
# 788 insert into gn_commission
# 718 insert into con_tab