Skip to content

Instantly share code, notes, and snippets.

View hoffm's full-sized avatar
☀️
twib.nyc

Michael Hoffman hoffm

☀️
twib.nyc
36 followers · 35 following
View GitHub Profile
@hoffm
hoffm / check_table_column_collisions.rb
Created May 6, 2014 17:45
This gist contains a script that will check for collisions between the database table names and column names associated with ActiveRecord models. This type of collision was just revealed to be a security risk in this advisory: https://groups.google.com/forum/#!topic/rubyonrails-security/8CVoclw-Xkk
def check
ActiveRecord::Base.send(:subclasses).each do |klass|
if klass.column_names.include?(klass.table_name)
raise "#{klass.to_s}'s table name collides with column #{klass.table_name}"
end
end
puts "All Clear."
end
@hoffm
hoffm / sinatra_page_cache.rb
Created November 14, 2013 13:52
Caching the response for a single page in Sinatra.
get '/' do
if !File.exist?('cache') || (File.mtime('cache') < (Time.now - 1800))
puts "**********CACHE MISS**********"
data = erb(:index)
File.open('cache',"w"){ |f| f << data }
else
puts "**********CACHE HIT**********"
end
send_file 'cache', :type => 'html'
end
@hoffm
hoffm / find_order.rb
Last active December 23, 2015 22:39
An important identity for users of ActiveRecord (and SQL) to keep in mind.
Model.find(1,2) == Model.find(2,1)
=> true
Model.find(1,2) == Model.find(2,1).reverse
=> false
@hoffm
hoffm / NULLquiz.sql
Created September 11, 2013 16:32
What the relationship between the output of line 1 and the output of line 2?
SELECT COUNT(*) FROM `shipments` WHERE (status != 'delivered')
SELECT COUNT(*) FROM `shipments` WHERE (status IS NULL OR status != 'delivered')
@hoffm
hoffm / status.rb
Created August 14, 2013 13:28
Definition of #status for VendorOrderFulfillment.
def status
if self.reverted then
"Reverted"
elsif !self.ship_date then
"Open"
elsif (self.tracking_numbers.length == 0 and !self.shipping_cost_micros) then
"Processing (awaiting)"
else
self.ship_date > Date.today ?
"Processing" :
@hoffm
hoffm / gist:5207153
Last active December 15, 2015 05:09 
1.9.3-p385 :020 > title = Recipe.find(12934).title
 => "The River Café's Strawberry Sorbet" 
1.9.3-p385 :021 > title.encode('ISO-8859-1', 'utf-8')
 => "The River Caf\xC3\xA9's Strawberry Sorbet" 
1.9.3-p385 :022 > puts _
The River Café's Strawberry Sorbet
 => nil
@hoffm
hoffm / String Contsants
Created October 19, 2012 17:00
Oddness of '<<' and String constants
1.8.7-p370 :008 > MICHAEL = "michael"
=> "michael"
1.8.7-p370 :009 > a = MICHAEL
=> "michael"
1.8.7-p370 :010 > a << " hoffman"
=> "michael hoffman"
1.8.7-p370 :011 > a
=> "michael hoffman"
1.8.7-p370 :012 > MICHAEL
=> "michael hoffman"