Hi *,
i'm currently developing a (network information) DB web-interface using
ZPatterns specialists with one specialist for every logical object.
For instance i have a 'component'-specialist which handles
a object<->table mapping for the tables:
o component
- product (n:1 foreign key)
- location (n:1 foreign key)
- physical port (1:n foreign key)
- ...
The user (provided that she/he has permission) should be able to create
a new component as well as related physical ports, new product etc.
'create component' Sequence:
----------------------------
(1) call component-specialist newItem
-> skin script 'WHEN OBJECT ADDED' calls SQL insert statement
with default attribute parameters from ZClass
### + SQL commit (Zope/DC Oracle default behavior)! ###
(2) redirect user to .../component/#newid/edit
(3) user adds new physical port
-> skin script 'WHEN OBJECT ADDED' calls SQL insert statement
with component #newid as foreign key + default stuff from ZClass
again an SQL commit-statement is appended
...
(x) user clicks 'cancel'-button
-> MY PROBLEM (trash in DB because of no(?) possibility to make
a SQL rollback)
Questions:
----------
1. Is it possible to make sure a user stays with a specific DC Oracle
thread ? (trick timeouts via http-refresh ?)
2. Provided that a user can have her/his private DB thread (kind of a
private xterm with PL/SQL ;-) is it possible to wrap a bunch of SQL
statements (triggered by ZPatterns) into a (Oracle) DB Transaction ?
Any comments (maybe answers ;-) would be _very_ appreciated.
thank u in advance
Andy
----------------------------------------------------------------------
Andreas Repp [EMAIL PROTECTED]
Leibniz Rechenzentrum Muenchen www.lrz.de
Barer Str. 21 office +49 8441 4980772
D-80333 Muenchen mobile +49 172 8337010
----------------------------------------------------------------------
_______________________________________________
Zope-Dev maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope )
