Re: [Zope] How to specify to z sql methods, the connection object to use at runtime...time...

2000-12-06 Thread Frederic Quin

Thanks to yall...
Finally, I thought like you Randy... I created as many folders as many
servers I have. Each folder contains a connection object called "con"
every where. Each folder contains also Z SQL Methods. Some of them
contains the same Z SQL Methods. So, I just have to specify the server I
want to connect to and use directly the Z SQL Method I want.

My folders (called like my servers) are Transparent Folder. So, I can
call directly some Z SQL Methods which are available only on one
server...


Fred



Randall Kern wrote:
 
 I haven't actually tried this, but it seems it should work:
 
 /
 /db1- folder
 connection- a DB connection object to db 1
 /db2- folder
 connection- a DB connection object to db 2
 query- a ZSqlMethod, set to use the connection 'connection'.  Note,
 you may have to add a temporary DB connection to the root, to allow you to
 setup these methods.  After you have created your methods, remove the
 /connection object.
 
 Then use urls like http://your.server/db1/query to run the query using the
 first database connection, and http://your.server/db2/query to run query
 using the second database connection.
 
 -Randy
 - Original Message -
 From: "Tino Wildenhain" [EMAIL PROTECTED]
 To: "Frederic Quin" [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Tuesday, December 05, 2000 4:56 AM
 Subject: Re: [Zope] How to specify to z sql methods, the connection object
 to use at runtime...time...
 
  Hi Frederic,
 
  Frederic Quin schrieb:
  
   Hi all,
  
   I have the same querry to execute on different servers. I don't want to
   create as many z sql methods as servers I have. I would like to specify
   to my z sql method, the connection object to use at run time. Do I have
   to patch the files of z sql methods ? Can I use directly the connection
   object ??
  A clean approach would be subclassing the zsql-method
  for your purpose. I would not recommend a free-form
  string as argument for the Datasource. May be an integer index
  (first, second, third... database server)
  or something like that?
 
  Regards
  Tino
 
  ___
  Zope maillist  -  [EMAIL PROTECTED]
  http://lists.zope.org/mailman/listinfo/zope
  **   No cross posts or HTML encoding!  **
  (Related lists -
   http://lists.zope.org/mailman/listinfo/zope-announce
   http://lists.zope.org/mailman/listinfo/zope-dev )
 

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




Re: [Zope] How to specify to z sql methods, the connection object to use at runtime...time...

2000-12-05 Thread Tino Wildenhain

Hi Frederic,

Frederic Quin schrieb:
 
 Hi all,
 
 I have the same querry to execute on different servers. I don't want to
 create as many z sql methods as servers I have. I would like to specify
 to my z sql method, the connection object to use at run time. Do I have
 to patch the files of z sql methods ? Can I use directly the connection
 object ??
A clean approach would be subclassing the zsql-method
for your purpose. I would not recommend a free-form
string as argument for the Datasource. May be an integer index 
(first, second, third... database server) 
or something like that? 

Regards
Tino

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




Re: [Zope] How to specify to z sql methods, the connection object to use at runtime...time...

2000-12-05 Thread Randall Kern

I haven't actually tried this, but it seems it should work:

/
/db1- folder
connection- a DB connection object to db 1
/db2- folder
connection- a DB connection object to db 2
query- a ZSqlMethod, set to use the connection 'connection'.  Note,
you may have to add a temporary DB connection to the root, to allow you to
setup these methods.  After you have created your methods, remove the
/connection object.

Then use urls like http://your.server/db1/query to run the query using the
first database connection, and http://your.server/db2/query to run query
using the second database connection.

-Randy
- Original Message -
From: "Tino Wildenhain" [EMAIL PROTECTED]
To: "Frederic Quin" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, December 05, 2000 4:56 AM
Subject: Re: [Zope] How to specify to z sql methods, the connection object
to use at runtime...time...


 Hi Frederic,

 Frederic Quin schrieb:
 
  Hi all,
 
  I have the same querry to execute on different servers. I don't want to
  create as many z sql methods as servers I have. I would like to specify
  to my z sql method, the connection object to use at run time. Do I have
  to patch the files of z sql methods ? Can I use directly the connection
  object ??
 A clean approach would be subclassing the zsql-method
 for your purpose. I would not recommend a free-form
 string as argument for the Datasource. May be an integer index
 (first, second, third... database server)
 or something like that?

 Regards
 Tino

 ___
 Zope maillist  -  [EMAIL PROTECTED]
 http://lists.zope.org/mailman/listinfo/zope
 **   No cross posts or HTML encoding!  **
 (Related lists -
  http://lists.zope.org/mailman/listinfo/zope-announce
  http://lists.zope.org/mailman/listinfo/zope-dev )



___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] How to specify to z sql methods, the connection object to use at runtime...time...

2000-12-04 Thread Frederic Quin

Hi all,

I have the same querry to execute on different servers. I don't want to
create as many z sql methods as servers I have. I would like to specify
to my z sql method, the connection object to use at run time. Do I have
to patch the files of z sql methods ? Can I use directly the connection
object ???


Thanks
Frederic Quin

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )