~ getting closer
authorEric Prud'hommeaux <eric@w3.org>
Sun, 14 Feb 2010 10:00:21 -0500
changeset 171 7491b75e5f7c
parent 170 58d01442bf03
child 172 22c5ef94fec7
~ getting closer
src/test/scala/SparqlToSparqlToSqlTest.scala
--- a/src/test/scala/SparqlToSparqlToSqlTest.scala	Sun Feb 14 09:59:39 2010 -0500
+++ b/src/test/scala/SparqlToSparqlToSqlTest.scala	Sun Feb 14 10:00:21 2010 -0500
@@ -240,31 +240,31 @@
 PREFIX NDCcodes: <http://hospital.example/DB/NDCcodes#>
 PREFIX xsd : <http://www.w3.org/2001/XMLSchema#>
 
-SELECT ?patient
+SELECT ?patient ?dob ?sex ?inclu_name ?indicDate 
  WHERE {
     ?patient Person:MiddleName ?middleName .
     ?patient Person:DateOfBirth ?dob .
-    ?patient Person:SexDE ?_0_sexEntry .
-    ?_0_sexEntry Sex_DE:EntryName ?sex .
+    ?patient Person:SexDE ?_0_0_sexEntry .
+    ?_0_0_sexEntry Sex_DE:EntryName ?sex .
 
-    ?_0_indicItem Item_Medication:PatientID ?patient .
-    ?_0_indicItem Item_Medication:PerformedDTTM ?indicDate .
-    ?_0_indicItem Item_Medication:EntryName ?takes .
-    ?_0_indicMed Medication:ItemID ?_0_indicItem .
-    ?_0_indicMed Medication:MedDictDE ?_0_indicDE .
-    ?_0_indicDE Medication_DE:NDC ?indicNDC .
-    ?_0_indicCode NDCcodes:NDC ?indicNDC .
-    ?_0_indicCode NDCcodes:ingredient 6809
+    ?_0_0_indicItem Item_Medication:PatientID ?patient .
+    ?_0_0_indicItem Item_Medication:PerformedDTTM ?indicDate .
+    ?_0_0_indicItem Item_Medication:EntryName ?takes .
+    ?_0_0_indicMed Medication:ItemID ?_0_0_indicItem .
+    ?_0_0_indicMed Medication:MedDictDE ?_0_0_indicDE .
+    ?_0_0_indicDE Medication_DE:NDC ?indicNDC .
+    ?_0_0_indicCode NDCcodes:NDC ?indicNDC .
+    ?_0_0_indicCode NDCcodes:ingredient 6809
 
     MINUS {
-        ?disqualItem Item_Medication:PatientID ?patient .
-        ?disqualItem Item_Medication:PerformedDTTM ?disqualDate .
-        ?disqualItem Item_Medication:EntryName ?takes .
-        ?disqualMed Medication:ItemID ?disqualItem .
-        ?disqualMed Medication:MedDictDE ?disqualDE .
-        ?disqualDE Medication_DE:NDC ?disqualNDC .
-        ?disqualCode NDCcodes:NDC ?disqualNDC .
-        ?disqualCode NDCcodes:ingredient 11289
+        ?_1_0_indicItem Item_Medication:PatientID ?patient .
+        ?_1_0_indicItem Item_Medication:PerformedDTTM ?indicDate .
+        ?_1_0_indicItem Item_Medication:EntryName ?takes .
+        ?_1_0_indicMed Medication:ItemID ?_1_0_indicItem .
+        ?_1_0_indicMed Medication:MedDictDE ?_1_0_indicDE .
+        ?_1_0_indicDE Medication_DE:NDC ?indicNDC .
+        ?_1_0_indicCode NDCcodes:NDC ?indicNDC .
+        ?_1_0_indicCode NDCcodes:ingredient 11289
     }
       }
 """).get