Include new data error TC
authorBoris Villazon-Terrazas <bvillazon@fi.upm.es>
Mon, 27 Feb 2012 20:34:19 +0100
changeset 53 647bd29abe11
parent 52 6f3784e16482
child 54 35ca4a8f0d42
Include new data error TC
D002-1table2columns1row/create.sql
D006-1table1primarykey1column1row/manifest.ttl
D006-1table1primarykey1column1row/r2rmla.txt
D018-1table1primarykey2columns3rows/create.sql
D018-1table1primarykey2columns3rows/directGraph.nt
D018-1table1primarykey2columns3rows/manifest.ttl
D018-1table1primarykey2columns3rows/mappeda.nq
D018-1table1primarykey2columns3rows/r2rmla.ttl
D019-1table1primarykey3columns3rows/create.sql
D019-1table1primarykey3columns3rows/manifest.ttl
D019-1table1primarykey3columns3rows/mappeda.nq
D019-1table1primarykey3columns3rows/r2rmla.ttl
D019-1table1primarykey3columns3rows/r2rmlb.ttl
ts1.zip
--- a/D002-1table2columns1row/create.sql	Mon Feb 27 18:27:47 2012 +0100
+++ b/D002-1table2columns1row/create.sql	Mon Feb 27 20:34:19 2012 +0100
@@ -1,5 +1,5 @@
 CREATE TABLE "Student" (
-"ID" integer,
-"Name" varchar(50)
+"ID" INTEGER,
+"Name" VARCHAR(15)
 );
 INSERT INTO "Student" ("ID", "Name") VALUES(10,'Venus');
--- a/D006-1table1primarykey1column1row/manifest.ttl	Mon Feb 27 18:27:47 2012 +0100
+++ b/D006-1table1primarykey1column1row/manifest.ttl	Mon Feb 27 20:34:19 2012 +0100
@@ -13,7 +13,7 @@
 <dg0006> a rdb2rdftest:DirectMapping ;	
 	dcterms:title "Generation of subjects"; 
 	dcterms:identifier "DirectGraphTC0006" ;
-	test:purpose "Tests a the generation of subjects" ;
+	test:purpose "Tests the generation of subjects" ;
 	test:specificationReference "#lead-ex" ;
 	test:reviewStatus test:unreviewed ;
 	rdb2rdftest:database <d006> ;
