Include two more TCs, I18N dm and r2rmlj.
authorBoris Villazon-Terrazas <bvillazon@fi.upm.es>
Mon, 20 Feb 2012 19:54:14 +0100
changeset 45 69309d9646f6
parent 44 ec87cda09361
child 46 7c101f77eec8
Include two more TCs, I18N dm and r2rmlj.
D002-1table2columns1row/manifest.ttl
D002-1table2columns1row/mappedj.nq
D002-1table2columns1row/r2rmlh.ttl
D002-1table2columns1row/r2rmlj.ttl
D017-I18NnoSpecialChars/create.sql
D017-I18NnoSpecialChars/directGraph.nt
D017-I18NnoSpecialChars/manifest.ttl
ts.ttl
ts1.zip
--- a/D002-1table2columns1row/manifest.ttl	Wed Feb 15 18:23:12 2012 +0100
+++ b/D002-1table2columns1row/manifest.ttl	Mon Feb 20 19:54:14 2012 +0100
@@ -7,7 +7,7 @@
 	dcterms:title "One table, two columns, one row, no primary key" ;
 	dcterms:identifier "D002-1table2columns1row" ;
 	rdb2rdftest:sqlScriptFile "create.sql";
-	rdb2rdftest:relatedTestCase <dg0002>, <tc0002a>, <tc0002b>, <tc0002c>, <tc0002d>, <tc0002e>, <tc0002f>, <tc0002g>, <tc0002h>, <tc0002i> ;
+	rdb2rdftest:relatedTestCase <dg0002>, <tc0002a>, <tc0002b>, <tc0002c>, <tc0002d>, <tc0002e>, <tc0002f>, <tc0002g>, <tc0002h>, <tc0002i>, <tc0002j> ;
 .
 
 <dg0002> a rdb2rdftest:DirectMapping ;	
@@ -124,3 +124,14 @@
 	rdb2rdftest:hasExpectedOutput true ;
 	rdb2rdftest:mappingDocument "r2rmli.ttl" ;
 .
+
+<tc0002j> a rdb2rdftest:R2RML ;	
+	dcterms:title "Two columns mapping, qualified column names" ; 
+	dcterms:identifier "R2RMLTC0002h" ;
+	test:purpose "Tests the presence of qualified column names in the SELECT list of the SQL query" ;
+	test:specificationReference "#dfn-sql-identifier" ;
+	test:reviewStatus test:unreviewed ;
+	rdb2rdftest:database <d002> ;
+	rdb2rdftest:hasExpectedOutput true ;
+	rdb2rdftest:mappingDocument "r2rmlj.ttl" ;
+.
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/mappedj.nq	Mon Feb 20 19:54:14 2012 +0100
@@ -0,0 +1,3 @@
+<http://example.com/10Venus> <http://xmlns.com/foaf/0.1/name> "Venus" .
+<http://example.com/10Venus> <http://example.com/id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+<http://example.com/10Venus> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
--- a/D002-1table2columns1row/r2rmlh.ttl	Wed Feb 15 18:23:12 2012 +0100
+++ b/D002-1table2columns1row/r2rmlh.ttl	Mon Feb 20 19:54:14 2012 +0100
@@ -12,7 +12,7 @@
                        Select ('Student' || ID ) AS StudentId
                             , "ID"
                             , "Name"
