Changes between Version 6 and Version 7 of Backtracking
- Timestamp:
- Oct 16, 2009, 3:15:39 PM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Backtracking
v6 v7 14 14 In the current version of ismi is needing the following join to build an entity: 15 15 16 ''select * from entity, attribute, entity_attribute where entity.id = X && attribute.id= Y && entity_attribute.entityId = X && entity_attribute.attributeId= Y'', 16 17 {{{ 18 select * from entity, attribute, entity_attribute where entity.id = X && attribute.id= Y && entity_attribute.entityId = X && entity_attribute.attributeId= Y 19 }}} 17 20 Where X, Y are Numbers. 18 21 … … 21 24 The following query will be used to build the current entity: 22 25 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 {{{ 28 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“ 29 }}} 30 Where X and Y are numbers. 24 31 25 32 The 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: … … 29 36 select * 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 30 37 }}} 31 , where X and Y are numbers and Z is a time stamp.38 Where X and Y are numbers and Z is a time stamp. 32 39 33 40 '''Analysis of Behavior'''