The problem is that request is an object and web2py tries to serialize
its methods too. Use this instead:
@service.csv
def download():
requests = db().select(db.guest_request.ALL),as_list()
requests_today = [request for request in requests if request
['created'].date() == datetime.date.today()]
return requests_today
On Aug 13, 11:25 am, Fred <[email protected]> wrote:
> I'm getting incorrect CSV output from a controller function that
> selects from a table and then filters the results before returning it
> as a list. The CSV output contains a spurious 'update_record' column
> where the values seem to be lambda functions.
>
> Here is my controller function:
>
> @service.csv
> def download():
> requests = db().select(db.guest_request.ALL)
> requests_today = [request for request in requests if
> request.created.date() == datetime.date.today()]
> return requests_today
>
> db.guest_request.created is a datetime field. I want the download
> function to return exactly those rows where the 'created' datetime
> value is a time in the current day. I could not figure out how to
> pass that criterion through the web2py DAL so I settled on doing it
> explicitly with python datetime functions. The list comprehension is
> resulting in the right rows.
>
> But the resulting CSV file looks like this:
>
> description,created,update_record,mac_address,requester,id
> Fred testing,2009-08-13 10:57:31,<function <lambda> at 0xb8b085a4>,
> 223344556677,fcy-st,29
>
> The column headings all make sense except for the spurious
> 'update_record' one which does not correspond to any field in my
> guest_request table.
>
> If I return the unfiltered 'requests' object from the function the
> resulting CSV data is fine with no spurious column. But it has too
> many rows then.
>
> So, what is going wrong? Is it wrong to return a list from a
> service.csv function? Do I have to turn it back into a SQLRows object
> first somehow (and if so, then how?) Is there some way to filter a
> SQLRows object in place to do what I need? Is the csv.service tool
> borked?
>
> This is all happening in version 1.65.11.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
