Boost logo

Boost-Commit :

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


Boost-Commit list run by bdawes at acm.org, david.abrahams at rcn.com, gregod at cs.rpi.edu, cpdaniel at pacbell.net, john at johnmaddock.co.uk