lambda with inner join
Ruby
code posted
by
Tony Perrie
created at 25 Oct 00:05
Edit
|
Back
1 2 3 4 |
lambda { |objs| { :select => "domain_objects.*, count(links.from_id) AS object_count", :conditions => objs.inject("TRUE") { |str,obj| str + " OR ( links.object_value.id = '#{obj.id}' AND links.object_value_type = '#{obj.class}' )" }, :joins => "INNER JOIN links ON links.from_id = domain_objects.id", :group => "links.from_id,links.object_value_type HAVING object_count >= #{objs.to_a.size}" } } |
464 Bytes in 2 ms with coderay