--- 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