[sqlalchemy] Re: Select results to object help

2008-05-24 Thread Michael Bayer
On May 24, 2008, at 12:25 AM, Jeff Putsch wrote: Now, when I add the filter like this: print NisAccount.query().select_from(a1.join(a2, (a1.c.eid == a2.c.eid) (a1.c.uid != a2.c.uid))).filter(a1.c.eid.in_(s3) (a1.c.domain_id == 41)).compile() I get an infinite recursion error. 0.5 may

[sqlalchemy] Re: Select results to object help

2008-05-24 Thread Jeff Putsch
On May 24, 2008, at 7:00 AM, Michael Bayer wrote: On May 24, 2008, at 12:25 AM, Jeff Putsch wrote: Now, when I add the filter like this: print NisAccount.query().select_from(a1.join(a2, (a1.c.eid == a2.c.eid) (a1.c.uid != a2.c.uid))).filter(a1.c.eid.in_(s3) (a1.c.domain_id ==

[sqlalchemy] Re: Select results to object help

2008-05-23 Thread Michael Bayer
On May 23, 2008, at 7:42 PM, Jeff Putsch wrote: Howdy, I'm a newbie to sqlalchemy and am having trouble understanding how to turn selects into objects. I've got two tables mapped into objects like this: nis_accounts_table = Table( ... ) nis_users_table = Table( ... ) class

[sqlalchemy] Re: Select results to object help

2008-05-23 Thread Jeff Putsch
On May 23, 2008, at 5:07 PM, Michael Bayer wrote: Jeff Putsch wrote: Then I define some selects and execute them: s = select([nis_accounts_table, nis_users_table], from_obj=[nis_accounts_table.join(nis_users_table)]).where( nis_users_table.c.eid != '' )