> -----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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
