[Zope] mysql zope

2000-11-30 Thread 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

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




Re: [Zope] mysql zope

2000-11-30 Thread Steve Spicklemire


Hi  Ruediger,

You might consider ZPatterns. It allows you to develop
applications with ZODB, and then, later, 'easily' switch to
other forms of attribute storage for your objects.

-steve

 "Alexander" == Alexander DePauli [EMAIL PROTECTED] writes:

Alexander Hi Zopistas!

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

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

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

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

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

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

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

Alexander best regards

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

Alexander ___ Zope
Alexander maillist - [EMAIL PROTECTED]
Alexander http://lists.zope.org/mailman/listinfo/zope ** No cross
Alexander posts or HTML encoding!  ** (Related lists -
Alexander http://lists.zope.org/mailman/listinfo/zope-announce
Alexander http://lists.zope.org/mailman/listinfo/zope-dev )


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )