[Zope-DB] MySQL ZSQL Transactions or Commit in Zope?

Michael Schwartz mike at ziacom.us
Sun May 15 16:30:38 EDT 2005

I am trying to find sample code for performing transactions in ZSQL with
mysql 4.1.  I'd like to do something like this:
1 - Insert record A into USER table
2 - Get auto_increment id for record A
3 - Insert record B into WIDGET table with auto_increment id from
previous step

But if step 3 fails, I want to undo step 1. 
Do I need to back out manually?
Thanks in advance! 
Mike Schwartz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope-db/attachments/20050515/195f3645/attachment.htm

More information about the Zope-DB mailing list