> Thanks guys. If I understand correctly, appengine bulk loader can only > upload data into gae, but not download from gae.
Not true, you can download GAE data to csv. You should read the section titled "Downloading Data from App Engine": http://code.google.com/appengine/docs/python/tools/uploadingdata.html Robin 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 Nov 2, 11:15 am, Iceberg <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
