Hi,
if you want to do things like this, you also could use the alchmist product.
However, I think the archetype / plone formgen integration at the moment
is not functional. (ask kapil t. and roché c. for closer info)
You would have to start out with plain zope 3 schema and formlib like in
the alchemist included orgpeople example.
I developed a neat little application that uses the unit of work and
automatic transaction support of sql alchemy and all dependent tables
are deleted, updated and inserted automatically by the mapper
(www.*sqlalchemy*.org/)
Dennis
Paul Eipper escribió:
Hi all !
I am just starting with using Zope/Plone and mySQL(InnoDB) and am
hitting every bump on the road as I go :P
I have a Form (generated with PloneFormGen+DataGridField) and I need
to send the data entered there into several mySQL tables. I am
guessing a Python script would be the right thing here.(?)
My main questions right now are:
1) How do I maintain referencial integrity?
I need to get LAST_INSERT_ID() from the first INSERT to use on the
following inserts.
Could I have a ZSQL Method that does the insert and returns the
generated ID to the Python script?
2) Is a ZSQL Method automatically executed as a transaction? Or do I
need to manually define BEGIN; COMMIT; to guarantee I am getting the
correct data?
3) Where can I find example code (zsql, python scripts) dealing with
many related tables? All tutorials I found deal with only one table at
a time, completely ignoring the relational part of the database.
Thanks !
--
Paul Eipper
Brasil
_______________________________________________
Zope-DB mailing list
[email protected]
http://mail.zope.org/mailman/listinfo/zope-db
_______________________________________________
Zope-DB mailing list
[email protected]
http://mail.zope.org/mailman/listinfo/zope-db
