Re: [Sqlalchemy-users] Mixing metaphors

2006-07-17 Thread Michael Bayer
to do begin/commit via straight SQL, use: connection = dbEngine.connect() trans = connection.begin() connection.execute("update table set name='bar'") trans.commit() using the textual "BEGIN" and "COMMIT" is not going to be portable with DBAPI and might not even

[Sqlalchemy-users] Mixing metaphors

2006-07-17 Thread Robert Taylor
I would like to mix straight SQL and mapper access within my code, but the way I'm doing it seems to be breaking something. For example, I'll do several operations using a raw SQL pattern like:    dbEngine.text( "begin'").execute()     dbEngine.text( "update foo set name = 'bar'").execute()    dbE