[Zope-DB] Inserting into multiple tables

Bryce Harrington bryce at osdl.org
Tue May 4 20:24:53 EDT 2004

If I have a form that needs to insert into multiple tables on
submission, how can this be done?

Basically, I am creating an entry in a main table and then creating
entries in several join tables.  During the insert into the main table a
unique ID key is generated, and this key is used as an input to each of
the other tables.

The examples I've seen so far for ZSQL use only single insert statements
into a single table.  Is it possible to do multiple inserts from one
ZSQL operation?  If not, how would one do it with a Python script or
other mechanism?


More information about the Zope-DB mailing list