Re: [sqlalchemy] Backref primary join condition stopped working in 0.9.4

2016-03-19 Thread Mike Bayer
On 03/16/2016 02:37 PM, Thorsten von Stein wrote: For several years, I have been using a pattern for making a many-to-one relationship from *cls* to *remoteCls* with a one-to-many backref with a join condition cls.foreignKey == remoteCls.id, where *cls* has a deletion flag _del which should exc

Re: [sqlalchemy] Backref primary join condition stopped working in 0.9.4

2016-03-19 Thread Thorsten von Stein
Mike, Thank you very much for your quick reply and for creating the test case. Upon closer inspection, I noticed that the errors in my system resulted from a special case of a self-referential relationship as in the following modification of your test case, in which additionally the post_update fl

Re: [sqlalchemy] Backref primary join condition stopped working in 0.9.4

2016-03-19 Thread Mike Bayer
On 03/16/2016 06:10 PM, Thorsten von Stein wrote: Mike, Thank you very much for your quick reply and for creating the test case. Upon closer inspection, I noticed that the errors in my system resulted from a special case of a self-referential relationship as in the following modification of yo

[sqlalchemy] Backref primary join condition stopped working in 0.9.4

2016-03-18 Thread Thorsten von Stein
For several years, I have been using a pattern for making a many-to-one relationship from *cls* to *remoteCls* with a one-to-many backref with a join condition cls.foreignKey == remoteCls.id, where *cls* has a deletion flag _del which should exclude *cls* instances with del != 0 from the backref