--- a/D006-1table1primarykey1column1row/r2rmla.txt	Mon Feb 27 18:27:47 2012 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,19 +0,0 @@
-@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:tableName "Student" ];
-
-    rr:subjectMap [ rr:template "http://example.com/{Name}" ]; 
-	
-    rr:predicateObjectMap
-    [ 
-      rr:predicateMap [ rr:constant foaf:name ]; 
-      rr:objectMap    [ rr:column "Name" ]
-    ]
-    .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D018-1table1primarykey2columns3rows/create.sql	Mon Feb 27 20:34:19 2012 +0100
@@ -0,0 +1,7 @@
+CREATE TABLE "Student" (
+"ID" INTEGER,
+"Name" CHAR(15) 
+);
+INSERT INTO "Student" ("ID","Name") VALUES (10,'Venus');
+INSERT INTO "Student" ("ID","Name") VALUES (20,'Fernando');
+INSERT INTO "Student" ("ID","Name") VALUES (30,'David');
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D018-1table1primarykey2columns3rows/directGraph.nt	Mon Feb 27 20:34:19 2012 +0100
@@ -0,0 +1,9 @@
+_:a <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
+_:a <Student#id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+_:a <Student#name> "Venus          " .
+_:a <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
+_:a <Student#id> "20"^^<http://www.w3.org/2001/XMLSchema#integer> .
+_:a <Student#name> "Fernando       " .
+_:a <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
+_:a <Student#id> "30"^^<http://www.w3.org/2001/XMLSchema#integer> .
+_:a <Student#name> "David          " .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D018-1table1primarykey2columns3rows/manifest.ttl	Mon Feb 27 20:34:19 2012 +0100
@@ -0,0 +1,34 @@
+@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/#> .
+
+<d018> a rdb2rdftest:DataBase;
+	dcterms:title "One table, one primary key, two columns, three rows" ;
+	dcterms:identifier "D018-1table1primarykey2columns3rows" ;
+	rdb2rdftest:sqlScriptFile "create.sql";
+	rdb2rdftest:relatedTestCase <dg0018>, <tc0018a> ;
+.
+
+<dg0018> a rdb2rdftest:DirectMapping ;	
+	dcterms:title "Generation of triples by using CHAR datatype column"; 
+	dcterms:identifier "DirectGraphTC0018" ;
+	test:purpose "Generation of triples by using CHAR datatype column, resulting RDF literal is space-padded." ;
+	test:specificationReference "#lead-ex" ;
+	test:reviewStatus test:unreviewed ;
+	rdb2rdftest:database <d018> ;
+	rdb2rdftest:hasExpectedOutput true ;
+	rdb2rdftest:output "directGraph.nt" ;
+.
+
+<tc0018a> a rdb2rdftest:R2RML ;	
+	dcterms:title "Generation of triples by using CHAR datatype column" ; 
+	dcterms:identifier "R2RMLTC0018a" ;
+	test:purpose "Generation of triples by using CHAR datatype column, resulting RDF literal is space-padded." ;
+	test:specificationReference "#from-template" ;
+	test:reviewStatus test:unreviewed ;
+	rdb2rdftest:database <d018> ;
+	rdb2rdftest:output "mappeda.nq" ;
+	rdb2rdftest:hasExpectedOutput true ;
+	rdb2rdftest:mappingDocument "r2rmla.ttl" ;
+.
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D018-1table1primarykey2columns3rows/mappeda.nq	Mon Feb 27 20:34:19 2012 +0100
@@ -0,0 +1,9 @@
+<http://example.com/10> <http://xmlns.com/foaf/0.1/name> "Venus          " .
+<http://example.com/10> <http://example.com/id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+<http://example.com/10> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
+<http://example.com/20> <http://xmlns.com/foaf/0.1/name> "Fernando       " .
+<http://example.com/20> <http://example.com/id> "20"^^<http://www.w3.org/2001/XMLSchema#integer> .
+<http://example.com/20> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
+<http://example.com/30> <http://xmlns.com/foaf/0.1/name> "David          " .
+<http://example.com/30> <http://example.com/id> "30"^^<http://www.w3.org/2001/XMLSchema#integer> .
+<http://example.com/30> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D018-1table1primarykey2columns3rows/r2rmla.ttl	Mon Feb 27 20:34:19 2012 +0100
@@ -0,0 +1,26 @@
+@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:tableName "Student" ];
+
+    rr:subjectMap [ rr:template "http://example.com/{ID}";
+                    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" ]
+    ]
+    .
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D019-1table1primarykey3columns3rows/create.sql	Mon Feb 27 20:34:19 2012 +0100
@@ -0,0 +1,8 @@
+CREATE TABLE "Employee" (
+"ID" INTEGER,
+"FirstName" VARCHAR(50),
+"LastName" VARCHAR(50)
+);
+INSERT INTO "Employee" ("ID","FirstName","LastName") VALUES (10,'http://example.com/ns#Jhon','Smith');
+INSERT INTO "Employee" ("ID","FirstName","LastName") VALUES (20,'Carlos','Mendoza');
+INSERT INTO "Employee" ("ID","FirstName","LastName") VALUES (30,'Juan Daniel','Crespo');
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D019-1table1primarykey3columns3rows/manifest.ttl	Mon Feb 27 20:34:19 2012 +0100
@@ -0,0 +1,34 @@
+@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/#> .
+
+<d019> a rdb2rdftest:DataBase;
+	dcterms:title "One table, one primary key, three columns, three rows" ;
+	dcterms:identifier "D019-1table1primarykey3columns3rows" ;
+	rdb2rdftest:sqlScriptFile "create.sql";
+	rdb2rdftest:relatedTestCase <tc0019a>, <tc0019b> ;
+.
+
+<tc0019a> a rdb2rdftest:R2RML ;	
+	dcterms:title "Generation of triples by using IRI value in columns" ; 
+	dcterms:identifier "R2RMLTC0019a" ;
+	test:purpose "Test the generation of triples by using IRI value in columns" ;
+	test:specificationReference "#generated-rdf-term" ;
+	test:reviewStatus test:unreviewed ;
+	rdb2rdftest:database <d019> ;
+	rdb2rdftest:output "mappeda.nq" ;
+	rdb2rdftest:hasExpectedOutput true ;
+	rdb2rdftest:mappingDocument "r2rmla.ttl" ;
+.
+
+<tc0019b> a rdb2rdftest:R2RML ;	
+	dcterms:title "Generation of triples by using IRI value in columns" ; 
+	dcterms:identifier "R2RMLTC0019b" ;
+	test:purpose "Test the generation of triples by using IRI value in columns, conforming R2RML mapping with data error (and no result)" ;
+	test:specificationReference "#generated-rdf-term" ;
+	test:reviewStatus test:unreviewed ;
+	rdb2rdftest:database <d019> ;
+	rdb2rdftest:hasExpectedOutput false ;
+	rdb2rdftest:mappingDocument "r2rmlb.ttl" ;	
+.
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D019-1table1primarykey3columns3rows/mappeda.nq	Mon Feb 27 20:34:19 2012 +0100
@@ -0,0 +1,2 @@
+<http://example.com/ns#Jhon> <http://xmlns.com/foaf/0.1/name> "http://example.com/ns#Jhon" .
+<http://mappingpedia.org/rdb2rdf/r2rml/tc/Carlos> <http://xmlns.com/foaf/0.1/name> "Carlos" .
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D019-1table1primarykey3columns3rows/r2rmla.ttl	Mon Feb 27 20:34:19 2012 +0100
@@ -0,0 +1,23 @@
+@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 "ID", "FirstName", "LastName" 
+                       FROM "Employee"
+                       WHERE "ID" < 30
+                       """
+                       ];
+    
+	rr:subjectMap [ rr:column "FirstName" ]; 
+	rr:predicateObjectMap
+    [ 
+      rr:predicate foaf:name; 
+      rr:objectMap    [ rr:column "FirstName" ];
+    ];
+.
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D019-1table1primarykey3columns3rows/r2rmlb.ttl	Mon Feb 27 20:34:19 2012 +0100
@@ -0,0 +1,16 @@
+@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:tableName "Employee" ];
+	rr:subjectMap [ rr:column "FirstName" ]; 
+	rr:predicateObjectMap
+    [ 
+      rr:predicate foaf:name; 
+      rr:objectMap    [ rr:column "FirstName" ];
+    ];
+.
Binary file ts1.zip has changed