Rails find record with zero has_many records associated

Question

This seems fairly simple but I can't get it to turn up on Google.

If I have:

class City < ActiveRecord::Base

  has_many :photos

end



class Photo < ActiveRecord::Base

  belongs_to :city

end

I want to find all cities that have no photos. I'd love to be able to call something like...

City.where( photos.empty? )

...but that doesn't exist. So, how do you do this kind of query?

Update:
Having now found an answer to the original question, I'm curious, how do you construct the inverse?

IE: if I wanted to create these as scopes:

scope :without_photos, includes(:photos).where( :photos => {:city_id=>nil} )

scope :with_photos, ???

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

Bah, found it here: http://stackoverflow.com/a/5570221/417872

City.includes(:photos).where(photos: { city_id: nil })

Rails find record with zero has_many records associated

Sign up