Changes between Version 6 and Version 7 of BluePrint/Synchronisation

Timestamp:

12/24/08 02:33:32 (16 years ago)

Author:

Fran Boon

Comment:

--

BluePrint/Synchronisation

@@ -4 +4 @@
  * http://wiki.sahana.lk/doku.php?id=doc:sync:english
 
-This can be done in Web2Py using UUIDs (Universally Unique IDs) & CSV Export/Import:
+The UUIDs have already been configured:
+* DeveloperGuidelinesDatabaseSynchronization
+
+We need to extend this by Exporting the tables (CSV is best-supported within Web2Py currently)
  * http://groups.google.com/group/web2py/browse_thread/thread/c08d1b05ddda672c
+ * http://groups.google.com/group/web2py/browse_thread/thread/be927ccf4d9745d2/637e45ccc2cf2583
+ * 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. (Need clear list of which tables to include - e.g. not lookup lists which are the same across sites, not site-specific stuff such as gis_keys, etc)
+
+Export tables as CSV (in Controller):
 {{{
-import uuid
-SQLField('uuid',default=str(uuid.uuid4())) 
+def export():
+    s=StringIO.StringIO()
+    db.export_to_csv_file(s)
+    response.headers['Content-Type']='text/csv'
+    return s.getvalue() 
 }}}
 
-CSV import/export threads:
- * http://groups.google.com/group/web2py/browse_thread/thread/be927ccf4d9745d2/637e45ccc2cf2583
- * http://groups.google.com/group/web2py/browse_thread/thread/55d923a51eca2c90
+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. 
 
 other related threads: