[Zope-DB] [Zope] ZSQL Methods and transaction control

Maciej Wisniowski maciej.wisniowski at coig.katowice.pl
Wed Jan 10 08:10:47 EST 2007


>> thanks charlie,
>> so that means, that the _commit and _abort methods are only for zope's
>> transaction controll.
> Yes, and with good reason.
But I think that if you know what your'e doing you may
use them althought it may be tricky. It is better to
try external method like Charlie suggested for example
with something like:

def callSQLtransactionSet(self):
    connObj = self.yourconnectionobject() # connection object from Zope
    db = connObj.db                                     # this depends
on your's Zope DA

    # CODE FROM YOUR PREVIOUS POST HERE

    # it may be necessary to return connection to the pool here
    # if your DA uses one

If you'll have to do something more with database, then
do it after calling this function otherwise it will be
commited or rolled back during call to callSQLtransactionSet
method.

I'm not sure that this will work.

-- 
Maciej Wisniowski


More information about the Zope-DB mailing list