[Boost-commit] svn:boost r78503 - sandbox/icl/libs/xplore/br1/sqlbrowser

Subject: [Boost-commit] svn:boost r78503 - sandbox/icl/libs/xplore/br1/sqlbrowser
From: afojgo_at_[hidden]
Date: 2012-05-18 05:41:46

Author: jofaber
Date: 2012-05-18 05:41:45 EDT (Fri, 18 May 2012)
New Revision: 78503
URL: http://svn.boost.org/trac/boost/changeset/78503

Log:
Experiments with the DB
Binary files modified: 
   sandbox/icl/libs/xplore/br1/sqlbrowser/objects1.db
Text files modified: 
   sandbox/icl/libs/xplore/br1/sqlbrowser/TypeExtensibleDag.sql |    62 ++++++++++++++++++++++++++++----------- 
   1 files changed, 44 insertions(+), 18 deletions(-)

Modified: sandbox/icl/libs/xplore/br1/sqlbrowser/TypeExtensibleDag.sql
==============================================================================
--- sandbox/icl/libs/xplore/br1/sqlbrowser/TypeExtensibleDag.sql	(original)
+++ sandbox/icl/libs/xplore/br1/sqlbrowser/TypeExtensibleDag.sql	2012-05-18 05:41:45 EDT (Fri, 18 May 2012)
@@ -15,15 +15,15 @@
 create table Object (key integer primary key);
 create table Attribute (key integer primary key, refObjectType integer, name varchar);
 
-create table Field (key integer primary key, refObject integer, refAttribute integer, seqnum integer);
-
-create table VarCharField (refField integer primary key, value varchar);
-
-
 
 create table IntObject (refObject integer, refAttribute integer, value integer, primary key (refObject, refAttribute));
 create table VarCharObject (refObject integer, refAttribute integer, value varchar, primary key (refObject, refAttribute));
 
+//CL?
+create table Field (key integer primary key, refObject integer, refAttribute integer, seqnum integer);
+create table VarCharField (refField integer primary key, value varchar);
+create table IntField (refField integer primary key, value integer);
+
 
 
 
@@ -132,7 +132,23 @@
 select Object.key as Obj, VarCharObject.value as Name
 from Object
   inner join VarCharObject   on VarCharObject.refObject = Object.key
-    
+
+-- -----------------------------------------------------------------------------
+-- Named Objects 1:1 Attributes joined horizontally.
+select Object.key as Obj, Name.value as Name, YearOfCrea.value as YoC, Position.value as Pos, Duration.value as Dur 
+from Object
+  inner join VarCharObject      as Name       on Name.refObject       = Object.key and  Name.refAttribute = 1
+  left outer join IntObject     as YearOfCrea on YearOfCrea.refObject = Object.key and  YearOfCrea.refAttribute = 2
+  left outer join VarCharObject as Duration   on Duration.refObject   = Object.key and  Duration.refAttribute = 3  
+  left outer join VarCharObject as Position   on Position.refObject   = Object.key and  Position.refAttribute = 4  
+
+-- -----------------------------------------------------------------------------
+-- Named Objects 1:1 Attributes joined horizontally.
+select Object.key as Obj, VarCharObject.refAttribute as Attr, VarCharObject.value as Value
+from Object
+  inner join VarCharObject on VarCharObject.refObject = Object.key
+
+  
 -- -----------------------------------------------------------------------------
 -- Vertexes
 select Vertex.key as Vtx, Object.key as Obj, ObjectType.Name as Type , Attribute.Name as Attr, 
@@ -190,18 +206,6 @@
   inner join VarCharObject as TrgName on Edge.refTargetVertex = TrgName.refObject
   left outer join IntObject on IntObject.refObject        = Object.key  
   
-
--- -----------------------------------------------------------------------------
--- Artists
-select Vertex.key as Vtx, Object.key as Obj, VarCharObject.value as Name, IntObject.value as YoBirth
-from Vertex
-  inner join Object        on Object.key = Vertex.refObject
-  inner join VarCharObject on Object.key = VarCharObject.refObject and VarCharObject.refAttribute = 1  
-  inner join IntObject     on Object.key = IntObject.refObject     and IntObject.refAttribute = 2 
-where
-  Vertex.refObjectType = 1
-
-  
 -- -----------------------------------------------------------------------------
 -- Edges 2.
 -- 
@@ -223,3 +227,25 @@
   inner join Object on Object.key = Vertex.refObject
   inner join VarCharObject on Object.key = VarCharObject.refObject
 
+  
+-- -----------------------------------------------------------------------------
+-- Fields
+
+
+-- -----------------------------------------------------------------------------
+-- Artists
+select Vertex.key as Vtx, Object.key as Obj, VarCharObject.value as Name, IntObject.value as YoBirth
+from Vertex
+  inner join Object        on Object.key = Vertex.refObject
+  inner join VarCharObject on Object.key = VarCharObject.refObject and VarCharObject.refAttribute = 1  
+  inner join IntObject     on Object.key = IntObject.refObject     and IntObject.refAttribute = 2 
+where
+  Vertex.refObjectType = 1
+
+
+-- -----------------------------------------------------------------------------
+-- Utils
+alter table VarCharObject add seqnum integer
+
+  
+

Modified: sandbox/icl/libs/xplore/br1/sqlbrowser/objects1.db
==============================================================================
Binary files. No diff available.