Hello, I just created a database connection and want to do some queries from a Python script and solving the problem without defining explicite ZSQL methods and just do some queries from the python script. In a former mail to this list I've got the following hint according to a similiar question: Mon, 13 May 2002, Gilles Lenfant <gilles@objectis.net> wrote:
Zope DAs have a "manage_test" method. The docstring says :
results = someDA.manage_test(query, REQUEST=None)
Executes the SQL in parameter query and returns results
Note you must set the proxy to "manager" to a python script or DTML that executes this method.
Thus I tried results = context.myDBconnection.manage_test('SELECT * FROM table;', \ REQUEST=None) print results return printed And got <Shared.DC.ZRDB.Results.Results instance at 0x91327bc> Hmmm, it seems to work in any way - but how to parse the results object? I tired to find some solutions in the Zope Book but failed because it describes only DTML methods to query databases. Is there any reason to use only DTML with databases and my intention has real drawbacks or is it just a lack of documentation? Kind regards Andreas.