Changes between Version 6 and Version 7 of Backtracking


Ignore:
Timestamp:
Oct 16, 2009, 3:15:39 PM (15 years ago)
Author:
jurzua
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Backtracking

    v6 v7  
    1414In the current version of ismi is needing the following join to build an entity:
    1515
    16   ''select * from entity, attribute,  entity_attribute where entity.id = X && attribute.id= Y &&  entity_attribute.entityId = X && entity_attribute.attributeId= Y'',
     16
     17{{{
     18select * from entity, attribute,  entity_attribute where entity.id = X && attribute.id= Y &&  entity_attribute.entityId = X && entity_attribute.attributeId= Y
     19}}}
    1720Where X, Y are Numbers.
    1821
     
    2124The following query will be used to build the current entity:
    2225
    23   ''select * from entity, attribute,  entity_attribute where entity.id = X && attribute.id= Y &&  entity_attribute.entityId = X && entity_attribute.attributeId= Y && entity.systemStatus = “original” && attribute.systemStatus = original“'', where X and Y are numbers.
     26
     27{{{
     28select * from entity, attribute,  entity_attribute where entity.id = X && attribute.id= Y &&  entity_attribute.entityId = X && entity_attribute.attributeId= Y && entity.systemStatus = “original” && attribute.systemStatus = original“
     29}}}
     30Where X and Y are numbers.
    2431
    2532The attribute systemStatus is not useful to build the a version of an entity, because every entity's versions will have the same value. The attribute unique for each version is the modifier, therefore the query will look like this:
     
    2936select * from entity, attribute,  entity_attribute where entity.id = X && attribute.id= Y &&  entity_attribute.entityId = X && entity_attribute.attributeId= Y && entity. modifier = Z && attribute. modifier = Z
    3037}}}
    31 , where X and Y are numbers and Z is a time stamp.
     38Where X and Y are numbers and Z is a time stamp.
    3239
    3340'''Analysis of Behavior'''