[sqlalchemy] Re: "Incremental" populate_existing behaviour

2010-10-20 Thread Jasper K
Thanks for your response. We will investigate your suggestions for improving our design and look forward to seeing what you come up with for 0.7! On Oct 20, 5:05 pm, Michael Bayer wrote: > On Oct 20, 2010, at 4:01 PM, Jasper K wrote: > > > > > Unfortunately I don't think

[sqlalchemy] Re: "Incremental" populate_existing behaviour

2010-10-20 Thread Jasper K
On Oct 20, 2:37 pm, Michael Bayer wrote: > On Oct 20, 2010, at 1:34 PM, Jasper K wrote: > > > Hi, > > > We have a use case where we would like to have "incremental updates" > > to existing session objects (ie. populate_existing()-type behaviour > > whe

[sqlalchemy] "Incremental" populate_existing behaviour

2010-10-20 Thread Jasper K
Hi, We have a use case where we would like to have "incremental updates" to existing session objects (ie. populate_existing()-type behaviour where existing object's lazy-loaded attributes are not reset by subsequent populate_existing queries). We have come up with a solution by implementing a sub

[sqlalchemy] Re: "(OperationalError) no such column" when eagerload an association object that has custom secondaryjoin condition in 0.5.8

2010-10-18 Thread Jasper K
On Oct 18, 4:06 pm, Michael Bayer wrote: > On Oct 18, 2010, at 2:46 PM, Jasper K wrote: > > > > > Hi Group, > > > I am using SqlAlchemy 0.5.8 > > > I get an "(OperationalError) no such column: child.child_id" error > > when trying to eagerloa

[sqlalchemy] "(OperationalError) no such column" when eagerload an association object that has custom secondaryjoin condition in 0.5.8

2010-10-18 Thread Jasper K
Hi Group, I am using SqlAlchemy 0.5.8 I get an "(OperationalError) no such column: child.child_id" error when trying to eagerload a viewonly many-to-many relationship that uses the Association Object pattern with a custom secondaryjoin condition (http://www.sqlalchemy.org/docs/05/mappers.html#ass