Take a look at the appengine bulk loader: http://code.google.com/appengine/docs/python/tools/uploadingdata.html
Once you have the data locally as csv, you can load it into a sql database by writing a script to import it into web2py. Robin On Oct 31, 10:48 pm, mdipierro <[email protected]> wrote: > 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 <[email protected]> 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 [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 -~----------~----~----~----~------~----~------~--~---
