我不知道
Rails
但它可以很容易地用普通的、老的、好的SQL执行:
def upcoming_events_in(minutes, client_id)
events.
where(client_id: client_id).
where('DATEDIFF(events.start, DATESUB(NOW(), INTERVAL events.duration MINUTES)) > 0').
where('DATEDIFF(events.start, DATEADD(NOW(), INTERVAL events.minutes MINUTES)) < 0').
exists?
end
《PostgreSQL》
版本:
def upcoming_events_in(minutes, client_id)
start = "(TIMESTAMP events.start, TIMESTAMP events.start + INTERVAL '1 MINUTE')"
interval = "(NOW() - INTERVAL 'events.duration MINUTES', NOW() + INTERVAL 'events.minutes MINUTES')"
events.
where(client_id: client_id).
where("#{start} OVERLAPS #{interval}").
exists?
end
或者说,我没有PG需要检查。