[SQLObject] Re: raw batch update/delete

Top Page
Author: olivier
Date:  
To: sqlobject-discuss
Subject: [SQLObject] Re: raw batch update/delete
Oleg Broytmann wrote :

> from sqlobject.sqlbuilder import Insert, Update, Delete
> connection = SomeTable._connection
>
> connection.query(connection.sqlrepr(Insert("table", {name: value})))
> connection.query(connection.sqlrepr(Update("table", {name: value}, where="...")))
> connection.query(connection.sqlrepr(Delete("table", where="...")))
>
>> However, it seems to me that under certain circonstances (all syncUpdate
>> and commits done), we should be pretty safe. Am I missing something ?
>
> connection.cache.clear()



Whoa, that was fast and to the point ;o)

Thank you for this ,

        Olivier



-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@???
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss