It works on GAE except that GAE has a limit to accessing 1000 records at the time and also a short timeout. You cannot use export_to_cvs or import_from_cvs_file on GAE is you have more than 1000 records.
On Oct 31, 10:35 pm, Iceberg <iceb...@21cn.com> wrote: > Hi folks, > > Thanks for the hint Thadeus and Massimo give in this post > http://groups.google.com/group/web2py/browse_frm/thread/d891a1e936599362 > > Yet I have one more relevant quick question. Does the > export_to_csv_file() and import_from_csv_file() solution also work > when one db is on gae? Actually I am looking for a way to backup and > restore the db of my production app. It should be straightforward if > the app is running on any shared host, but on GAE it seems I can not > easily get the entire db file. So is export_to_csv_file() and > import_from_csv_file() the only solution for gae? Thanks in advance. > > Pseudo code. > > if request.env.web2py_runtime_gae: > db=DAL('gae') > else: > db=DAL('sqlite://storage.sqlite') > > def download_db(): > return db.export_to_csv_file(...) > def upload_db() > db.import_from_csv_file( a_csv_upload_just_now ) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
