[Zope] MySQL queries in Python

[Dennis Allison]

Usually you install the database adaptor ZMySQLDB and make queries through 
a ZSQL Method object.

On Tue, 1 Aug 2006, Muk Yan wrote:

> Dear Coveted Braintrust,
> 
> I was wondering if anyone had any experience with MySQL queries in Python in
> Zope:
> 
> import MySQLdb
> import string
> 
> request = container.REQUEST
> session = request.SESSION
> 
> result = (context.aq_parent).selects.select_from_table()
> 
> print result
> return printed
> 
> WHERE select.select_from_table() IS:
> 
> SELECT name
> FROM person
> WHERE ID = <dtml-var "REQUEST.SESSION.get('person_id')">
> 
> I know the MySQL query works, but I get garbage results from the python
> script (<Shared.DC.ZRDB.Results.Results instance at 0x132a5c88>).  All I
> want is to contain the results of the SQL query in a list or container.
> 
> Thanks and take care,
> Muk Yan
> 

--