[Zope] Change ZSQLMethod connection id

[Tino Wildenhain]

Fabio schrieb:
> Hi!
> in my zope application I call ZSQLMethods from python script. Is it possible 
> to set "connection id" property of a ZSQLMethod before call it?
> 
> How?
> ZSQLMethod.propertyItems() return only ('title','')

If you set it only one time, you should be able to read it from ZMI
page how to set it (just lookup the method call of the form
and the variables it takes)

If however you want to change it on every call, your ZODB is
going to bloat badly - every change is saved.

In this case you might want to create 2 folders and put
both database connection objects with identical ID
in each of them:

somewhere/aconnectionfolder/dbconnection
somewhere/bconnectionfolder/dbconnection

and set in all your ZSQL methods "dbconnection"
as connection (perhaps while you edit them, use
this path:

somewhere/aconnectionfolder/whereyourzsqlmethodis/yourzsqlmethod/manage_main

where "whereyourzsqlmethodis" does not have to be physically
there (read about Acquisition)

Now, if you want to use one or the other connection, just use:

context.somewhere.aconnection.pathtoyourzsqlmethods.yourzsqlmethod(params...)

or

context.somewhere.bconnection.pathtoyourzsqlmethods.yourzsqlmethod(params...)

while you can even parametrize the path as usually.

HTH
Tino