[sqlalchemy] Re: how to run a stored procedure?

2010-07-21 Thread Lukasz Szybalski
how is calling query(colmames)...all() significantly different from simply saying execute(..).fetchall() ?  you get a list of named-tuple like objects in both cases. You are correct, execute().fetchall() does already returns a list of rows, where each row has attributes. I was initially

[sqlalchemy] SessionExtensions not firing

2010-07-21 Thread Max
Hi Group, We are currently working on an issue where we want to use the SessionExtension ability. However, we run into a problem when our session.flush() has no changes to be made. However at the same time we have processing that we want to happen after the flush in the form of deferred

Re: [sqlalchemy] SessionExtensions not firing

2010-07-21 Thread Michael Bayer
On Jul 21, 2010, at 10:37 AM, Max wrote: Hi Group, We are currently working on an issue where we want to use the SessionExtension ability. However, we run into a problem when our session.flush() has no changes to be made. However at the same time we have processing that we want to

Re: [sqlalchemy] SessionExtensions not firing

2010-07-21 Thread mwalton
Basically, we have some actions that are performed by direct database access that happen in a deferred state. When we flush, we want to process these deferred actions. So it looks like we will need to continue overriding the session flush. Thanks for your quick reply. Max On Wed, 2010-07-21