[sqlalchemy] simplest pattern to query a database

2010-02-10 Thread Tarek Ziadé
Hi, I am using this pattern to execute a simple query on a database: def execute(sqluri, query): engine = create_engine(sqluri) connection = engine.connect() try: connection.execute(query) finally: connection.close() I was wondering if this was the best pattern,

Re: [sqlalchemy] simplest pattern to query a database

2010-02-10 Thread Michael Bayer
On Feb 10, 2010, at 5:24 PM, Tarek Ziadé wrote: Hi, I am using this pattern to execute a simple query on a database: def execute(sqluri, query): engine = create_engine(sqluri) connection = engine.connect() try: connection.execute(query) finally: