[sqlalchemy] rollback not working

2011-01-12 Thread bool
rollback is not working for me. I wrote a small test script that inserts two rows, with the second row creating a violation. Upon throwing exception, I would expect no rows to be inserted due to rollback, but I find that the first insert is persisted. The surprising thing is that the echo output

Re: [sqlalchemy] rollback not working

2011-01-12 Thread Michael Bayer
On Jan 12, 2011, at 9:08 AM, bool wrote: rollback is not working for me. I wrote a small test script that inserts two rows, with the second row creating a violation. Upon throwing exception, I would expect no rows to be inserted due to rollback, but I find that the first insert is persisted.

[sqlalchemy] Rollback not working like I expect it to (sort of)

2010-10-18 Thread Russell Warren
If I: 1) start a session (sess1) 2) store some data to sess1 without commit 3) start a second session and link to uncommited data from sess1 4) do a rollback on sess1 I'm finding that the rollback does absolutely nothing - the sess1 data persists after the rollback. It is making me not trust

Re: [sqlalchemy] Rollback not working like I expect it to (sort of)

2010-10-18 Thread Michael Bayer
On Oct 18, 2010, at 12:41 PM, Russell Warren wrote: #sess2 will add a new user (jack), but we'll roll it back in the end sess2 = Session() jack = User('jack') jack.addresses = [Address(email_address='j...@example.com'), Address(email_address='j...@example.org')]