Re: [sqlalchemy] Implementing a specific commit/refresh strategy for one table only

2011-01-14 Thread Franck
Thanks Michael. I'll also study carefully the other thread (can expire_on_commit be made...) it has interesting insights ! Franck On Thu, Jan 13, 2011 at 4:26 PM, Michael Bayer mike...@zzzcomputing.comwrote: You'd implement the expire yourself using SessionExtension.after_commit(). On

[sqlalchemy] Implementing a specific commit/refresh strategy for one table only

2011-01-13 Thread Franck
Dear all, I've decided to plug SQLAlchemy to my web framework in order to let SQLAlchemy handle the framework's user sessions. Theses sessions require a lot of SELECT and UPDATE all the time. Therefore, I'd like to toggle expire_on_commit and (possibly) autocommit *for the SESSIONS table only.*

Re: [sqlalchemy] Implementing a specific commit/refresh strategy for one table only

2011-01-13 Thread Michael Bayer
You'd implement the expire yourself using SessionExtension.after_commit(). On Jan 13, 2011, at 9:18 AM, Franck wrote: Dear all, I've decided to plug SQLAlchemy to my web framework in order to let SQLAlchemy handle the framework's user sessions. Theses sessions require a lot of SELECT