Changes between Version 15 and Version 16 of BluePrint/Synchronisation

Timestamp:

02/14/09 14:25:44 (16 years ago)

Author:

Fran Boon

Comment:

Update for current

BluePrint/Synchronisation

@@ -4 +4 @@
  * http://wiki.sahana.lk/doku.php?id=doc:sync:english
 
-The UUIDs have already been configured: DeveloperGuidelinesDatabaseSynchronization
+All tables have UUID fields: DeveloperGuidelinesDatabaseSynchronization
 
-We need to extend this by Exporting the tables (CSV is best-supported within Web2Py currently)[[BR]]
+We can Export the tables - CSV is best-supported within Web2Py currently[[BR]]
 "complete database backup/restore with db.export_to_csv_file(..),db.import_from_csv_file(...),[[BR]]
 reimporting optionally fixes references without need for uuid"
@@ -13 +13 @@
  * http://groups.google.com/group/web2py/browse_thread/thread/55d923a51eca2c90
 
-Initially this can be done using appadmin, but we want to make a user-friendly way of dumping all relevant tables.[[BR]]
+This can be done using appadmin, but we have started work on a user-friendly way of dumping all relevant tables:
+ * {{{controllers/default.py}}}
+ * {{{views/default/export_data.html}}}
+ * {{{views/default/import_data.html}}}
+
 Need clear list of which tables to include:
  * not lookup lists which are the same across sites
   * e.g. !OpenStreetMap/Google Layers (but WMS/SOS Layers Yes. Shapefiles Layers Yes if uploads copied across as well)
  * not site-specific stuff such as system_config, gis_keys, etc
-
-Export tables as CSV (in Controller):
-{{{
-def export():
-    s=StringIO.StringIO()
-    db.export_to_csv_file(s)
-    response.headers['Content-Type']='text/csv'
-    return s.getvalue() 
-}}}
-
-Import tables at the other end:
-{{{
-def import_and_sync():
-    form=FORM(INPUT(_type='file',_name='data'),INPUT(_type='submit'))
-    if form.accepts(request.vars):
-        db.import_from_csv_file(form.vars.data.file)
-        # for every table
-        for table in db.tables:
-        # for every uuid, delete all but the most recent
-            items=db(db[table].id>0).select(db[table].id,db[table].uuid,orderby=~db[table].modified_on,groupby=db[table].uuid)
-            for item in items:
-                db((db[table].uuid==item.uuid)&(db[table].id!=item.id)).delete()
-    return dict(form=form) 
-}}}
 
 Create an index manually to make the search by uuid faster.