[sqlalchemy] Disable SQLAlchemy Transaction

2011-05-12 Thread jerryji
Hi, It seems even with vanilla DBSession = scoped_session(sessionmaker()), all my SQLs, even the SELECT -- DBSession.configure(bind=engine) Base.metadata.bind = engine dbsession = DBSession() dbsession.expire_on_commit = False dbsession.autocommit = True dbsession.query(...) are wrapped in one

[sqlalchemy] Re: Working with events is frustrating

2011-05-12 Thread Luper Rouch
On May 11, 5:00 pm, Luper Rouch luper.ro...@gmail.com wrote: On May 11, 3:38 pm, Michael Bayer mike...@zzzcomputing.com wrote: On May 11, 2011, at 8:11 AM, Luper Rouch wrote: I agree, when a timeout happens, we display an error message and tell the user its last operation

[sqlalchemy] Re: Working with events is frustrating

2011-05-12 Thread Luper Rouch
On May 12, 1:04 pm, Luper Rouch luper.ro...@gmail.com wrote: On May 11, 5:00 pm, Luper Rouch luper.ro...@gmail.com wrote: On May 11, 3:38 pm, Michael Bayer mike...@zzzcomputing.com wrote: On May 11, 2011, at 8:11 AM, Luper Rouch wrote: I agree, when a timeout happens, we

[sqlalchemy] Re: pseudo polymorphic join problem

2011-05-12 Thread nostradamnit
Ok, missed that FAQ. Anyway, yes, it works with the relationship declared inside the class declaration and the entirety of the and_ clause in quotes. Thanks, Sam On May 11, 3:35 pm, Michael Bayer mike...@zzzcomputing.com wrote: On May 10, 2011, at 6:09 AM, nostradamnit wrote:    #features

Re: [sqlalchemy] Re: Working with events is frustrating

2011-05-12 Thread Michael Bayer
On May 12, 2011, at 7:25 AM, Luper Rouch wrote: I still have the exact same issue when using SessionExtension's before_flush() and after_flush_postexec() methods, demonstrated here :http://paste.pocoo.org/show/387444/ Line 87 raises the same InvalidRequestError: The transaction is

[sqlalchemy] Re: Working with events is frustrating

2011-05-12 Thread Luper Rouch
On May 12, 4:17 pm, Michael Bayer mike...@zzzcomputing.com wrote: On May 12, 2011, at 7:25 AM, Luper Rouch wrote: I still have the exact same issue when using SessionExtension's before_flush() and after_flush_postexec() methods, demonstrated here :http://paste.pocoo.org/show/387444/

Re: [sqlalchemy] Re: Working with events is frustrating

2011-05-12 Thread Michael Bayer
On May 12, 2011, at 6:42 PM, Luper Rouch wrote: On May 12, 4:17 pm, Michael Bayer mike...@zzzcomputing.com wrote: On May 12, 2011, at 7:25 AM, Luper Rouch wrote: I still have the exact same issue when using SessionExtension's before_flush() and after_flush_postexec() methods, demonstrated