[sqlalchemy] Keeping soft deletion atomic in spite of model methods calling commit

Hi, I'm trying to implement soft deletion in my app. I'd like to keep things atomic so that if an error happens during the soft deletion process, I don't get half deleted stuff. Here is a simplified view of my code (full working example here: https://gist.github.com/4329926): class

[sqlalchemy] Setting the isolation level seems to have no effect

Hi, I'm using sqlalchemy version 0.7.8 and MySQL Ver 14.14 Distrib 5.5.25, for osx10.6 (i386) using readline 5.1. All my tables are using InnoDB. I'm trying to change the isolation_level, following http://docs.sqlalchemy.org/en/rel_0_7/dialects/mysql.html engine = create_engine(

Re: [sqlalchemy] Setting the isolation level seems to have no effect

, 2012, at 6:25 AM, charlax wrote: Hi, I'm using sqlalchemy version 0.7.8 and MySQL Ver 14.14 Distrib 5.5.25, for osx10.6 (i386) using readline 5.1. All my tables are using InnoDB. I'm trying to change the isolation_level, following http://docs.sqlalchemy.org/en/rel_0_7/dialects/mysql.html

[sqlalchemy] Getting TimeoutError with SqlAlchemy

Hi, I have to explicitly close the engine connection, otherwise I get a TimeoutError: QueuePool limit of size 5 overflow 10 reached, connection timed out, timeout 30 error when using nosetest and sqlalchemy. I'm not using multiprocessing. I'm following the SqlAlchemy documentation about how