Specify workflow for updates

[timgdavies]

We need to describe a clear workflow for updates to data.

This ticket as a placeholder.

[timgdavies]

Handling manual edits

It would be useful to allow minor edits to be made through a web interface. Ontowiki supports this, but we need to capture the history of edits, so they can be re-applied if data is re-imported in future.

Using the history

When edits are made through Ontowiki a history is maintained via the erfurt API in the Versioning Actions and Versioning Payload tables.

The query:

SELECT * FROM DB.DBA.ef_versioning_actions LEFT JOIN DB.DBA.ef_versioning_payloads ON DB.DBA.ef_versioning_payloads.id = payload_id WHERE model = 'http://resourceprojects.org/' 

fetches all the changes stored in history with hashes. For example, the following hashes represent removing the labels 'Uk' and 'UK' from 'http://resourceprojects.org/country/gb':

 a:1:{s:38:"http://resourceprojects.org/country/gb";a:1:{s:45:"http://www.w3.org/2004/02/skos/core#prefLabel";a:1:{i:0;a:3:{s:5:"value";s:2:"Uk";s:4:"type";s:7:"literal";s:4:"lang";s:2:"en";}}}}
 a:1:{s:38:"http://resourceprojects.org/country/gb";a:1:{s:45:"http://www.w3.org/2004/02/skos/core#prefLabel";a:1:{i:0;a:3:{s:5:"value";s:2:"UK";s:4:"type";s:7:"literal";s:4:"lang";s:2:"en";}}}}

Need to identify the meaning of s:38 etc. to work out how we know this is a command to remove triples.