Thomas Olausson latompa

latompa / gist:217325

Created October 24, 2009 01:38

find users with no activity

	-- members
	create table members (id integer, age integer);

	insert into members (id,age) values
	(1,10) ,(2,20) ,(3,30) ,(4,25) ,(5,28) ,(6,37) ,(7,38) ,(8,68) ,(9,9)

	-- posts
	create table posts (id integer, user_id integer, title varchar(32))

	insert into posts (id,user_id,title) values

latompa / find duplicate records

Created October 30, 2009 02:29

find duplicate records

latompa / gist:233430

Created November 12, 2009 23:37

	customer_addresses

	cust_id, address_id, preferred
	--------------------------------
	1 1 true
	1 2 false
	2 3 true
	3 4 false

	find customers that only have preferred=false addresses

latompa / delete all but top

Created December 2, 2009 21:27

-create table blogs
-(id integer,
- user_id integer);
-insert into blogs values
-(1,1),
-(2,2),
-(3,3);
-create table entries

latompa / find unique combinations in a set

Created December 21, 2009 21:43

	require 'pp'

	def uniq_combos(set)
	comb = []
	(set.size).times.each do \|x\|
	comb.concat set.combination(x+1).entries
	end
	comb.sort {\|x,y\| y.size <=> x.size}
	end

latompa / find items not rated by this user

Created June 16, 2010 01:52

latompa / make_change.rb

Created June 17, 2010 01:35

	#
	# http://rubyquiz.com/quiz154.html
	#

	def make_change(amount, available_change, coins = [])
	raise "not enough available change" if(amount > 0 && available_change.empty?)
	return coins if amount == 0

	coin = available_change.shift
	n = amount / coin

latompa / gist:753930

Created December 24, 2010 05:24

slider with letter-spacing

latompa / nearest_upcoming_hour.rb

Created March 17, 2011 17:38

nearest_upcoming_hour.rb

latompa / poly.rb

Created April 27, 2011 17:59

poly.rb

	class Reservation
	has_one :authorization, :as => :authorizable
	has_one :capture, :as => :capturable
	end

	class CreditCardAuthorization
	belongs_to :authorizable, :polymorphic => true

	def capture
	end