Thanks guys. If I understand correctly, appengine bulk loader can only upload data into gae, but not download from gae. So when I gonna backup online data from my app on gae, I still have to write my own controller function to select 1000 records for downloading. Sounds not smooth, but it is the only way. :-/ Perhaps I shall consider using other slicehost etc. mmmmm
On Nov2, 10:15am, Robin B <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
