[sqlalchemy] Working with a ResultProxy object

2011-08-02 Thread RVince
In my controller class, I perform a rather basic, straightforward SQL query: connection = engine.connect() trans = connection.begin() try: c.result = connection.execute(select current_disposition_code,count(*) as num from cms_input_file group by

Re: [sqlalchemy] Working with a ResultProxy object

2011-08-02 Thread Tamás Bajusz
On Tue, Aug 2, 2011 at 3:07 PM, RVince rvinc...@gmail.com wrote: In my controller class, I perform a rather basic, straightforward SQL query:        connection = engine.connect()        trans = connection.begin()        try:            c.result = connection.execute(select

Re: [sqlalchemy] Working with a ResultProxy object

2011-08-02 Thread Michael Bayer
On Aug 2, 2011, at 9:07 AM, RVince wrote: In my controller class, I perform a rather basic, straightforward SQL query: connection = engine.connect() connection, OK trans = connection.begin() start a transaction, OK try: c.result =