Filtering on a left join in SQLalchemy
- by Adam Ernst
Using SQLalchemy I want to perform a left outer join and filter out rows that DO have a match in the joined table.
I'm sending push notifications, so I have a Notification table. This means I also have a ExpiredDeviceId table to store device_ids that are no longer valid. (I don't want to just delete the affected notifications as the user might…