Re: [Zope] How to specify to z sql methods, the connection object to use at runtime...time...
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...
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...
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...
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 )