[sqlalchemy] Auto filter a relationship?

2015-09-24 Thread Shawn Adams
I've got the following models and I'd like to automatically filter out ReservationPackages that contain a "soft deleted" package. A package is "soft deleted" if deleted != null. I've been struggling with this for a few days now. The problem goes away if I don't use the proxy but then I cannot

Re: [sqlalchemy] Re: Auto filter a relationship?

2015-09-24 Thread Shawn Adams
Jonathan, Are you suggesting I use this instead of the association_proxy on Reservation? Doing so will not let me have duplicate packages in the collections list. sqa filters them out. To get around that I had to use the association_proxy. On Thu, Sep 24, 2015 at 1:37 PM, Jonathan Vanasco

Re: [sqlalchemy] Re: Auto filter a relationship?

2015-09-24 Thread Shawn Adams
Reservation -> packages is just a many-to-many relationship with the caveat that a reservation can have the same package more than once. Sqlalchemy will automatically dedube the packages collections which is not what I want. In order to avoid this I had to use reservation_packages as an