Regions and associations do not work

Question

I am trying to return records where the association is present or not:

I tried these areas:

class Booking < ActiveRecord::Base
  has_one :availability

  scope :with_availability, -> {where{availability.not_eq nil}}
  scope :without_availability, -> {where{availability.eq nil}}
end

Answer 1

Try the following:

class Booking < ActiveRecord::Base
  has_one :availability

  scope :with_availability, -> { joins{availability} }
  scope :without_availability, -> { joins{availability.outer}.where{availability.id.eq nil} }
end

Answer 2

Use instance methods instead

def with_availability
  availability.present?
end

def without_availability
  availability.blank?
end

Answer 3

, , :

class Booking < ActiveRecord::Base
  has_one :availability

  scope :with_availability, -> {where(id: Availability.pluck(:booking_id))}
  scope :without_availability, -> {where.not(id: Availability.pluck(:booking_id))}
end

, ( ):

Rails - has_one :