[Twisted-Python] adapi.Connection._runQuery always does rollback()

Clark C. Evans cce at clarkevans.com
Sat Apr 26 17:44:21 EDT 2003


On Sat, Apr 26, 2003 at 01:49:06PM -0700, Dave Peticolas wrote:
| To summarize the discussion, you need to commit, not rollback,
| as it's possible for select calls to have side effects. One example
| is calling a stored procedure.

This makes sense.  For example, the stored procedure may update
an access log table which records the last time that a user looked
at a given peice of information.   This could be quite useful.

But, in any case, the 'transaction' should be terminated.  If it
was successful (no exception) then it should be committed, else
it should be rolled back...

Clark




More information about the Twisted-Python mailing list