[Zope-dev] Multiple Database Connections Same Zsql method

[Adrian Hungate]

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.