[Zope] ZClasses to RDBMS

[Steve Alexander]

Satheesh Babu wrote:
>
> Is there any recommended way to get data from ZClass instances to a
> corresponding RDBMS (Oracle 8i specifically) table?
>
> What I could think of as options are: (I've'nt tried out any!)
> 1.  In manage_add for my Zclass call the corresponding ZSQL insert method
>          - Can this be done?
>          - What can be done for updates?
> 2.  Create masking DTML methods to create Zclass instances dynamically.
>      Call ZSQL methods alongside as well.
> 3.  Do periodic downloads of ZClass instances - say XML format - and batch
>      upload to database.

This sounds like a job for ZPatterns:

  http://www.zope.org/Members/pje/ZPatterns

Most people find ZPatterns a bit difficult to get started with. It is
also alpha-release software, so *caveat emptor*.

Read the ZPatterns wiki too.

  http://www.zope.org/Members/pje/Wikis/ZPatterns/HomePage

--
Steve Alexander
Software Engineer
Cat-Box limited
http://www.cat-box.net