Re: [Sqlalchemy-users] transaction uber-commit

2006-06-22 Thread Michael Bayer
scratch that...instead, upgrade to SVN revision 1651, this should be fixed (+ unittests were added to insure the condition doesnt arise again)On Jun 22, 2006, at 10:29 AM, Tim Van Steenburgh wrote:Sorry, shoulda mentioned that I'm using SA 0.2.3.On 6/22/06, Tim Van Steenburgh <[EMAIL PROTECTED] > w

Re: [Sqlalchemy-users] transaction uber-commit

2006-06-22 Thread Michael Bayer
hey, just confirmed this.  to fix right now:   make sure you create_engine('url', strategy='plain') .On Jun 22, 2006, at 10:29 AM, Tim Van Steenburgh wrote:Sorry, shoulda mentioned that I'm using SA 0.2.3.On 6/22/06, Tim Van Steenburgh <[EMAIL PROTECTED] > wrote:Mike, did Nick ever follow up with a

Re: [Sqlalchemy-users] transaction uber-commit

2006-06-22 Thread Michael Bayer
yah, someone has to send me something on this one.  on my end, multiple inserts on a flush() are always within one transaction.On Jun 22, 2006, at 10:29 AM, Tim Van Steenburgh wrote:Sorry, shoulda mentioned that I'm using SA 0.2.3.On 6/22/06, Tim Van Steenburgh <[EMAIL PROTECTED] > wrote:Mike, did

Re: [Sqlalchemy-users] transaction uber-commit

2006-06-22 Thread Tim Van Steenburgh
Sorry, shoulda mentioned that I'm using SA 0.2.3.On 6/22/06, Tim Van Steenburgh <[EMAIL PROTECTED] > wrote:Mike, did Nick ever follow up with an example of this?  If not perhaps I could send you something.  I'm seeing the same behaviour.  After creating multiple objects and calling session.flush()

Re: [Sqlalchemy-users] transaction uber-commit

2006-06-22 Thread Tim Van Steenburgh
Mike, did Nick ever follow up with an example of this?  If not perhaps I could send you something.  I'm seeing the same behaviour.  After creating multiple objects and calling session.flush(), debug output show a COMMIT after each INSERT.  I'm using threadlocal w/o any explicit transaction mgmt. On

Re: [Sqlalchemy-users] transaction uber-commit

2006-06-20 Thread Michael Bayer
definitely need an example of that, ive never seen anything do that before.   it sounds like the connection is autocommitting because there is no transaction in progress (which would appear impossible since the flush() begins and commits its own transaction).  in particular i need to know if youre

[Sqlalchemy-users] transaction uber-commit

2006-06-20 Thread Nick Joyce
Hi I have written an import script which creates all objects in memory and then commits everything in one transaction (10+ objects). With engine echo=True, I notice that that UnitOfWork is committing after every insert, which I assume is not the required behaviour. Using MySQL @ rev 164