[Zope] Q: ZPoPy and transactions again, with postgresql.

Gilles Lavaux gilles.lavaux@esrin.esa.it
Fri, 16 Feb 2001 10:32:32 +0100


Hello all,


(NB:Axel.Missbach has asked the same thing some days ago)


Sorry if it's a well_documented_somewhere/stupid question, that's my
problem:

  I want to update a database, several tables, in one http call. I use
  DTML+Zsql methods, several of them during this update. How can I put
theses
  actions inside one transaction?

I use ZPopyDA+ postgresql


I would appreciate an answer to this. I think it's a 'basic' problem on a
www+DB system, and that it's very
 easily solved if you use a perl-DBI cgi.
But with Zope I was unable to find a hint in the documentation/mailing list.
Is it possible to do all the work inside an external method using directly
the PoPy library and using the commit/rollback??


Thanks for any help

Gilles Lavaux