Thanks for the help! T
On Tue, Sep 15, 2009 at 12:33 PM, King Simon-NFHD78 <[email protected] > wrote: > > > -----Original Message----- > > From: [email protected] > > [mailto:[email protected]] On Behalf Of C.T. Matsumoto > > Sent: 15 September 2009 07:21 > > To: [email protected] > > 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? Or would it get too > > complicated? (Just curious) > > > > Cheers, > > > > T > > > > How about: > > import sqlalchemy as sa > > key_cols = [c for c in table.primary_key.columns] > query = sa.select(key_cols) > print query.execute().fetchall() > > Or > > print connection.execute(query).fetchall() > > Hope that helps, > > Simon > > > > -- Todd Matsumoto --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
