Mailing List Archive: Retrieving Data from Z SQL in Python

Retrieving Data from Z SQL in Python

May 18, 2005, 3:03 PM

Post #1 of 3 (1320 views)

Hello,

I have a very simple Z SQL method that works fine when I test run it. But
when I call it from a Python script (see below) and attempt to print the
result, I get the following error:

Error Type: TypeError
Error Value: cannot concatenate 'str' and 'ImplicitAcquirerWrapper' objects

------ Python script -----
# Import a standard function, and get the HTML request and response objects.
##from Products.PythonScripts.standard import html_quote
request = container.REQUEST
RESPONSE = request.RESPONSE

data = context.getChunk1()
for data_row in data:
print "data-row="+data_row
return printed

Anybody?
-- christer

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: Retrieving Data from Z SQL in Python [ In reply to ]

Cliff.Ford at ed

May 18, 2005, 11:16 PM

Post #2 of 3 (1286 views)

Permalink

Christer Fernstrom wrote:
> Hello,
>
> I have a very simple Z SQL method that works fine when I test run it. But
> when I call it from a Python script (see below) and attempt to print the
> result, I get the following error:
>
> Error Type: TypeError
> Error Value: cannot concatenate 'str' and 'ImplicitAcquirerWrapper' objects
>
> ------ Python script -----
> # Import a standard function, and get the HTML request and response
> objects.
> ##from Products.PythonScripts.standard import html_quote
> request = container.REQUEST
> RESPONSE = request.RESPONSE
>
> data = context.getChunk1()
> for data_row in data:
> print "data-row="+data_row
> return printed

You need to iterate over the columns in the row:

data = context.getChunk1()
for data_row in data:
print "data-row="
for item in data_row:
print item + ' '
return printed

It is more normal to fetch one result row at a time:

for data_row in context.getChunk1():
# and handle the results by column name
print data_row.FirstName
print ' '
print data_row.Surname
...
return printed

HTH

Cliff
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: Retrieving Data from Z SQL in Python [ In reply to ]

myzope at fernstromOnThe

May 19, 2005, 1:26 PM

Post #3 of 3 (1293 views)

Permalink

----- Original Message -----
From: "Cliff Ford" <Cliff.Ford@ed.ac.uk>
To: "Christer Fernstrom" <myzope@fernstromOnThe.net>
Cc: <zope-db@zope.org>
Sent: Thursday, May 19, 2005 8:16 AM
Subject: Re: [Zope-DB] Retrieving Data from Z SQL in Python

>
> Christer Fernstrom wrote:
>> Hello,
>>
>> I have a very simple Z SQL method that works fine when I test run it. But
>> when I call it from a Python script (see below) and attempt to print the
>> result, I get the following error:
>>
>> Error Type: TypeError
>> Error Value: cannot concatenate 'str' and 'ImplicitAcquirerWrapper'
>> objects
>>
>> ------ Python script -----
>> # Import a standard function, and get the HTML request and response
>> objects.
>> ##from Products.PythonScripts.standard import html_quote
>> request = container.REQUEST
>> RESPONSE = request.RESPONSE
>>
>> data = context.getChunk1()
>> for data_row in data:
>> print "data-row="+data_row
>> return printed
>
> You need to iterate over the columns in the row:
>
> data = context.getChunk1()
> for data_row in data:
> print "data-row="
> for item in data_row:
> print item + ' '
> return printed
>
> It is more normal to fetch one result row at a time:
>
> for data_row in context.getChunk1():
> # and handle the results by column name
> print data_row.FirstName
> print ' '
> print data_row.Surname
> ...
> return printed
>
> HTH
>
> Cliff
>

Thanks Cliff. What you propose works fine!
-- christer

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db