On Saturday, August 27, 2016 at 3:29:58 AM UTC-7, goome wrote: > > thank you for your answer and sorry for the delay, i had been some days > away. > > at this time the code that fails is: > tabella = request.args[0] > response.headers['Content-Type']='text/x-csv' > response.headers['Content-Disposition']='attachment;filename="report.csv" > ' > dati = legacy_db().select(legacy_db[tabella].ALL) > s = cStringIO.StringIO() > dati.export_to_csv_file(s) > > > so i should use iterselect when defining dati, but when i try something > like: > """ > for row in legacy_db(legacy_db.COD2.id > 0).iterselect(): > ....: rtn = row > ....: > "" > i get : > "" > --------------------------------------------------------------------------- > > AttributeError Traceback (most recent call > last) > /home/www-data/web2py/applications/PROVE/models/menu.py in <module>() > ----> 1 for row in legacy_db(legacy_db.COD2.id > 0).iterselect(): > 2 rtn = row > 3 > > AttributeError: 'Set' object has no attribute 'iterselect' > > "" >
You may need to show us your define_table statement(s), but it looks like you're writing down a query object and asking for iterselect on it, as in the book example. One of the DB gurus may be needed. > moreover, i should 'append' the row to a pydal.objects.Rows > as to say > dati += row > but how can i do this? > > That one looks easy: data.append(row) > Thank you a lot again > > Good luck! /dps > > 2016-08-04 9:52 GMT+02:00, c...@cemeren.com <javascript:> < > c...@cemeren.com <javascript:>>: > > You may try using iterselect() instead of select() if the issue is > memory > > related. > > > > The link to the book is below. > > > > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=Using-an-iterator-based-select-for-lower-memory-use#Using-an-iterator-based-select-for-lower-memory-use > > > > > On Thursday, August 4, 2016 at 10:35:13 AM UTC+3, goome wrote: > >> > >> 2016-08-04 1:08 GMT+02:00, Dave S <snide...@gmail.com <javascript:>>: > >> > > >> > > >> > On Wednesday, August 3, 2016 at 2:33:35 PM UTC-7, goome wrote: > >> >> > >> >> when trying in the shell, the shell itself got killed : > >> >> >> In [4]: legacy_db(query).select() > >> >> >> > >> >> >> Killed > >> >> >> root@rb:/home/www-data/web2py# > >> >> > >> >> > >> > Is that using web2py in a bash/python shell (i.,e., -M -S myapp) ? > >> yes, this one > >> > > > > -- > > Resources: > > - http://web2py.com > > - http://web2py.com/book (Documentation) > > - http://github.com/web2py/web2py (Source code) > > - https://code.google.com/p/web2py/issues/list (Report Issues) > > --- > > You received this message because you are subscribed to a topic in the > > Google Groups "web2py-users" group. > > To unsubscribe from this topic, visit > > https://groups.google.com/d/topic/web2py/nqUnVx62GE0/unsubscribe. > > To unsubscribe from this group and all its topics, send an email to > > web2py+un...@googlegroups.com <javascript:>. > > For more options, visit https://groups.google.com/d/optout. > > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.