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

Subject: [Boost-commit] svn:boost r78609 - sandbox/icl/libs/xplore/br1/sqlbrowser
From: afojgo_at_[hidden]
Date: 2012-05-25 07:11:03

Author: jofaber
Date: 2012-05-25 07:11:02 EDT (Fri, 25 May 2012)
New Revision: 78609
URL: http://svn.boost.org/trac/boost/changeset/78609

Log:
Critiacal Query.
Text files modified: 
   sandbox/icl/libs/xplore/br1/sqlbrowser/TypeExtensibleDag.sql |    11 +++++++++++                             
   1 files changed, 11 insertions(+), 0 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-25 07:11:02 EDT (Fri, 25 May 2012)
@@ -406,6 +406,8 @@
 select Vertex.key as TrackId
 , TrackName.value as Name
 , MotherAlbum.key as AlbId, AlbumName.value as Album, AlbumYear.value as AlbYr
+, MotherTitle.key as TitId, TitleName.value as Title, TitleYear.value as TitYr 
+, ArtComposedTit.refSourceVertex as CmpId
 from Vertex
   inner join VarCharObject as TrackName on     TrackName.refObject = Vertex.key 
                                            and TrackName.refAttribute = 1
@@ -414,6 +416,15 @@
                                          and MotherAlbum.refEdgeType = 5 -- 5: Album contains Recording
   left outer join VarCharObject as AlbumName on AlbumName.refObject = MotherAlbum.refSourceVertex
   left outer join IntObject     as AlbumYear on AlbumYear.refObject = MotherAlbum.refSourceVertex
+  left outer join Edge as MotherTitle on     MotherTitle.refTargetVertex = Vertex.key  
+                                         and MotherTitle.refEdgeType = 3 -- 3: Title recoreded as Recording
+  left outer join VarCharObject as TitleName on TitleName.refObject = MotherTitle.refSourceVertex
+  left outer join IntObject     as TitleYear on TitleYear.refObject = MotherTitle.refSourceVertex
+  
+  
+-- -----------------------------------------------------------------------------
+  left outer join Edge as ArtComposedTit on     ArtComposedTit.refTargetVertex = MotherTitle.refTargetVertex  
+                                            and ArtComposedTit.refEdgeType = 1 -- 1: Artist compsed Title
   
   
 -- -----------------------------------------------------------------------------