Is it possible to iterate though multiple databases with the same zsql method? Have multple identical databases with different data. Want to maintain only one method. Can i do this in DTML or do I have to use pythonscripts? I guess what I want to do is to have the query in one folder, call it from another folder and pass the database connection info to it. Not sure how well this would work with multiple users though....... Any advice is appreciated.
The easiest way to do this is probably (As I think you are describing) put the ZSQL Method in a folder, and put one database connection in each sub-directory, and have all the database connectors with the same name. The problem with this will be that you will have to create a database connection in the folder with the ZSQL Method just so you can write the method (ZSQL Methods insist on giving you your database connection). Then you will have to delete the connection BEFORE you can use the others via acquisition. Not tested, but in theory it should work. Adrian... -- The difficulty of tactical maneuvering consists in turning the devious into the direct, and misfortune into gain. - Sun Tzu ----- Original Message ----- From: "senkr" <senkr@attbi.com> To: <zope-dev@zope.org> Sent: Saturday, March 09, 2002 12:10 AM Subject: [Zope-dev] Multiple Database Connections Same Zsql method Is it possible to iterate though multiple databases with the same zsql method? Have multple identical databases with different data. Want to maintain only one method. Can i do this in DTML or do I have to use pythonscripts? I guess what I want to do is to have the query in one folder, call it from another folder and pass the database connection info to it. Not sure how well this would work with multiple users though....... Any advice is appreciated.
Thanks for the assist. This worked very well. Definitely have to delete the db connection which lies in the directory with the zsql method. Thanks much!! Rob ----- Original Message ----- From: "Adrian Hungate" <adrian@haqa.co.uk> To: "senkr" <senkr@attbi.com>; <zope-dev@zope.org> Sent: Sunday, March 10, 2002 11:53 PM Subject: Re: [Zope-dev] Multiple Database Connections Same Zsql method
The easiest way to do this is probably (As I think you are describing) put the ZSQL Method in a folder, and put one database connection in each sub-directory, and have all the database connectors with the same name.
The problem with this will be that you will have to create a database connection in the folder with the ZSQL Method just so you can write the method (ZSQL Methods insist on giving you your database connection). Then you will have to delete the connection BEFORE you can use the others via acquisition.
Not tested, but in theory it should work.
Adrian...
-- The difficulty of tactical maneuvering consists in turning the devious into the direct, and misfortune into gain. - Sun Tzu
----- Original Message ----- From: "senkr" <senkr@attbi.com> To: <zope-dev@zope.org> Sent: Saturday, March 09, 2002 12:10 AM Subject: [Zope-dev] Multiple Database Connections Same Zsql method
Is it possible to iterate though multiple databases with the same zsql method? Have multple identical databases with different data. Want to maintain only one method.
Can i do this in DTML or do I have to use pythonscripts?
I guess what I want to do is to have the query in one folder, call it from another folder and pass the database connection info to it.
Not sure how well this would work with multiple users though.......
Any advice is appreciated.
participants (2)
-
Adrian Hungate -
senkr