--- a/D004-1table2columns1rowprojection/create.sql Tue Feb 14 17:45:20 2012 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,5 +0,0 @@
-CREATE TABLE "Student_Sport"(
- "Student" varchar(50),
- "Sport" varchar(50)
-);
-INSERT INTO "Student_Sport" ("Student","Sport") VALUES ('Venus', 'Tennis');
--- a/D004-1table2columns1rowprojection/directGraph.nt Tue Feb 14 17:45:20 2012 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-_:a a <Student_Sport> .
-_:a <Student_Sport#Student> "Venus" .
-_:a <Student_Sport#Sport> "Tennis" .
--- a/D004-1table2columns1rowprojection/manifest.ttl Tue Feb 14 17:45:20 2012 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,46 +0,0 @@
-@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/> .
-
-<d004> a rdb2rdftest:DataBase;
- dcterms:title "One table, two columns, one row, projection" ;
- dcterms:identifier "D004-1table2columns1rowprojection" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <dg0004>, <tc0004a>, <tc0004b> ;
-.
-
-<dg0004> a rdb2rdftest:DirectMapping ;
- dcterms:title "Two column mapping";
- dcterms:identifier "Direct Graph TC0004" ;
- test:purpose "Tests: (1) two column mapping, no primary key, (2) generation of a \"BlankNode\" subject; (3) from one row table to two different triples" ;
- test:specificationReference "#rules_table_triples" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d004> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "directGraph.nt" ;
-.
-
-<tc0004a> a rdb2rdftest:R2RML ;
- dcterms:title "Projection" ;
- dcterms:identifier "R2RMLTC0004a" ;
- test:purpose "Tests: (1) two column mapping, no primary key, (2) subject URI generated by a column value; (3) from one row table to two different triples" ;
- test:specificationReference "#typing" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d004> ;
- rdb2rdftest:output "mappeda.nq" ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:mappingDocument "r2rmla.ttl" ;
-.
-
-<tc0004b> a rdb2rdftest:R2RML ;
- dcterms:title "Projection" ;
- dcterms:identifier "R2RMLTC0004b" ;
- test:purpose "Tests: (1) two column mapping, no primary key, (2) generation of a \"BlankNode\" subject; (3) from one row table to two different triples" ;
- test:specificationReference "#r2rml-views" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d004> ;
- rdb2rdftest:output "mappedb.nq" ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:mappingDocument "r2rmlb.ttl" ;
-.
\ No newline at end of file
--- a/D004-1table2columns1rowprojection/mappeda.nq Tue Feb 14 17:45:20 2012 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-<http://example.com/Venus> <http://xmlns.com/foaf/0.1/name> "Venus" .
-<http://example.com/Venus> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Student> .
-<http://example.com/Tennis> <http://xmlns.com/foaf/0.1/name> "Tennis" .
-<http://example.com/Tennis> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Sport> .
--- a/D004-1table2columns1rowprojection/mappedb.nq Tue Feb 14 17:45:20 2012 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff6 <http://xmlns.com/foaf/0.1/name> "Tennis" .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff6 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Sport> .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff7 <http://xmlns.com/foaf/0.1/name> "Venus" .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff7 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Student> .
--- a/D004-1table2columns1rowprojection/r2rmla.ttl Tue Feb 14 17:45:20 2012 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,35 +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_Sport" ];
-
- rr:subjectMap [ rr:template "http://example.com/{Student}";
- rr:class ex:Student ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:constant foaf:name ];
- rr:objectMap [ rr:column "Student" ]
- ]
- .
-
-<TriplesMap2>
- a rr:TriplesMap;
-
- rr:logicalTable [ rr:tableName "Student_Sport" ];
-
- rr:subjectMap [ rr:template "http://example.com/{Sport}";
- rr:class ex:Sport ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:constant foaf:name ];
- rr:objectMap [ rr:column "Sport" ]
- ]
- .
\ No newline at end of file
--- a/D004-1table2columns1rowprojection/r2rmlb.ttl Tue Feb 14 17:45:20 2012 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,45 +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:sqlQuery """
- Select ('Student' || Student) AS StudentId,
- Student
- from Student_Sport
- """;
- ] ;
-
- rr:subjectMap [ rr:column "StudentId"; rr:termType rr:BlankNode;
- rr:class ex:Student ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:constant foaf:name ];
- rr:objectMap [ rr:column "Student" ]
- ]
- .
-
-<TriplesMap2>
- a rr:TriplesMap;
-
- rr:logicalTable [ rr:sqlQuery """
- Select ('Sport' || Sport) AS SportId,
- Sport
- from Student_Sport
- """;
- ];
-
- rr:subjectMap [ rr:column "SportId"; rr:termType rr:BlankNode;
- rr:class ex:Sport ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:constant foaf:name ];
- rr:objectMap [ rr:column "Sport" ]
- ]
- .
\ No newline at end of file
--- a/D004-1table2columnsprojection/create.sql Tue Feb 14 17:45:20 2012 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,5 +0,0 @@
-CREATE TABLE "Student_Sport"(
- "Student" varchar(50),
- "Sport" varchar(50)
-);
-INSERT INTO "Student_Sport" ("Student","Sport") VALUES ('Venus', 'Tennis');
--- a/D004-1table2columnsprojection/directGraph.nt Tue Feb 14 17:45:20 2012 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-_:a a <Student_Sport> .
-_:a <Student_Sport#Student> "Venus" .
-_:a <Student_Sport#Sport> "Tennis" .
--- a/D004-1table2columnsprojection/manifest.ttl Tue Feb 14 17:45:20 2012 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,46 +0,0 @@
-@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/> .
-
-<d004> a rdb2rdftest:DataBase;
- dcterms:title "One table, two columns, projection" ;
- dcterms:identifier "D004-1table2columnsprojection" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <dg0004>, <tc0004a>, <tc0004b> ;
-.
-
-<dg0004> a rdb2rdftest:DirectMapping ;
- dcterms:title "Three column mapping";
- dcterms:identifier "Direct Graph TC0004" ;
- test:purpose "Tests: (1) two column mapping, no primary key, (2) generation of a \"BlankNode\" subject; (3) one row table to two different resources" ;
- test:specificationReference "#rules_table_triples" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d004> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "directGraph.nt" ;
-.
-
-<tc0004a> a rdb2rdftest:R2RML ;
- dcterms:title "Projection" ;
- dcterms:identifier "R2RMLTC0004a" ;
- test:purpose "Tests: (1) two column mapping, no primary key, (2) subject URI generated by a column value; (3) one row table to two different resources" ;
- test:specificationReference "#typing" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d004> ;
- rdb2rdftest:output "mappeda.nq" ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:mappingDocument "r2rmla.ttl" ;
-.
-
-<tc0004b> a rdb2rdftest:R2RML ;
- dcterms:title "Projection" ;
- dcterms:identifier "R2RMLTC0004b" ;
- test:purpose "Tests: (1) two column mapping, no primary key, (2) generation of a \"BlankNode\" subject; (3) one row table to two different resources" ;
- test:specificationReference "#r2rml-views" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d004> ;
- rdb2rdftest:output "mappedb.nq" ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:mappingDocument "r2rmlb.ttl" ;
-.
\ No newline at end of file
--- a/D004-1table2columnsprojection/mappeda.nq Tue Feb 14 17:45:20 2012 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-<http://example.com/Venus> <http://xmlns.com/foaf/0.1/name> "Venus" .
-<http://example.com/Venus> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Student> .
-<http://example.com/Tennis> <http://xmlns.com/foaf/0.1/name> "Tennis" .
-<http://example.com/Tennis> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Sport> .
--- a/D004-1table2columnsprojection/mappedb.nq Tue Feb 14 17:45:20 2012 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff6 <http://xmlns.com/foaf/0.1/name> "Tennis" .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff6 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Sport> .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff7 <http://xmlns.com/foaf/0.1/name> "Venus" .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff7 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Student> .
--- a/D004-1table2columnsprojection/r2rmla.ttl Tue Feb 14 17:45:20 2012 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,35 +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_Sport" ];
-
- rr:subjectMap [ rr:template "http://example.com/{Student}";
- rr:class ex:Student ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:constant foaf:name ];
- rr:objectMap [ rr:column "Student" ]
- ]
- .
-
-<TriplesMap2>
- a rr:TriplesMap;
-
- rr:logicalTable [ rr:tableName "Student_Sport" ];
-
- rr:subjectMap [ rr:template "http://example.com/{Sport}";
- rr:class ex:Sport ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:constant foaf:name ];
- rr:objectMap [ rr:column "Sport" ]
- ]
- .
\ No newline at end of file
--- a/D004-1table2columnsprojection/r2rmlb.ttl Tue Feb 14 17:45:20 2012 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,45 +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:sqlQuery """
- Select ('Student' || Student) AS StudentId,
- Student
- from Student_Sport
- """;
- ] ;
-
- rr:subjectMap [ rr:column "StudentId"; rr:termType rr:BlankNode;
- rr:class ex:Student ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:constant foaf:name ];
- rr:objectMap [ rr:column "Student" ]
- ]
- .
-
-<TriplesMap2>
- a rr:TriplesMap;
-
- rr:logicalTable [ rr:sqlQuery """
- Select ('Sport' || Sport) AS SportId,
- Sport
- from Student_Sport
- """;
- ];
-
- rr:subjectMap [ rr:column "SportId"; rr:termType rr:BlankNode;
- rr:class ex:Sport ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:constant foaf:name ];
- rr:objectMap [ rr:column "Sport" ]
- ]
- .
\ No newline at end of file