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
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 <a.depauli@depauli.com> 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 - Zope@zope.org 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 )
participants (2)
-
Alexander DePauli -
Steve Spicklemire