http://localhost/ticket/1137 <p> Statefulness, especially statefulness for relation (esp m2m) is cause of most of the complexity in vdm. It is <em>required</em> because, atm, revision objects have FKs to continuity objects. </p> <p> This ticket proposes the following changes: </p> <p> NB: this could be limited just to case of join tables (leaving state stuff on other tables) </p> <ul><li>Remove FKs from revision to continuity (or allow for them to be nullable). <ul><li>We could just limit this to m2m stuff </li></ul></li><li>Delete of an object leads to: <ul><li>Deletion of continuity object </li><li>Adding an entry in revision table with state set to deleted (we retain state on revision table) </li></ul></li></ul><p> If this is done we will no longer need to worry about filtering on state on relationships as join table will only contain "active" relationships. </p> <p> If we do this on all tables we remove need for any state awareness in client (e.g. no need to filter tables on active state). </p> <p> The only disadvantage of this change is that undeletion becomes more problematic (we have to recreate some continuity objects). </p> en-us http://assets.okfn.org/p/ckan/img/ckan_logo_shortname.png http://localhost/ticket/1137 Trac 0.12.3 rgrp Thu, 12 May 2011 14:47:52 GMT http://localhost/ticket/1137#comment:1 http://localhost/ticket/1137#comment:1 <p> Most of this change has been implemented in the changeset branch <a class="missing changeset" title="No default repository defined">[1]</a> but could be backported reasonably easily to main. </p> <p> <a class="missing changeset" title="No default repository defined">[1]</a>: <a class="ext-link" href="https://bitbucket.org/okfn/vdm/src/changeset/"><span class="icon">​</span>https://bitbucket.org/okfn/vdm/src/changeset/</a> </p> Ticket kindly Thu, 12 May 2011 16:24:09 GMT http://localhost/ticket/1137#comment:2 http://localhost/ticket/1137#comment:2 <p> I am not sure this needs to be done. I think we should keep the continuity object always in the table, even if it is deleted. The querying should be done through the logic layer so the deleted state should not be an issue. </p> <p> The clients should be entirely state aware. </p> <p> The only thing that needs to be done is to remove all statefullness of relations. These are the only things that are complicated. </p> <p> This would make vdm just a simple copy on write mechanism, with the client controlling the state. </p> Ticket icmurray Mon, 25 Jun 2012 13:46:14 GMT http://localhost/ticket/1137#comment:3 http://localhost/ticket/1137#comment:3 <ul> <li><strong>owner</strong> changed from <em>rgrp</em> to <em>kindly</em> </li> <li><strong>status</strong> changed from <em>new</em> to <em>assigned</em> </li> </ul> Ticket