-					, "ID"
+					, 1 AS "ID"
                        from "SA.Student"
                        """
                        ];
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D002-1table2columns1row/r2rmlj.ttl	Mon Feb 20 19:54:14 2012 +0100
@@ -0,0 +1,31 @@
+@prefix rr: <http://www.w3.org/ns/r2rml#> .
+@prefix foaf: <http://xmlns.com/foaf/0.1/> .
+@prefix ex: <http://example.com/> .
+@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
+@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
+
+<TriplesMap1>
+    a rr:TriplesMap;
+    
+    rr:logicalTable [ 
+                     rr:sqlQuery """
+                       SELECT Student.ID, Student.Name 
+                       FROM Student
+                       """
+                       ];
+
+    rr:subjectMap [ rr:template "http://example.com/{ID}{Name}";
+                    rr:class foaf:Person ];
+
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:constant ex:id ]; 
+      rr:objectMap    [ rr:column "ID"; rr:datatype xsd:integer ]
+    ];
+
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:constant foaf:name ]; 
+      rr:objectMap    [ rr:column "Name" ]
+	]
+    .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D017-I18NnoSpecialChars/create.sql	Mon Feb 20 19:54:14 2012 +0100
@@ -0,0 +1,15 @@
+CREATE TABLE "植物" (
+  "名" CHAR(10),
+  "使用部" CHAR(10),
+  "条件" CHAR(10),
+  PRIMARY KEY ("名", "使用部")
+);
+INSERT INTO "植物" ("名", "使用部", "条件") VALUES ('しそ', '葉', '新鮮な');
+
+CREATE TABLE "成分" (
+  "皿"  CHAR(10),
+  "植物名" CHAR(10),
+  "使用部" CHAR(10),
+  FOREIGN KEY ("植物名", "使用部") REFERENCES "植物"("名", "使用部")
+);
+INSERT INTO "成分" ("皿", "植物名", "使用部") VALUES ('しそのとまと', 'しそ', '葉');
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D017-I18NnoSpecialChars/directGraph.nt	Mon Feb 20 19:54:14 2012 +0100
@@ -0,0 +1,9 @@
+<植物/名.しそ,使用部.葉#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <植物> .
+<植物/名.しそ,使用部.葉#_> <植物#使用部> "葉" .       
+<植物/名.しそ,使用部.葉#_> <植物#名>  "しそ" .
+<植物/名.しそ,使用部.葉#_> <植物#条件> "新鮮な" .
+_:a <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <成分> .
+_:a <成分#使用部> "葉" .
+_:a <成分#植物名> "しそ" .
+_:a <成分#植物名,使用部> <植物/名.しそ,使用部.葉#_> .
+_:a <成分#皿> "しそのとまと" .
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D017-I18NnoSpecialChars/manifest.ttl	Mon Feb 20 19:54:14 2012 +0100
@@ -0,0 +1,22 @@
+@prefix test: <http://www.w3.org/2006/03/test-description#> .
+@prefix dcterms: <http://purl.org/dc/elements/1.1/> .
+@prefix rdb2rdftest: <http://purl.org/NET/rdb2rdf-test#> .
+@base <http://www.w3.org/2001/sw/rdb2rdf/test-cases/#> .
+
+<d017> a rdb2rdftest:DataBase;
+	dcterms:title "I18N No Special Chars" ;
+	dcterms:identifier "D017-I18NnoSpecialChars" ;
+	rdb2rdftest:sqlScriptFile "create.sql";
+	rdb2rdftest:relatedTestCase <dg017> ;
+.
+
+<dg0017> a rdb2rdftest:DirectMapping ;	
+	dcterms:title "I18N No Special Chars" ; 
+	dcterms:identifier "DirectGraphTC0017" ;
+	test:purpose "I18N No Special Chars" ;
+	test:specificationReference "#no-pk" ;
+	test:reviewStatus test:unreviewed ;
+	rdb2rdftest:database <d017> ;
+	rdb2rdftest:hasExpectedOutput true ;	
+	rdb2rdftest:output "directGraph.nt" ;
+.
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/ts.ttl	Mon Feb 20 19:54:14 2012 +0100
@@ -0,0 +1,9 @@
+@prefix test: <http://www.w3.org/2006/03/test-description#> .
+@prefix dcterms: <http://purl.org/dc/elements/1.1/> .
+@prefix rdb2rdftest: <http://purl.org/NET/rdb2rdf-test#> .
+@base <http://mappingpedia.org/rdb2rdf/tc/> .
+
+<ts> a rdb2rdftest:TestSuite;
+	dcterms:title "Test Suite for R2RML and Direct Mapping" ;
+	dcterms:identifier "TS-01" ;
+	rdb2rdftest:workingDirectory "./local" .
\ No newline at end of file
Binary file ts1.zip has changed