[sqlalchemy] Re: Connection management in Sqlalchemy.

2007-07-05 Thread SamDonaldson
Yes, Is there a way to get to that chapter? Thanks, Sam. On Jul 4, 9:30 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Jul 4, 10:22 pm, SamDonaldson [EMAIL PROTECTED] wrote: I want to use MetaData() to return an object passed in it is the db uri. I want the connection object returned

[sqlalchemy] Re: Connection management in Sqlalchemy.

2007-07-05 Thread SamDonaldson
Michael and others, It seems like, if I want to use Sqlalchemy's connection support, I could do the following: Everytime I need to connect to db: engine = create_engine(db_uri) connection = engine.contextual_connect() # I now have the connection object, so I can start my txn on writes to the

[sqlalchemy] Re: Connection management in Sqlalchemy.

2007-07-05 Thread Michael Bayer
On Jul 5, 1:17 pm, SamDonaldson [EMAIL PROTECTED] wrote: engine = create_engine(db_uri) connection = engine.contextual_connect() # I now have the connection object, so I can start my txn on writes to the db trans = connection.begin() # now execute the sql connection.execute(INSERT

[sqlalchemy] Re: Connection management in Sqlalchemy.

2007-07-04 Thread Michael Bayer
On Jul 4, 10:22 pm, SamDonaldson [EMAIL PROTECTED] wrote: I want to use MetaData() to return an object passed in it is the db uri. I want the connection object returned back to me from the meta. meta = MetaData(db_uri) #getting the connection object conn = meta.connect -- is this