On Mon, May 08, 2006 at 10:20:13PM +0200, olivier wrote:
> It is possible to do something along the line of :
>
> SomeTable._connection.cursor().execute("update sometable set ... where
> ...") ?
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="...")))
e And apart from the syntax, I've read this :
>
> http://thraxil.org/users/anders/posts/2005/04/18/raw-queries-with-SQLObject/
>
> which warns against the idea of raw update/delete because of an
> inconsistency risk.
>
> 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()
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
