Rails: using find method to access joined tables for polymorphic relationships
Posted
by DJTripleThreat
on Stack Overflow
See other posts from Stack Overflow
or by DJTripleThreat
Published on 2010-05-26T13:31:39Z
Indexed on
2010/05/26
18:31 UTC
Read the original article
Hit count: 259
Ok, I have a generic TimeSlot
model that deals with a start_at
and an end_at
for time spans. A couple models derive from this but I'm referring to one in this question: AppointmentBlock
which is a collection of Appointments
. I want to validate an AppointmentBlock
such that no other AppointmentBlocks
have been scheduled for a particular Employee
in the same time frame. Since AppointmentBlock
has a polymorphic association with TimeSlot
, you have to access the AppointmentBlock
's start_at
and end_at
through the TimeSlot
like so: appt_block.time_slot.start_at
This means that I need to have some kind of join in my :conditions
for my find()
method call. Here is my code so far:
#inside my appointment_block.rb model
validate :employee_not_double_booked
def employee_not_double_booked
unless self.employee_id
# this find's condition is incorrect because I need to join time_slots to get access
# to start_at and end_at. How can I do this?
blocks = AppointmentBlock.find(:first,
:conditions => ['employee_id = ? and (start_at between ? and ? or end_at between ? and ?)',
self.employee_id, self.time_slot.start_at, self.time_slot.end_at,
self.time_slot.start_at, self.time_slot.end_at])
# pseudo code:
# collect a list of appointment blocks that end after this
# apointment block starts or start before this appointment
# block ends that are also associated with this appointment
# blocks assigned employee
# if the count is great then 0 the employee has been double
# booked.
# if a block was found that means this employee is getting
# double booked so raise an error
errors.add "AppointmentBlock",
"has already been scheduled during this time" if blocks
end
end
Since AppointmentBlock
doesn't have a start_at
or an end_at
how can I join with the time_slots
table to get those conditions to work?
© Stack Overflow or respective owner