specifically, using "python web2py.py --import_models --no-cron --
shell=myapp"
Then making an expensive database query to export the database.
On Sep 18, 10:02 am, Richard <richar...@gmail.com> wrote:
> no - from command line.
>
> On Sep 16, 2:37 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > You are not talking about the web based shell, are you?
>
> > On Sep 15, 8:34 pm, Richard <richar...@gmail.com> wrote:
>
> > > it's strange then that I received the timeout error in the shell. Is
> > > this a bug, or is there another possible cause?
>
> > > On Sep 15, 12:07 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > No timeout does not apply to the shell.
>
> > > > On Sep 14, 6:56 pm, Richard <richar...@gmail.com> wrote:
>
> > > > > I was in the shell (hence the ">>>") when I received this error.
> > > > > Does --timeout=TIMEOUT also apply to the shell?
>
> > > > > Richard
>
> > > > > On Sep 15, 12:10 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > > > 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 <richar...@gmail.com> 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 web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
