[sqlalchemy] MapperExtension ... is there a do_after_everything_else() hook?

2007-07-14 Thread Paul Howell
I've gotten a long way with using SA in Turbogears, but I want one more thing (for now). In short, I want to attach some properties to the Data objects after everything else has been done. I could do this in my Python code AFTER my select() results are returned (I do that now), but would rather

[sqlalchemy] Two Phased Commits, Nested Transactions and SAVEPOINT Support to be released in SQLAlchemy 0.4

2007-07-14 Thread Michael Bayer
Hi list - I am pleased to announce that due to the diligent efforts of Ants Aasma, SQLAlchemy 0.4 will feature native two-phased commit support, explicit SAVEPOINT support, and nested transaction support for both MySQL and Postgres, with probable support for Oracle as well. This is represented

[sqlalchemy] Problem with sqlalchemy and mysql

2007-07-14 Thread SamDonaldson
Hello group, I'm having an issue with my site where I get the following error if I don't use the site for a while, even just a few hours, like 2-3 hours results in: Error - sqlalchemy.exceptions.SQLError: (OperationalError) (2006, 'MySQL server has gone away') 'SELECT ...' {...} Does

[sqlalchemy] Re: MapperExtension ... is there a do_after_everything_else() hook?

2007-07-14 Thread Paul Howell
Hi Mike, No, Rick's method didn't work for me... I've defined attributes using assign_mapper, and those don't seem to be in place when I need them. It's fine for me doing this in Python after getting everything back from SA, and in fact perhaps it is easier, coding-wise. But I got all

[sqlalchemy] Re: Pagination problems using SQLAlchemy MSSQL in Pylons - no OFFSET

2007-07-14 Thread lei you
Not exactly sure about what Valentin is doing there, will need to take a look at the actual schema and data involved, select distinct path, row_number() over (order by path desc) as ora_rn from Block row_number() is always distinct, therefore, the results returned by the above query will include

[sqlalchemy] Re: Problem with sqlalchemy and mysql

2007-07-14 Thread Michael Bayer
use the pool_recycle argument as described here: http://www.sqlalchemy.org/trac/wiki/ FAQ#MySQLserverhasgoneawaypsycopg.InterfaceError:connectionalreadyclosed On Jul 14, 2007, at 8:15 PM, SamDonaldson wrote: Hello group, I'm having an issue with my site where I get the following error if

[sqlalchemy] Re: Pagination problems using SQLAlchemy MSSQL in Pylons - no OFFSET

2007-07-14 Thread lei you
# TODO: put a real copy-container on Select and copy, or somehow make this # not modify the Select statement In the above comments, are we referring to a solution where the original select statement is wrap inside another select statement where the actual row_number function is applied? On

[sqlalchemy] Re: Pagination problems using SQLAlchemy MSSQL in Pylons - no OFFSET

2007-07-14 Thread Michael Bayer
On Jul 14, 11:15 pm, lei you [EMAIL PROTECTED] wrote: # TODO: put a real copy-container on Select and copy, or somehow make this # not modify the Select statement In the above comments, are we referring to a solution where the original select statement is wrap inside another select