I’ve got a tricky (at least for me) model association I need to
establish. Here are the two tables
Appointment
id, name, start(datetime), stop(datetime)
1, apt1, 1/4/2011 14:00, 1/4/2011 14:30
Schedule
id, name, start(datetime), stop(datetime)
1, sch1, 1/4/2011 08:00, 1/4/2011 17:00
I need to associate a schedule with an appointment. So each
appointment will have_one schedule. The assocation get’s created by
virtue of the start/stop of the appointment being in between the start/
stop of a schedule.
This sql will return the record
select *
from apts a
inner join schedules s on s.start <= a.start and s.stop >= a.stop
So what do I do?
class Apt < ActiveRecord::Base
has_one :schedule, something here
end