Python Python Manual, 7.0pl5 manual XML-RPC Gateway, 118

Remote Access

self.cancelTimer("idle")

self.destroyReferences() return 0

Using the "netrpc" module to access the service, a client might be coded as follows. In this case a separate cursor is created in relation to the queries made about each table in the database.

import netrpc

url = "http://localhost:8000/database" service = netrpc.RemoteService(url)

tables = service.execute("show tables")

timout = 30

for entry in tables:

table = entry[0]

print "table: " + table name = service.cursor(30)

print "cursor: " + url + "/" + name

cursor = netrpc.RemoteService(url+"/"+name) cursor.execute("select * from "+table) desc = cursor.description()

print "desc: " + str(desc) data = cursor.fetchall() print "data: " + str(data) cursor.close()

In general, giving open access to a database in this way may not be advisable, especially over the In- ternet. Such a mechanism might be restricted to a corporate intranet. Alternatively, custom interfaces should be layered on top of the database providing interfaces based on functional requirements.

The XML-RPC Gateway

If the Python NET-RPC client implementation can’t be used because of the need to use a different lan- guage for the client, you might instead consider using the XML-RPC protocol. Clients for the XML- RPC protocol are available in many different languages, many of which are listed at "http://www.xm- lrpc.com". The only change to your server application will be to instantiate an instance of the XML- RPC gateway instead of the NET-RPC gateway.

import netsvc

import netsvc.xmlrpc

dispatcher = netsvc.Dispatcher() dispatcher.monitor(signal.SIGINT)

validator = Validator()

118