Re: [Sqlalchemy-users] eager loading and use of select objects

2006-08-12 Thread Steve Zatz
> the objects you get back, while not eagerly loaded, should still > function pretty well and have lazyloaders attached to its properties; >if all that is working, then im pretty impressed :). Well, I am happy to report that the lazyloaders do work on the select object queries so that is pretty co

Re: [Sqlalchemy-users] eager loading and use of select objects

2006-08-12 Thread Michael Bayer
yeah, eagerloading requires adding lots of extra columns to the column clause of the SELECT statement. with most query operations, you are only providing the WHERE criterion, and Query generates the rest of everything around it, which is a fairly involved process. if you use your own select

[Sqlalchemy-users] eager loading and use of select objects

2006-08-12 Thread Steve Zatz
I have a simple database structure that involves: item_table keyword_table itemkeyword_table with a many-to-many relationship between items and keywords and the expected mapper that defines item.keywords. None of this may be relevant since the basic problem is that if I create a query object suc