[Zope] FW: [Zope] and remote databases in other [zopes]

[Loren Stafford]

-----Original Message-----
From: Loren Stafford [mailto:lstafford@icompression.com]
Sent: Friday, September 24, 1999 10:32
To: codelarvs@ciudad.com.ar
Subject: RE: [Zope] and remote databases in other [zopes]


Oh-oh. I feel another How-To coming on...

I did something just like this last week with the help of other list
members. It goes like this:

1. You want to use ZClient, which is located in your Zope directory at
../lib/python/ZPublisher/Client.py. Read the comments to get an idea of how
it works. Basically, it acts as a web browser.

2. Because, ZClient is an external Python program, you have to create an
external method to drive it from within DTML. Use the How-To: Using External
Methods at http://www.zope.org/Documentation/How-To/ExternalMethods to help
you add an external Python method similar to this:

from ZPublisher import Client

def web_client(url = 'http://www.yahoo.com/', username = None, password =
None, **kw):
     '''access http servers'''
     if kw:
         return Client.call(url,username,password,kw)[1]
     else:
         return Client.call(url,username,password)[1]

My version of this Python code resides at ../Extensions/WebClient.py and the
external method name is also WebClient.

3. Create one or more DTML methods that call this external method with the
correct parameters to access your NT server. Here's a simple example that
doesn't require any more parameters than the URL of an SQL method on the
database server:

<!--#var standard_html_header-->
<h2><!--#var document_title--></h2>
<dtml-var "webClient('http://nt-server:8080/Marketing/AllCustHave')">
<!--#var standard_html_footer-->

That's all!

-- Loren


> -----Original Message-----
> From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
> codelarvs@ciudad.com.ar
> Sent: Thursday, September 23, 1999 19:05
> To: zope@zope.org
> Subject: [Zope] and remote databases in other [zopes]
>
>
> Hello! I have the folowing problem:
> I'm using Zope on a SUN Sparc machine running Solaris..
> The site works nice, but I need to access the data, that is
> placed on a Microsoft SQL Server on a Windows NT and i cant change
> that :\
> I've read in the Docs when i was installing that is possible
> to have a zope in each machine.. and use the one in the
> NT like an iterface. For example: Lets say.. If I define a Dtml method
> that gets the data from the SQL in the zope in Windows NT..
> Can I call that method from the Zope in the SUN to retrieve the
> data from
> the Microsoft SQL?. If there's a way to do this (with
> 2 zopes or another way).. could someone please explain me
> how to do it?
>
> Thanks!
>                    Nahuel Greco.
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://www.zope.org/mailman/listinfo/zope
>
> (To receive general Zope announcements, see:
> http://www.zope.org/mailman/listinfo/zope-announce
>
> For developer-specific issues, zope-dev@zope.org -
> http://www.zope.org/mailman/listinfo/zope-dev )
>