[sqlalchemy] Plain SQL and session.flush in a single transaction

2007-01-02 Thread asrenzo
Hi, I'm trying to implement a nested tree via sqlalchemy. So my problem is that when I add or remove objects from the tree I need to update some records to change their left hand side and right hand side values. I order to improve the performances of these changes, and because the number of

[sqlalchemy] More MSSQL fun!

2007-01-02 Thread Paul Johnston
Hi, On the whole SA is working pretty well for me, but I've still got some MSSQL problems: 1) session.flush() doesn't assign IDs to new objects It does create them in the database, just doesn't read the ID back in. In MSSQLExecutionContext it tries to detect if there are any ID columns,

[sqlalchemy] Re: Plain SQL and session.flush in a single transaction

2007-01-02 Thread Michael Bayer
mixing plain SQL and session flushes within transactions, using an ORM transaction object called a SessionTransaction, or alternatively using an engine level Transaction, is described here: http://www.sqlalchemy.org/docs/unitofwork.myt#unitofwork_transaction_sql

[sqlalchemy] Re: Plain SQL and session.flush in a single transaction

2007-01-02 Thread asrenzo
Thank you very much for this link, I'm going to try asap Regards, Laurent --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To

[sqlalchemy] Re: More MSSQL fun!

2007-01-02 Thread Rick Morrison
Hi guys, I'm in meetings all day today, but I've been watching a bit from the sidelines. It's certainly fair to say that the ADODB interface to MSSQL is not super-well tested. We use pymssql here and that's what gets the most attention. Patches are absolutely and enthusiastically welcomed,