wiki:DeveloperGuidelines/DatabaseSynchronization

Version 4 (modified by Fran Boon, 14 years ago) ( diff )

--

DeveloperGuidelines

Database Synchronization

All tables which should be replicated need 2 fields:

SQLField('modified_on','datetime',default=now), # Also needed for T2's conflict detection anyway
SQLField('uuid',length=64,default=uuid.uuid4()),

If using T2 CRUD, then this is all that is required.

If needing to support multiple tables & hence doing manual HTML forms, then you just need to add support within the add_record controller function:

if form.accepts(request.vars,session,keepvalues=True):
    # Update Database
    id=db.table.insert(
        uuid=uuid.uuid4(),

This functionality needs to be developed further to provide a custom UI to do the Import/Export (currently can just use appadmin's default one):


DeveloperGuidelines

Note: See TracWiki for help on using the wiki.