Advanced Search

Return to Snippet

Revision: 1367
at September 29, 2006 01:22 by rduv
Initial Code 
def self.find_with_all_actors(*actors)
  return [] if actors.empty?
  actors = actors.flatten
  find(:all, :readonly => false,
       :joins => "INNER JOIN appearances a ON movies.id = a.movie_id",
       :conditions => "a.actor_id IN (#{actors.map(&:id).join(', ')})",
       :group => "movies.id HAVING COUNT(movies.id) = #{actors.size}")
end
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
associations are not enough

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
Ruby