[sqlalchemy] Re: query and subquery problem with anonymous field

On Jul 16, 7:33 pm, Conor conor.edward.da...@gmail.com wrote: On 07/16/2010 09:53 AM, dr wrote: Michael, I have implemented what you suggested and below is a comparison of the results: *** 2010-07-16 15:44:31,520 INFO sqlalchemy.engine.base.Engine.0x...7910 BEGIN

[sqlalchemy] Python logging with sqlalchemy

Does anyone have a custom handler for the logging module that would use a sqlalchemy connection to save the log into the db. Tnx :) -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com.

[sqlalchemy] Close the engine and go home

This is a really dumb noob question... I know how to create an engine, a Session, and a session. I see how to do session.close(). How do I close the engine? (i.e. How do I close all connections to the database cleanly so my application can exit and not leave the database server hanging?)

[sqlalchemy] Struqtural for SQL Alchemy

Wanted to drop by and mention that I just released the first public version of Struqtural. In a nutshell, Struqtural tries to make it as easy as possible to get data into a database, out of a database (as python objects) and to build some of the more common complex table arrangements. Struqtural

[sqlalchemy] lockmode

Hello, I am running Python 2.6 SQL Alchemy 0.5.8 against MS SQL Server Express 2008 with pyODBC. When I issue something like: sess.query(job).with_lockmode(update) It does not seem to be locking according to the query I am getting back from my profiler. Is this the correct usage? Thanks Mike