[sqlalchemy] Re: getting data from primary keys

2009-09-15 Thread C.T. Matsumoto
That did the trick. Thanks a lot. Your solution uses the orm sessionmaker. Till now my script was relying on sqlalchemy's expression language. Is there some way of doing the same with the expression language? Or would it get too complicated? (Just curious) Cheers, T On Mon, Sep 14, 2009 at

[sqlalchemy] Re: getting data from primary keys

2009-09-15 Thread King Simon-NFHD78
-Original Message- From: sqlalchemy@googlegroups.com [mailto:sqlalch...@googlegroups.com] On Behalf Of C.T. Matsumoto Sent: 15 September 2009 07:21 To: sqlalchemy@googlegroups.com Subject: [sqlalchemy] Re: getting data from primary keys That did the trick. Thanks a lot

[sqlalchemy] Re: getting data from primary keys

2009-09-15 Thread C.T. Matsumoto
@googlegroups.com Subject: [sqlalchemy] Re: getting data from primary keys That did the trick. Thanks a lot. Your solution uses the orm sessionmaker. Till now my script was relying on sqlalchemy's expression language. Is there some way of doing the same with the expression language

[sqlalchemy] Re: getting data from primary keys

2009-09-14 Thread Mike Conley
If I understand this, you want to construct a query that returns the primary keys in an arbitrary table? Try this: key_cols = [c for c in table.primary_key.columns] session.query(*key_cols).all() --~--~-~--~~~---~--~~ You received this message because you are