Re: [sqlalchemy] [Q] Semantic difference in not equal operator

2014-11-03 Thread Ladislav Lenart
Hello. On 31.10.2014 18:33, Simon King wrote: At a guess, I would say that the Python code Foo.bar != bar means that you are looking for Foo objects that aren't related to bar. This includes Foos that are related to a *different* Bar instance, as well as Foos that aren't related to *any*

Re: [sqlalchemy] [Q] Semantic difference in not equal operator

2014-11-03 Thread Simon King
On 3 Nov 2014, at 13:08, Ladislav Lenart lenart...@volny.cz wrote: Hello. On 31.10.2014 18:33, Simon King wrote: At a guess, I would say that the Python code Foo.bar != bar means that you are looking for Foo objects that aren't related to bar. This includes Foos that are related to a

Re: [sqlalchemy] Lazy load collection from a batch of objects with one query

2014-11-03 Thread Kevin S
Ok, I think I understand some of the reasoning behind not wanting to implement such a feature. I think this is fine, because I don't need the magic that hibernate provides. However, I'm still stuck with the current problem of how to do this kind of collection populating with our antique

Re: [sqlalchemy] Lazy load collection from a batch of objects with one query

2014-11-03 Thread Michael Bayer
Well to load multiple collections at once you need to give a list of parent instances, were you hoping it would use an IN to achieve that or otherwise what SQL are you looking for? There is a 3rd party extension which does some of this and I was hoping to someday implement the IN style of