Re: [sqlalchemy] guard all session.query with try except?

2011-01-13 Thread Michael Bayer
I'd certainly never do that - no matter what type of application is running, its always best to use transaction-per-logical operation, which means usually, transactions are short. If the transactions are necessarily long, a database failure in the middle means the operation just fails, but

[sqlalchemy] guard all session.query with try except?

2011-01-12 Thread can xiang
Hi, sqlalchemy is such a piece of great work. I'm very happy with it, while I indeed get a problem. I use sqlalchemy 0.6.6 in a non-threaded app. session is created at module level at once. autocommit is set to False. I see log shows: user = user_session.query(User).filter(User.hw_id