You can can increase timeout (web2py.py -h) or, better, use the shell
python web2py.py -S yourapp -M
>>> db.export_to_csv_file(open('/path/to/file.csv','wb'))
On Sep 14, 3:02 am, Richard <[email protected]> wrote:
> hello,
>
> I was trying out the export recipe in ch 6.8 of the manual and
> received a timeout error:
>
> >>> fp = open('20090914.db', 'wb')
> >>> db.export_to_csv_file(fp)
>
> Traceback (most recent call last):
> File "<console>", line 1, in <module>
> File "/home/web2py/gluon/sql.py", line 1056, in export_to_csv_file
> self(self[table].id > 0).select().export_to_csv_file(ofile)
> File "/home/web2py/gluon/sql.py", line 2212, in select
> r = response(query)
> File "/home/web2py/gluon/sql.py", line 2207, in response
> self._db._execute(query)
> File "/home/web2py/gluon/sql.py", line 770, in <lambda>
> self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> ProgrammingError: canceling statement due to statement timeout
>
> The database is quite big so I guess that is causing the timeout. Is
> there a way to export large databases with web2py?
>
> Richard
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
