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

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

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

Log:
Critiacal Query.
Text files modified: 
   sandbox/icl/libs/xplore/br1/sqlbrowser/TypeExtensibleDag.sql |    10 ++++++----                              
   1 files changed, 6 insertions(+), 4 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:14:36 EDT (Fri, 25 May 2012)
@@ -405,9 +405,10 @@
 -- create view Track as
 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
+, MotherAlbum.refSourceVertex as AlbId, AlbumName.value as Album, AlbumYear.value as AlbYr
+, MotherTitle.refSourceVertex as TitId, TitleName.value as Title, TitleYear.value as TitYr
+, Duration.value as Dur 
+, Genre.value as Genre 
 from Vertex
   inner join VarCharObject as TrackName on     TrackName.refObject = Vertex.key 
                                            and TrackName.refAttribute = 1
@@ -420,7 +421,8 @@
                                          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 VarCharObject as Duration  on Duration.refObject = Vertex.key and Duration.refAttribute = 2
+  left outer join VarCharObject as Genre     on Genre.refObject = Vertex.key and Genre.refAttribute = 3
   
 -- -----------------------------------------------------------------------------
   left outer join Edge as ArtComposedTit on     ArtComposedTit.refTargetVertex = MotherTitle.refTargetVertex