wiki:BluePrint/Synchronisation

Version 6 (modified by Fran Boon, 13 years ago) ( diff )

--

This page hosts the detailed specification for the Blueprint for the Synchronisation.

We need to be able to support synchronising data between instances:

This can be done in Web2Py using UUIDs (Universally Unique IDs) & CSV Export/Import:

import uuid
SQLField('uuid',default=str(uuid.uuid4())) 

CSV import/export threads:

other related threads:

There is a simple 1-table example appliance which has the ability to do syncs via XML-RPC:

In S2 the record ids are UUIDs built from each instance's 'base_uuid'

There is a sync_instance table:

CREATE TABLE sync_instance (
    base_uuid VARCHAR(4) NOT NULL, -- Instance id
    owner VARCHAR(100), -- Instance owner's name
    contact TEXT, -- Contact details of the instance owner
    url VARCHAR(100) DEFAULT NULL, -- Server url if exists
    last_update TIMESTAMP NOT NULL, -- Last Time sync with the instance
    sync_count INT DEFAULT 0, -- Number of times synchronized
    PRIMARY KEY(base_uuid)
);
Note: See TracWiki for help on using the wiki.