[Zope-DB] Multiple databases connection
andrew at logicalware.com
Fri Jun 9 02:25:54 EDT 2006
If you add a ZSQL Method and then go to the 'Advanced' tab you can
specify a 'Connection Hook'. This should be the name of a Python
Script or some other method which will return the name of the
database connection to use allowing you to dynamically change the DB
On 9 Jun 2006, at 06:19, Infor Gates wrote:
> My apologies if my query is unclear.
> M.Banaouas got it right. Let try to explain it another way:
> 1. We have a standard Zope application which is replicated in ZMI.
> 2. the difference in each Zope application is DBconnection.
> 3. Each DBconnection is connection to each Branch database.
> In other words, if I have 10 branches, I will replicate 10 times of
> same Zope application which is not a wise thing to do. As such,
> I exploring to find a way if there is "dynamically" way to
> change the db connection to the intended (branch) database.
> Thus eliminating the Zope application replication.
> Thank you.
> > May be "dynamically database connection" means that we use the same
> > SQL Method" with different database connections (in the same Zope
> > Instance, of course). So we can change "dynamically" from one
> > to another (schema-equal).
> > In other words, is it possible to define "database connection"
> > of a "Z SQL Method" like we do for parameters ?
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> Zope-DB mailing list
> Zope-DB at zope.org
More information about the Zope-DB