On Wed, Feb 28, 2018 at 3:44 PM, Adam Olsen wrote:
> I am trying to replicate the following raw query:
>
> SELECT r.id, r.name, e.id, e.title, e.start, e.end
> FROM room r
> LEFT JOIN LATERAL (
> SELECT evt.id, evt.title, evt.start, evt.end
> FRO
On Wed, Feb 28, 2018 at 6:14 PM, Mike Bayer
wrote:
>
> you want to LEFT OUTER JOIN on that LATERAL so you'd want to use
> query.outerjoin, somthing like:
>
> from sqlalchemy import true
>
> session.query(...).outerjoin(event_include,
> true()).filter(Room.company_id == company_id)
>
> Core is a li
I am trying to replicate the following raw query:
SELECT r.id, r.name, e.id, e.title, e.start, e.end
FROM room r
LEFT JOIN LATERAL (
SELECT evt.id, evt.title, evt.start, evt.end
FROM event evt, calendar cal
WHERE
r.calendar_id=cal.id AND evt.calendar
