[Zope] mysql & zope

[Alexander DePauli]

Hi Zopistas!

we are looking for a method to do a better integration of mysql
3.23.27 with zope 2.2.2. (we are using the Z MySQL database adapter Z
MySQL DA 1.1.3.)

We have to store data in a mysql database - we can´t use ZODB 
because we need the data accessible by other programs via ODBC.

We habe implemented several ZClasses like "customer", "product" and
"orders". 
We store their instances (eg. each product, customer and so on) to the
mysql-database.  

Our problem: we can´t use the standard ZOPE management interface to
manage the
objects, because the methods of this interface store content to the ZODB
-
and not to the mysql-database. 

Is there a way to extend the standard ZOPE management interface with
additional mysql statements?
For example: we select an object in a zope folder, press the ZOPE
Delete-Button, then this
object is deleted on the mysql-database, not on the ZODB?

For each zclass (customer, products, orders) we need these extra methods
(Delete, Update, Insert ...), so our thought is that we would prefer to
use the ZOPE management interface to do this instead of programming
"extra methods" which obviously can't be used within the standard ZOPE
management interface.

Hope there is somebody out there with an similarly problem solved.

best regards

Ruediger
~~~~~~~~~~~~~~~~~~~~~~~~~
http://www.herrenausstatter.de - Der Online-Herrenausstatter
Kostenlose Serviceline: 0800 -999 66 33
Versandkostenfreie Lieferung - 30 Tage Rückgaberecht
~~~~~~~~~~~~~~~~~~~~~~~~~
Verwaltungsadresse:
DePauli.com Aktiengesellschaft
Stahlgruberring 3 - 81829 München
Telefon: 089 / 530 75 170 - Telefax 089 / 514 50 666