--- a/D000-1table0rows/create.sql Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-CREATE TABLE Student (
- Name varchar(50)
-);
--- a/D000-1table0rows/directGraph.nt Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,1 +0,0 @@
-# empty graph
--- a/D000-1table0rows/manifest.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,34 +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/> .
-
-<d000> a rdb2rdftest:DataBase;
- dcterms:title "Empty table" ;
- dcterms:identifier "D000-1table0rows" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <dg0000>, <tc0000>;
-.
-
-<dg0000> a rdb2rdftest:DirectMapping;
- dcterms:title "Empty table";
- dcterms:identifier "Direct Graph TC0000" ;
- test:purpose "Tests if an empty table produces an empty RDF graph" ;
- test:specificationReference "#rules_table_triples" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:database <d000> ;
- rdb2rdftest:output "directGraph.nt" ;
-.
-
-<tc0000> a rdb2rdftest:R2RML ;
- dcterms:title "Empty table" ;
- dcterms:identifier "R2RMLTC000" ;
- test:purpose "Tests if an empty table produces an empty RDF graph" ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:database <d000> ;
- rdb2rdftest:output "mapped.nq" ;
- rdb2rdftest:mappingDocument "r2rml.ttl" ;
-.
--- a/D000-1table0rows/mapped.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,1 +0,0 @@
-# empty database
--- a/D000-1table0rows/r2rml.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /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:predicate foaf:name ];
- rr:objectMap [ rr:column "Name" ]
- ]
- .
\ No newline at end of file
--- a/D001-1table1row/create.sql Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-CREATE TABLE Student (
-Name varchar(50)
-);
-INSERT INTO Student (Name) VALUES ('Venus');
--- a/D001-1table1row/directGraph.nt Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,2 +0,0 @@
-_:a <Student#Name> "Venus".
-_:a a <Student> .
--- a/D001-1table1row/manifest.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /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/> .
-
-<d001> a rdb2rdftest:DataBase;
- dcterms:title "One table, one row" ;
- dcterms:identifier "D001-1table1row" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <dg0001>, <tc0001a>, <tc0001b> ;
-.
-
-<dg0001> a rdb2rdftest:DirectMapping;
- dcterms:title "One table, one row";
- dcterms:identifier "Direct Graph TC0001" ;
- test:purpose "Tests: (1) one column mapping, no primary key; (2) generation of a \"BlankNode\" subject; (3) one column to one property" ;
- test:specificationReference "#rules_table_triples" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d001> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "directGraph.nt" ;
-.
-
-<tc0001a> a rdb2rdftest:R2RML ;
- dcterms:title "One column mapping" ;
- dcterms:identifier "R2RMLTC0001a" ;
- test:purpose "Tests: (1) one column mapping, no primary key; (2) subject URI generation by using one single column; (3) one column to one property" ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d001> ;
- rdb2rdftest:output "mappeda.nq" ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:mappingDocument "r2rmla.ttl" ;
-.
-
-<tc0001b> a rdb2rdftest:R2RML ;
- dcterms:title "One column mapping" ;
- dcterms:identifier "R2RMLTC0001b" ;
- test:purpose "Tests: (1) one column mapping, no primary key; (2) generation of a \"BlankNode\" subject; (3) one column to one property" ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d001> ;
- rdb2rdftest:output "mappedb.nq" ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:mappingDocument "r2rmlb.ttl" ;
-.
\ No newline at end of file
--- a/D001-1table1row/mappeda.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,1 +0,0 @@
-<http://example.com/Venus> <http://xmlns.com/foaf/0.1/name> "Venus" .
--- a/D001-1table1row/mappedb.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,1 +0,0 @@
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7fff <http://xmlns.com/foaf/0.1/name> "Venus" .
--- a/D001-1table1row/r2rmla.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /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 "boricles.Student" ];
-
- rr:subjectMap [ rr:template "http://example.com/{Name}" ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [ rr:column "Name" ]
- ]
- .
--- a/D001-1table1row/r2rmlb.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /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 "boricles.Student" ];
-
- rr:subjectMap [ rr:column "Name"; rr:termType rr:BlankNode ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [ rr:column "Name" ]
- ]
- .
--- a/D002-1table2columns1row/create.sql Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,5 +0,0 @@
-CREATE TABLE Student (
-ID integer,
-Name varchar(50)
-);
-INSERT INTO Student (ID, Name) VALUES(10,'Venus');
--- a/D002-1table2columns1row/directGraph.nt Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-_:a a <Student> .
-_:a <Student#id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-_:a <Student#name> "Venus" .
--- a/D002-1table2columns1row/manifest.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /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/> .
-
-<d002> a rdb2rdftest:DataBase;
- dcterms:title "One table, two columns, one row" ;
- dcterms:identifier "D002-1table2columns1row" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <dg0002>, <tc0002a>, <tc0002b> ;
-.
-
-<dg0002> a rdb2rdftest:DirectMapping ;
- dcterms:title "Two columns mapping" ;
- dcterms:identifier "Direct Graph TC0002" ;
- test:purpose "Tests: (1) two columns mapping, no primary key; (2) generation of a \"BlankNode\" subject; (3) one column to one property" ;
- test:specificationReference "#rules_table_triples" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d002> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "directGraph.nt" ;
-.
-
-<tc0002a> a rdb2rdftest:R2RML ;
- dcterms:title "Two columns mapping" ;
- dcterms:identifier "R2RMLTC0002a" ;
- test:purpose "Tests: (1) two column mapping, no primary key; (2) subject URI generated by concatenation of two column values; (3) one column to one property" ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d002> ;
- rdb2rdftest:output "mappeda.nq" ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:mappingDocument "r2rmla.ttl" ;
-.
-
-<tc0002b> a rdb2rdftest:R2RML ;
- dcterms:title "Two columns mapping" ;
- dcterms:identifier "R2RMLTC0002b" ;
- test:purpose "Tests: (1) two column mapping, no primary key; (2) generation of a \"BlankNode\" subject; (3) one column to one property" ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d002> ;
- rdb2rdftest:output "mappedb.nq" ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:mappingDocument "r2rmlb.ttl" ;
-.
\ No newline at end of file
--- a/D002-1table2columns1row/mappeda.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-<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/mappedb.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ffd <http://xmlns.com/foaf/0.1/name> "Venus" .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ffd <http://example.com/id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ffd <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
--- a/D002-1table2columns1row/r2rmla.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,26 +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/{ID}{Name}";
- rr:class foaf:Person ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:id ];
- rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [ rr:column "Name" ]
- ]
- .
--- a/D002-1table2columns1row/r2rmlb.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,32 +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' || ID ) AS StudentId
- , ID
- , Name
- from boricles.Student
- """
- ];
-
- rr:subjectMap [ rr:column "StudentId"; rr:termType rr:BlankNode; rr:class foaf:Person ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:id ];
- rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [ rr:column "Name" ]
- ]
- .
--- a/D003-1table3columns1row/create.sql Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,6 +0,0 @@
-CREATE TABLE Student (
-ID integer,
-FirstName varchar(50),
-LastName varchar(50)
-);
-INSERT INTO Student (ID, FirstName, LastName) VALUES (10,'Venus', 'Williams');
--- a/D003-1table3columns1row/directGraph.nt Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-_:a a <Student> .
-_:a <Student#ID> "10"<http://www.w3.org/2001/XMLSchema#integer> .
-_:a <Student#FirstName> "Venus" .
-_:a <Student#LastName> "Williams" .
--- a/D003-1table3columns1row/manifest.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /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/> .
-
-<d003> a rdb2rdftest:DataBase;
- dcterms:title "One table, two columns, one row" ;
- dcterms:identifier "D003-1table3columns1row" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <dg0003>, <tc0003a>, <tc0003b>;
-.
-
-<dg0003> a rdb2rdftest:DirectMapping ;
- dcterms:title "Two columns mapping" ;
- dcterms:identifier "Direct Graph TC0003" ;
- test:purpose "Tests: (1) two columns mapping, no primary key; (2) generation of a \"BlankNode\" subject; (3) one column to one property" ;
- test:specificationReference "#rules_table_triples" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d003> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "directGraph.nt" ;
-.
-
-<tc0003a> a rdb2rdftest:R2RML ;
- dcterms:title "Two columns mapping" ;
- dcterms:identifier "R2RMLTC0003a" ;
- test:purpose "Tests: (1) two column mapping, no primary key; (2) subject URI generated by concatenation of two column values; (3) one column to one property" ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d003> ;
- rdb2rdftest:output "mappeda.nq" ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:mappingDocument "r2rmla.ttl" ;
-.
-
-<tc0003b> a rdb2rdftest:R2RML ;
- dcterms:title "Two columns mapping" ;
- dcterms:identifier "R2RMLTC0003b" ;
- test:purpose "Tests: (1) two column mapping, no primary key; (2) generation of a \"BlankNode\" subject; (3) one column to one property" ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d003> ;
- rdb2rdftest:output "mappedb.nq" ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:mappingDocument "r2rmlb.ttl" ;
-.
\ No newline at end of file
--- a/D003-1table3columns1row/mappeda.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-<http://example.com/Student10VenusWilliams> <http://xmlns.com/foaf/0.1/lastName> "Williams" .
-<http://example.com/Student10VenusWilliams> <http://xmlns.com/foaf/0.1/firstName> "Venus" .
-<http://example.com/Student10VenusWilliams> <http://example.com/id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<http://example.com/Student10VenusWilliams> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
--- a/D003-1table3columns1row/mappedb.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-<http://example.com/Student10VenusWilliams> <http://xmlns.com/foaf/0.1/name> "Venus Williams" .
-<http://example.com/Student10VenusWilliams> <http://example.com/id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<http://example.com/Student10VenusWilliams> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
--- a/D003-1table3columns1row/mappedc.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ffb <http://xmlns.com/foaf/0.1/lastName> "Williams" .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ffb <http://xmlns.com/foaf/0.1/firstName> "Venus" .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ffb <http://example.com/id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ffb <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
--- a/D003-1table3columns1row/mappedd.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff9 <http://xmlns.com/foaf/0.1/name> "Venus Williams" .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff9 <http://example.com/id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff9 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
--- a/D003-1table3columns1row/r2rmla.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,32 +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 "boricles.Student" ];
-
- rr:subjectMap [ rr:template "http://example.com/Student{ID}{FirstName}{LastName}";
- rr:class foaf:Person ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:id ];
- rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:firstName ];
- rr:objectMap [ rr:column "FirstName" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:lastName ];
- rr:objectMap [ rr:column "LastName" ]
- ]
- .
--- a/D003-1table3columns1row/r2rmlb.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,34 +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 ID,
- (FirstName || ' ' || LastName) AS Name,
- FirstName,
- LastName
- FROM Student
- """
- ];
-
- rr:subjectMap [ rr:template "http://example.com/Student{ID}{FirstName}{LastName}";
- rr:class foaf:Person ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:id ];
- rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [ rr:column "Name" ]
- ]
- .
--- a/D003-1table3columns1row/r2rmlc.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,40 +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' || ID || FirstName || LastName) as StudentID,
- ID,
- FirstName,
- LastName
- FROM Student
- """
- ];
-
- rr:subjectMap [ rr:column "StudentID"; rr:termType rr:BlankNode;
- rr:class foaf:Person ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:id ];
- rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:firstName ];
- rr:objectMap [ rr:column "FirstName" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:lastName ];
- rr:objectMap [ rr:column "LastName" ]
- ]
- .
--- a/D003-1table3columns1row/r2rmld.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,33 +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' || ID || FirstName || LastName) as StudentID,
- ID,
- (FirstName || ' ' || LastName) AS Name
- FROM Student
- """
- ];
-
- rr:subjectMap [ rr:column "StudentID"; rr:termType rr:BlankNode;
- rr:class foaf:Person ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:id ];
- rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [ rr:column "Name" ]
- ]
- .
--- a/D004-1table2columnsprojection/create.sql Tue Sep 27 15:51:56 2011 +0200
+++ /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 Sep 27 15:51:56 2011 +0200
+++ /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 Sep 27 15:51:56 2011 +0200
+++ /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:accepted ;
- 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 "#dfn-output-dataset" ;
- 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 "#dfn-output-dataset" ;
- 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 Sep 27 15:51:56 2011 +0200
+++ /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 Sep 27 15:51:56 2011 +0200
+++ /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 Sep 27 15:51:56 2011 +0200
+++ /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:predicate 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:predicate foaf:name ];
- rr:objectMap [ rr:column "Sport" ]
- ]
- .
\ No newline at end of file
--- a/D004-1table2columnsprojection/r2rmlb.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,42 +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
- from Student_Sport
- """;
- ] ;
-
- rr:subjectMap [ rr:column "StudentId"; rr:termtype rr:BlankNode;
- rr:class ex:Student ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [ rr:column "Student" ]
- ]
- .
-
-<TriplesMap2>
- a rr:TriplesMap;
-
- rr:SQLQuery """
- Select ('Sport' || Sport) AS SportId
- from Student_Sport
- """;
-
- rr:subjectMap [ rr:column "SportId"; rr:termtype rr:BlankNode;
- rr:class ex:Sport ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [ rr:column "Sport" ]
- ]
- .
\ No newline at end of file
--- a/D005-2duplicates0nulls/create.sql Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,7 +0,0 @@
-CREATE TABLE IOUs (
- fname CHAR(20),
- lname CHAR(20),
- amount FLOAT);
-INSERT INTO IOUs (fname, lname, amount) VALUES ('Bob', 'Smith', 30);
-INSERT INTO IOUs (fname, lname, amount) VALUES ('Sue', 'Jones', 20);
-INSERT INTO IOUs (fname, lname, amount) VALUES ('Bob', 'Smith', 30);
--- a/D005-2duplicates0nulls/directGraph.nt Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,15 +0,0 @@
-_:a a <IOUs> .
-_:a <IOUs#fname> "Bob" .
-_:a <IOUs#lname> "Smith" .
-_:a <IOUs#amount> "30"^^<http://www.w3.org/2001/XMLSchema#float> .
-
-_:b a <IOUs> .
-_:b <IOUs#fname> "Sue" .
-_:b <IOUs#lname> "Jones" .
-_:b <IOUs#amount> "20"^^<http://www.w3.org/2001/XMLSchema#float> .
-
-_:c a <IOUs> .
-_:c <IOUs#fname> "Bob" .
-_:c <IOUs#lname> "Smith" .
-_:c <IOUs#amount> "30"^^<http://www.w3.org/2001/XMLSchema#float> .
-
--- a/D005-2duplicates0nulls/manifest.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,22 +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/> .
-
-<d005> a rdb2rdftest:DataBase;
- dcterms:title "Duplicate tuples, no primary key" ;
- dcterms:identifier "D005-2duplicates0nulls" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <dg0005> ;
-.
-
-<dg0005> a rdb2rdftest:DirectMapping ;
- dcterms:title "Duplicate tuples, no primary key";
- dcterms:identifier "Direct Graph TC0005" ;
- test:purpose "Tests the generation of Blank Nodes for duplicate tuples" ;
- test:specificationReference "#rules_table_triples" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d005> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "directGraph.nt" ;
-.
--- a/D006-1table1primarykey1column1row/create.sql Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,4 +0,0 @@
-CREATE TABLE Student (
-Name varchar(50) PRIMARY KEY
-);
-INSERT INTO Student (Name) VALUES ('Venus');
--- a/D006-1table1primarykey1column1row/directGraph.nt Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-<Student/Name.Venus#_> <Student#Name> "Venus" .
-<Student/Name.Venus#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-
--- a/D006-1table1primarykey1column1row/manifest.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,22 +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/> .
-
-<d006> a rdb2rdftest:DataBase;
- dcterms:title "One table, one column, one primary key" ;
- dcterms:identifier "D006-1table1primarykey1column1row" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <dg0006> ;
-.
-
-<dg0006> a rdb2rdftest:DirectMapping ;
- dcterms:title "One table, one column, one primary key";
- dcterms:identifier "Direct Graph TC0006" ;
- test:purpose "Tests a table with a column that is a primary key" ;
- test:specificationReference "#rules_table_triples" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d006> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "directGraph.nt" ;
-.
--- a/D007-1table1primarykey2columns1row/create.sql Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,6 +0,0 @@
-CREATE TABLE Student (
-ID integer,
-Name varchar(50),
-PRIMARY KEY (ID)
-);
-INSERT INTO Student (ID, Name) VALUES(10,'Venus');
--- a/D007-1table1primarykey2columns1row/directGraph.nt Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-<Student/ID.10#_> <Student#ID> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<Student/ID.10#_> <Student#Name> "Venus" .
-<Student/ID.10#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
--- a/D007-1table1primarykey2columns1row/manifest.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,22 +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/> .
-
-<d007> a rdb2rdftest:DataBase;
- dcterms:title "One table, one column, one primary key" ;
- dcterms:identifier "D007-1table1primarykey2columns1row" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <dg0007> ;
-.
-
-<dg0007> a rdb2rdftest:DirectMapping ;
- dcterms:title "A table with a primary key and 2 columns";
- dcterms:identifier "Direct Graph TC0007" ;
- test:purpose "Tests a table with a primary key and 2 columns" ;
- test:specificationReference "#rules_table_triples" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d007> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "directGraph.nt" ;
-.
--- a/D008-1table1compositeprimarykey3columns1row/create.sql Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,7 +0,0 @@
-CREATE TABLE Student (
-ID integer,
-Name varchar(50),
-Sport varchar (50),
-PRIMARY KEY (ID,Name)
-);
-INSERT INTO Student (ID, Name,Sport) VALUES(10,'Venus Williams','Tennis');
--- a/D008-1table1compositeprimarykey3columns1row/directGraph.nt Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,5 +0,0 @@
-<Student/ID.10_Name.Venus+Williams#_> <Student#ID> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<Student/ID.10_Name.Venus+Williams#_> <Student#Name> "Venus Williams" .
-<Student/ID.10_Name.Venus+Williams#_> <Student#Sport> "Tennis" .
-<Student/ID.10_Name.Venus+Williams#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-
--- a/D008-1table1compositeprimarykey3columns1row/manifest.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,22 +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/> .
-
-<d008> a rdb2rdftest:DataBase;
- dcterms:title "Composite primary key" ;
- dcterms:identifier "D008-1table1compositeprimarykey3columns1row" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <dg0008> ;
-.
-
-<dg0008> a rdb2rdftest:DirectMapping ;
- dcterms:title "Composite primary key";
- dcterms:identifier "Direct Graph TC0008" ;
- test:purpose "Tests a table with a composite primary key" ;
- test:specificationReference "#rules_table_triples" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d008> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "directGraph.nt" ;
-.
--- a/D009-2tables1primarykey1foreingkey/create.sql Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,18 +0,0 @@
-CREATE TABLE Sport (
-ID integer,
-Name varchar (50),
-PRIMARY KEY (ID)
-);
-
-CREATE TABLE Student (
-ID integer,
-Name varchar(50),
-Sport integer,
-PRIMARY KEY (ID),
-FOREIGN KEY(Sport) REFERENCES Sport(ID)
-);
-
-INSERT INTO Sport (ID, Name) VALUES (100,'Tennis');
-INSERT INTO Student (ID, Name, Sport) VALUES (10,'Venus Williams', 100);
-INSERT INTO Student (ID, Name, Sport) VALUES (20,'Demi Moore', NULL);
-
--- a/D009-2tables1primarykey1foreingkey/directGraph.nt Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,13 +0,0 @@
-<Student/ID.20#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-<Student/ID.20#_> <Student#ID> "20"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<Student/ID.20#_> <Student#Name> "Demi Moore" .
-
-<Student/ID.10#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-<Student/ID.10#_> <Student#ID> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<Student/ID.10#_> <Student#Name> "Venus Williams" .
-<Student/ID.10#_> <Student#Sport> <Sport/ID.100#_> .
-
-<Sport/ID.100#_> <Sport#ID> "100"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<Sport/ID.100#_> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Sport> .
-<Sport/ID.100#_> <Sport#Name> "Tennis" .
-
--- a/D009-2tables1primarykey1foreingkey/manifest.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,34 +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/> .
-
-<d009> a rdb2rdftest:DataBase;
- dcterms:title "Two tables 1 primary key 1 foreing key" ;
- dcterms:identifier "D009-2tables1primarykey1foreingkey" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <dg0009>, <tc0009>;
-.
-
-<dg0009> a rdb2rdftest:DirectMapping ;
- dcterms:title "Two tables 1 primary key 1 foreing key";
- dcterms:identifier "Direct Graph TC0009" ;
- test:purpose "Tests two tables with a primary key and a foreing key" ;
- test:specificationReference "#rules_table_triples" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d009> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "directGraph.nt" ;
-.
-
-<tc0009> a rdb2rdftest:R2RML ;
- dcterms:title "Two tables to multiple graphs" ;
- dcterms:identifier "R2RMLTC009" ;
- test:purpose "Test that results from distinct parts of the mapping can be directed to different target graphs." ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d009> ;
- rdb2rdftest:output "mapped.nq" ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:mappingDocument "r2rml.ttl" ;
-.
--- a/D009-2tables1primarykey1foreingkey/mapped.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,7 +0,0 @@
-<http://example.com/resource/student_10> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/ontology/Student> <http://example.org/graph/students> .
-<http://example.com/resource/student_10> <http://xmlns.com/foaf/0.1/name> "Venus Williams" <http://example.org/graph/students> .
-<http://example.com/resource/student_20> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/ontology/Student> <http://example.org/graph/students> .
-<http://example.com/resource/student_20> <http://xmlns.com/foaf/0.1/name> "Demi Moore" <http://example.org/graph/students> .
-<http://example.com/resource/sport_100> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/ontology/Sport> <http://example.org/graph/sports> .
-<http://example.com/resource/sport_100> <http://www.w3.org/2000/01/rdf-schema#label> "Tennis" <http://example.org/graph/sports> .
-<http://example.com/resource/student_10> <http://example.com/ontology/practises> <http://example.com/resource/sport_100> <http://example.org/graph/practise> .
\ No newline at end of file
--- a/D009-2tables1primarykey1foreingkey/r2rml.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,68 +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#> .
-@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
-@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
-
-<TriplesMap1>
- a rr:TriplesMap;
-
- rr:logicalTable [ rr:tableName "Student" ];
-
- rr:subjectMap
- [
- rr:template "http://example.com/resource/student_{ID}";
- rr:termType rr:IRI;
- rr:class <http://example.com/ontology/Student>;
- rr:graphMap [ rr:graph <http://example.com/graph/students> ] ;
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [
- rr:column "Name";
- rr:termType rr:Literal;
- ];
- rr:graphMap [ rr:graph <http://example.com/graph/students> ];
- ];
-
- rr:refPredicateObjectMap
- [
- rr:refPredicateMap [ rr:predicate <http://example.com/ontology/practises> ];
- rr:refObjectMap [
- rr:parentTriplesMap <TriplesMap2>;
- rr:joinCondition [
- rr:child "Sport" ;
- rr:parent "ID" ;
- ]
- ];
- rr:graphMap [ rr:graph <http://example.com/graph/practise> ];
- ];
- .
-
-<TriplesMap2>
- a rr:TriplesMapClass;
-
-
- rr:logicalTable [ rr:tableName "Sport" ];
-
- rr:subjectMap
- [
- rr:template "http://example.com/resource/sport_{ID}";
- rr:termType rr:IRI;
- rr:class <http://example.com/ontology/Sport>;
- rr:graphMap [ rr:graph <http://example.com/graph/sports> ];
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate rdfs:label ];
- rr:objectMap [
- rr:column "Name";
- rr:termType rr:Literal;
- ];
- rr:graphMap [ rr:graph <http://example.com/graph/sports> ];
- ];
- .
\ No newline at end of file
Binary file D010-I18NnoSpecialChars/create.sql has changed
--- a/D010-I18NnoSpecialChars/manifest.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,22 +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/> .
-
-<d010> a rdb2rdftest:DataBase;
- dcterms:title "I18N No Special Chars" ;
- dcterms:identifier "D010-I18NnoSpecialChars" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <dg0010> ;
-.
-
-<dg0010> a rdb2rdftest:DirectMapping ;
- dcterms:title "I18N No Special Chars";
- dcterms:identifier "Direct Graph TC0010" ;
- test:purpose "Do we want to encode all [^0-9A-Za-z]?" ;
- test:specificationReference "#rules_table_triples" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d010> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "directGraph.nt" ;
-.
--- a/D011-M2MRelations/create.sql Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,29 +0,0 @@
-CREATE TABLE Student (
-ID integer PRIMARY KEY,
-FirstName varchar(50),
-LastName varchar(50)
-);
-CREATE TABLE Sport (
-ID integer PRIMARY KEY,
-Description varchar(50)
-);
-CREATE TABLE Student_Sport (
-ID_Student integer,
-ID_Sport integer,
-PRIMARY KEY (ID_Student,ID_Sport),
-FOREIGN KEY (ID_Student) REFERENCES Student(ID),
-FOREIGN KEY (ID_Sport) REFERENCES Sport(ID)
-);
-
-INSERT INTO Student (ID,FirstName,LastName) VALUES (10,'Venus', 'Williams');
-INSERT INTO Student (ID,FirstName,LastName) VALUES (11,'Fernando', 'Alonso');
-INSERT INTO Student (ID,FirstName,LastName) VALUES (12,'David', 'Villa');
-
-INSERT INTO Sport (ID, Description) VALUES (110,'Tennis');
-INSERT INTO Sport (ID, Description) VALUES (111,'Football');
-INSERT INTO Sport (ID, Description) VALUES (112,'Formula1');
-
-INSERT INTO Student_Sport (ID_Student, ID_Sport) VALUES (10,110);
-INSERT INTO Student_Sport (ID_Student, ID_Sport) VALUES (11,111);
-INSERT INTO Student_Sport (ID_Student, ID_Sport) VALUES (11,112);
-INSERT INTO Student_Sport (ID_Student, ID_Sport) VALUES (12,111);
--- a/D011-M2MRelations/directGraph.nt Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,44 +0,0 @@
-<Student/ID.12#_> <rdf:type> <Student> .
-<Student/ID.12#_> <Student#FirstName> "David".
-<Student/ID.12#_> <Student#ID> 12 .
-<Student/ID.12#_> <Student#LastName> "Villa" .
-
-<Student_Sport/ID_Student.10,ID_Sport.110#_> <rdf:type> <Student_Sport> .
-<Student_Sport/ID_Student.10,ID_Sport.110#_> <Student_Sport#ID_Sport> <Sport/ID.110#_> .
-<Student_Sport/ID_Student.10,ID_Sport.110#_> <Student_Sport#ID_Student> <Student/ID.10#_> .
-
-<Student/ID.11#_> <rdf:type> <Student> .
-<Student/ID.11#_> <Student#FirstName> "Fernando" .
-<Student/ID.11#_> <Student#ID> 11 .
-<Student/ID.11#_> <Student#LastName> "Alonso" .
-
-<Sport/ID.111#_> <rdf:type> <Sport>.
-<Sport/ID.111#_> <Sport#Description> "Football" .
-<Sport/ID.111#_> <Sport#ID> 111 .
-
-<Sport/ID.110#_> <rdf:type> <Sport> .
-<Sport/ID.110#_> <Sport#Description> "Tennis" .
-<Sport/ID.110#_> <Sport#ID> 110 .
-
-<Student_Sport/ID_Student.12,ID_Sport.111#_> <rdf:type> <Student_Sport> .
-<Student_Sport/ID_Student.12,ID_Sport.111#_> <Student_Sport#ID_Sport> <Sport/ID.111#_> .
-<Student_Sport/ID_Student.12,ID_Sport.111#_> <Student_Sport#ID_Student> <Student/ID.12#_> .
-
-<Student_Sport/ID_Student.11,ID_Sport.111#_> <rdf:type> <Student_Sport> .
-<Student_Sport/ID_Student.11,ID_Sport.111#_> <Student_Sport#ID_Sport> <Sport/ID.111#_> .
-<Student_Sport/ID_Student.11,ID_Sport.111#_> <Student_Sport#ID_Student> <Student/ID.11#_> .
-
-<Student_Sport/ID_Student.11,ID_Sport.112#_> <rdf:type> <Student_Sport> .
-<Student_Sport/ID_Student.11,ID_Sport.112#_> <Student_Sport#ID_Sport> <Sport/ID.112#_> .
-<Student_Sport/ID_Student.11,ID_Sport.112#_> <Student_Sport#ID_Student> <Student/ID.11#_> .
-
-<Sport/ID.112#_> <rdf:type> <Sport> .
-<Sport/ID.112#_> <Sport#Description> "Formula1" .
-<Sport/ID.112#_> <Sport#ID> 112 .
-
-<Student/ID.10#_> <rdf:type> <Student> .
-<Student/ID.10#_> <Student#FirstName> "Venus" .
-<Student/ID.10#_> <Student#ID> 10 .
-<Student/ID.10#_> <Student#LastName> "Williams" .
-
-
--- a/D011-M2MRelations/manifest.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /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/> .
-
-<d011> a rdb2rdftest:DataBase;
- dcterms:title "Many to Many relations" ;
- dcterms:identifier "D011-M2MRelations" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <dg0011>, <tc0011a>, <tc0011b>;
-.
-
-<dg0011> a rdb2rdftest:DirectMapping ;
- dcterms:title "Many to Many relations";
- dcterms:identifier "Direct Graph TC0011" ;
- test:purpose "Tests M to M relations" ;
- test:specificationReference "#rules_table_triples" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d011> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "directGraph.nt" ;
-.
-
-<tc0011a> a rdb2rdftest:R2RML ;
- dcterms:title "M to N relation, by using a SQL query" ;
- dcterms:identifier "R2RMLTC011a" ;
- test:purpose "Tests, M to N relations, by using a SQL query" ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d011> ;
- rdb2rdftest:output "mappeda.nq" ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:mappingDocument "r2rmla.ttl" ;
-.
-
-<tc0011b> a rdb2rdftest:R2RML ;
- dcterms:title "M to N relation, by using an additional Triples Map" ;
- dcterms:identifier "R2RMLTC011b" ;
- test:purpose "Tests, M to N relations, by using an additional Triples Map" ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d011> ;
- rdb2rdftest:output "mappedb.nq" ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:mappingDocument "r2rmlb.ttl" ;
-.
--- a/D011-M2MRelations/mappeda.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,19 +0,0 @@
-<http://example.com/110Tennis> <http://example.com/description> "Tennis" .
-<http://example.com/110Tennis> <http://example.com/id> "110"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<http://example.com/10VenusWilliams> <http://example.com/plays> <http://example.com/110Tennis> .
-<http://example.com/10VenusWilliams> <http://xmlns.com/foaf/0.1/lastName> "Williams" .
-<http://example.com/10VenusWilliams> <http://xmlns.com/foaf/0.1/firstName> "Venus" .
-<http://example.com/10VenusWilliams> <http://example.com/id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<http://example.com/111Football> <http://example.com/description> "Football" .
-<http://example.com/111Football> <http://example.com/id> "111"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<http://example.com/12DavidVilla> <http://example.com/plays> <http://example.com/111Football> .
-<http://example.com/12DavidVilla> <http://xmlns.com/foaf/0.1/lastName> "Villa" .
-<http://example.com/12DavidVilla> <http://xmlns.com/foaf/0.1/firstName> "David" .
-<http://example.com/12DavidVilla> <http://example.com/id> "12"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<http://example.com/112Formula1> <http://example.com/description> "Formula1" .
-<http://example.com/112Formula1> <http://example.com/id> "112"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<http://example.com/11FernandoAlonso> <http://example.com/plays> <http://example.com/112Formula1> .
-<http://example.com/11FernandoAlonso> <http://example.com/plays> <http://example.com/111Football> .
-<http://example.com/11FernandoAlonso> <http://xmlns.com/foaf/0.1/lastName> "Alonso" .
-<http://example.com/11FernandoAlonso> <http://xmlns.com/foaf/0.1/firstName> "Fernando" .
-<http://example.com/11FernandoAlonso> <http://example.com/id> "11"^^<http://www.w3.org/2001/XMLSchema#integer> .
--- a/D011-M2MRelations/mappedb.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,22 +0,0 @@
-<http://example.com/student/10> <http://xmlns.com/foaf/0.1/lastName> "Williams" .
-<http://example.com/student/10> <http://xmlns.com/foaf/0.1/firstName> "Venus" .
-<http://example.com/student/10> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Student> .
-<http://example.com/student/12> <http://xmlns.com/foaf/0.1/lastName> "Villa" .
-<http://example.com/student/12> <http://xmlns.com/foaf/0.1/firstName> "David" .
-<http://example.com/student/12> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Student> .
-<http://example.com/student/11> <http://xmlns.com/foaf/0.1/lastName> "Alonso" .
-<http://example.com/student/11> <http://xmlns.com/foaf/0.1/firstName> "Fernando" .
-<http://example.com/student/11> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Student> .
-<http://example.com/sport/110> <http://example.com/description> "Tennis" .
-<http://example.com/sport/110> <http://example.com/id> "110"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<http://example.com/sport/110> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Sport> .
-<http://example.com/sport/111> <http://example.com/description> "Football" .
-<http://example.com/sport/111> <http://example.com/id> "111"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<http://example.com/sport/111> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Sport> .
-<http://example.com/sport/112> <http://example.com/description> "Formula1" .
-<http://example.com/sport/112> <http://example.com/id> "112"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<http://example.com/sport/112> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/Sport> .
-<http://example.com/student/10> <http://example.com/plays> <http://example.com/sport/110> .
-<http://example.com/student/12> <http://example.com/plays> <http://example.com/sport/111> .
-<http://example.com/student/11> <http://example.com/plays> <http://example.com/sport/112> .
-<http://example.com/student/11> <http://example.com/plays> <http://example.com/sport/111> .
--- a/D011-M2MRelations/r2rmla.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,69 +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.ID as ID,
- Student.FirstName as FirstName,
- Student.LastName as LastName,
- Sport.Description as Description,
- Sport.ID as Sport_ID
- FROM Student,Sport,Student_Sport
- WHERE Student.ID = Student_Sport.ID_Student
- AND Sport.ID = Student_Sport.ID_Sport;
- """; ];
-
- rr:subjectMap [ rr:template "http://example.com/{ID}{FirstName}{LastName}" ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:id ];
- rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:firstName ];
- rr:objectMap [ rr:column "FirstName" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:lastName ];
- rr:objectMap [ rr:column "LastName" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:plays ];
- rr:objectMap [ rr:template "http://example.com/{Sport_ID}{Description}" ]
- ]
- .
-
-<TriplesMap2>
- a rr:TriplesMap;
-
- rr:logicalTable [ rr:tableName "Sport" ];
-
- rr:subjectMap [
- rr:template "http://example.com/{ID}{Description}";
- rr:class ex:Sport;
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:id ];
- rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:description ];
- rr:objectMap [ rr:column "Description" ]
- ]
- .
--- a/D011-M2MRelations/r2rmlb.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,56 +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>
- rr:logicalTable [ rr:tableName "Student"; ] ;
- rr:subjectMap [
- rr:template "http://example.com/student/{ID}";
- rr:class ex:Student;
- ];
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:firstName ];
- rr:objectMap [ rr:column "FirstName" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:lastName ];
- rr:objectMap [ rr:column "LastName" ]
- ]
- .
-
-<TriplesMap2>
- rr:logicalTable [ rr:tableName "Sport"; ] ;
- rr:subjectMap [
- rr:template "http://example.com/sport/{ID}";
- rr:class ex:Sport;
- ];
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:id ];
- rr:objectMap [ rr:column "ID"; rr:datatype xsd:integer ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:description ];
- rr:objectMap [ rr:column "Description" ]
- ]
- .
-
-<LinkMap_1_2>
-
- rr:logicalTable [ rr:tableName "Student_Sport" ];
-
- rr:subjectMap [ rr:template "http://example.com/student/{ID_Student}" ];
-
- rr:predicateObjectMap [
- rr:predicateMap [ rr:predicate ex:plays ];
- rr:objectMap [ rr:template "http://example.com/sport/{ID_Sport}" ];
- ].
-
-
--- a/D012-2tables2duplicates0nulls/create.sql Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,14 +0,0 @@
-CREATE TABLE IOUs (
- fname CHAR(20),
- lname CHAR(20),
- amount FLOAT);
-INSERT INTO IOUs (fname, lname, amount) VALUES ('Bob', 'Smith', 30);
-INSERT INTO IOUs (fname, lname, amount) VALUES ('Sue', 'Jones', 20);
-INSERT INTO IOUs (fname, lname, amount) VALUES ('Bob', 'Smith', 30);
-CREATE TABLE Lives (
- fname CHAR(20),
- lname CHAR(20),
- city CHAR(20));
-INSERT INTO Lives (fname, lname, city) VALUES ('Bob', 'Smith', 'London');
-INSERT INTO Lives (fname, lname, city) VALUES ('Sue', 'Jones', 'Madrid');
-INSERT INTO Lives (fname, lname, city) VALUES ('Bob', 'Smith', 'London');
\ No newline at end of file
--- a/D012-2tables2duplicates0nulls/manifest.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,58 +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#> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-@base <http://mappingpedia.org/rdb2rdf/tc/> .
-
-<d012> a rdb2rdftest:DataBase;
- dcterms:title "Two tables two duplicates zero nulls" ;
- dcterms:identifier "D012-2tables2duplicates0nulls" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <tc0012a>, <tc0012b>, <tc0012c>, <tc0012d> ;
-.
-
-<tc0012a> a rdb2rdftest:R2RML ;
- dcterms:title "Duplicate tuples generate same blank node" ;
- dcterms:identifier "R2RMLTC012a" ;
- test:purpose "Tests that blank nodes with same identifier and in the same graph but generated by different logical rows are considered equivalent." ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d012> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "mappeda.nq" ;
- rdb2rdftest:mappingDocument "r2rmla.ttl" ;
-.
-
-<tc0012b> a rdb2rdftest:R2RML ;
- dcterms:title "Duplicate tuples generate same blank node" ;
- dcterms:identifier "R2RMLTC012b" ;
- test:purpose "Tests that blank nodes with same identifier and in the same graph but generated by different logical rows are considered equivalent." ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d012> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "mappedb.nq" ;
- rdb2rdftest:mappingDocument "r2rmlb.ttl" ;
-.
-
-<tc0012c> a rdb2rdftest:R2RML ;
- dcterms:title "TriplesMap without subjectMap" ;
- dcterms:identifier "R2RMLTC012c" ;
- test:purpose "Tests a R2RML with missing information, TriplesMap without subjectMap." ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d012> ;
- rdb2rdftest:hasExpectedOutput false ;
- rdb2rdftest:mappingDocument "r2rmlc.ttl" ;
-.
-
-<tc0012d> a rdb2rdftest:R2RML ;
- dcterms:title "TriplesMap with two subjectMap" ;
- dcterms:identifier "R2RMLTC012d" ;
- test:purpose "Tests a R2RML with wrong information, TriplesMap with two subjectMap." ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d012> ;
- rdb2rdftest:hasExpectedOutput false ;
- rdb2rdftest:mappingDocument "r2rmld.ttl" ;
-.
--- a/D012-2tables2duplicates0nulls/mappeda.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,6 +0,0 @@
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff3 <http://example.com/amount> "30"^^<http://www.w3.org/2001/XMLSchema#float> .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff3 <http://xmlns.com/foaf/0.1/name> "Bob Smith" .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff3 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/IOU> .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff2 <http://example.com/amount> "20"^^<http://www.w3.org/2001/XMLSchema#float> .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff2 <http://xmlns.com/foaf/0.1/name> "Sue Jones" .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7ff2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/IOU> .
--- a/D012-2tables2duplicates0nulls/mappedb.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,6 +0,0 @@
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7fef <http://example.com/city> "London" .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7fef <http://xmlns.com/foaf/0.1/name> "Bob Smith" .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7fef <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/IOU> .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7fee <http://example.com/amount> "Madrid" .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7fee <http://xmlns.com/foaf/0.1/name> "Sue Jones" .
-_:AX2dX38ec05dcX3aX131488bea58X3aXX2dX7fee <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/IOU> .
--- a/D012-2tables2duplicates0nulls/r2rmla.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,36 +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 "IOUs" ];
-
- rr:subjectMap [
- rr:template "{fname}_{lname}_{amount}";
- rr:termtype rr:BlankNode;
- rr:class ex:IOU;
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [
- rr:template "{fname} {lname}";
- rr:termtype rr:Literal ;
- ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:amount ];
- rr:objectMap [
- rr:column "amount";
- rr:termtype rr:Literal ;
- rr:datatype xsd:float ;
- ]
- ];
- .
\ No newline at end of file
--- a/D012-2tables2duplicates0nulls/r2rmlb.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,46 +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 "IOUs" ];
-
- rr:subjectMap [
- rr:template "{fname}_{lname}";
- rr:termtype rr:BlankNode ;
- rr:class ex:IOU;
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [
- rr:template "{fname} {lname}";
- rr:termtype rr:Literal ;
- ]
- ];
- .
-<TriplesMap2>
- a rr:TriplesMap;
-
- rr:logicalTable [ rr:tableName "Lives" ];
-
- rr:subjectMap [
- rr:template "{fname}_{lname}";
- rr:termtype rr:BlankNode;
- rr:class ex:IOU;
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:city ];
- rr:objectMap [
- rr:column "city";
- rr:termtype rr:Literal ;
- ]
- ];
- .
\ No newline at end of file
--- a/D012-2tables2duplicates0nulls/r2rmlc.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,30 +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 "IOUs" ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [
- rr:template "{fname} {lname}";
- rr:termtype rr:Literal ;
- ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:amount ];
- rr:objectMap [
- rr:column "amount";
- rr:termtype rr:Literal ;
- rr:datatype xsd:float ;
- ]
- ];
- .
\ No newline at end of file
--- a/D012-2tables2duplicates0nulls/r2rmld.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,42 +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 "IOUs" ];
-
- rr:subjectMap [
- rr:template "{fname}_{lname}_{amount}";
- rr:termtype rr:BlankNode;
- rr:class ex:IOU;
- ];
-
- rr:subjectMap [
- rr:template "{amount}_{fname}_{lname}";
- rr:termtype rr:BlankNode;
- rr:class ex:IOU;
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate foaf:name ];
- rr:objectMap [
- rr:template "{fname} {lname}";
- rr:termtype rr:Literal ;
- ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate ex:amount ];
- rr:objectMap [
- rr:column "amount";
- rr:termtype rr:Literal ;
- rr:datatype xsd:float ;
- ]
- ];
- .
\ No newline at end of file
--- a/D013-1table3columns2rows1nullvalue/create.sql Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,8 +0,0 @@
-CREATE TABLE Person (
-ID integer,
-Name varchar(50),
-DateOfBirth varchar(50),
-PRIMARY KEY (ID)
-);
-INSERT INTO Person (ID, Name, DateOfBirth) VALUES (1,'Alice', NULL);
-INSERT INTO Person (ID, Name, DateOfBirth) VALUES (2,'Bob', 'September, 2010');
\ No newline at end of file
--- a/D013-1table3columns2rows1nullvalue/directGraph.nt Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,10 +0,0 @@
-<Person#ID> rdfs:domain <Person> .
-<Person#Name> rdfs:domain <Person> .
-<Person#DateOfBirth> rdfs:domain <Person> .
-
-<Person/ID=1> a <Person> .
-<Person/ID=1> <Person#Name> "Alice" .
-
-<Person/ID=2> a <Person> .
-<Person/ID=2> <Person#Name> "Bob" .
-<Person/ID=2> <Person#DateOfBirth> "September, 2010" .
\ No newline at end of file
--- a/D013-1table3columns2rows1nullvalue/manifest.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,22 +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/> .
-
-<d013> a rdb2rdftest:DataBase;
- dcterms:title "Table with null value" ;
- dcterms:identifier "D013-1table3columns2rows1nullvalue" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <dg0013> ;
-.
-
-<dg0013> a rdb2rdftest:DirectMapping ;
- dcterms:title "Direct Graph of table with NULL values";
- dcterms:identifier "Direct Graph TC0013" ;
- test:purpose "Tests Direct Graph of table with NULL values" ;
- test:specificationReference "#rules_table_triples" ;
- test:reviewStatus test:accepted ;
- rdb2rdftest:database <d013> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "directGraph.nt" ;
-.
--- a/D014-3tablesExample/create.sql Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,20 +0,0 @@
-CREATE TABLE DEPT (
- deptno INTEGER UNIQUE,
- dname VARCHAR(30),
- loc VARCHAR(100));
-INSERT INTO DEPT (deptno, dname, loc) VALUES (10, 'APPSERVER', 'NEW YORK');
-
-CREATE TABLE EMP (
- empno INTEGER PRIMARY KEY,
- ename VARCHAR(100),
- job VARCHAR(30),
- deptno INTEGER REFERENCES DEPT (deptno),
- etype VARCHAR(30));
-INSERT INTO EMP (empno, ename, job, deptno, etype ) VALUES (7369, 'SMITH', 'CLERK', 10, 'PART_TIME');
-
-CREATE TABLE LIKES (
- id INTEGER,
- likeType VARCHAR(30),
- likedObj VARCHAR(100));
-INSERT INTO LIKES (id, likeType, likedObj) VALUES (7369, 'Playing', 'Soccer');
-INSERT INTO LIKES (id, likeType, likedObj) VALUES (7369, 'Watching', 'Basketball');
\ No newline at end of file
--- a/D014-3tablesExample/manifest.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,69 +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#> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-@base <http://mappingpedia.org/rdb2rdf/tc/> .
-
-<d014> a rdb2rdftest:DataBase;
- dcterms:title "3 tables extended example" ;
- dcterms:identifier "D014-3tablesExample" ;
- rdb2rdftest:sqlScriptFile "create.sql";
- rdb2rdftest:relatedTestCase <tc0014a>, <tc0014b>, <tc0014c>, <tc0014d>, <tc0014e> ;
-.
-
-<tc0014a> a rdb2rdftest:R2RML ;
- dcterms:title "3 tables extended example" ;
- dcterms:identifier "R2RMLTC014a" ;
- test:purpose "Tests a logicaltable with sqlQuery" ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d014> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "mappeda.nq" ;
- rdb2rdftest:mappingDocument "r2rmla.ttl" ;
-.
-
-<tc0014b> a rdb2rdftest:R2RML ;
- dcterms:title "3 tables extended example" ;
- dcterms:identifier "R2RMLTC014b" ;
- test:purpose "Mapping specification using SQL-based logical table definition" ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d014> ;
- rdb2rdftest:hasExpectedOutput true ;
- rdb2rdftest:output "mappedb.nq" ;
- rdb2rdftest:mappingDocument "r2rmlb.ttl" ;
-.
-
-<tc0014c> a rdb2rdftest:R2RML ;
- dcterms:title "3 tables extended example" ;
- dcterms:identifier "R2RMLTC014c" ;
- test:purpose "Mapping specification using table name based logical table definition" ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d014> ;
- rdb2rdftest:hasExpectedOutput false ;
- rdb2rdftest:mappingDocument "r2rmlc.ttl" ;
-.
-
-<tc0014d> a rdb2rdftest:R2RML ;
- dcterms:title "3 tables extended example" ;
- dcterms:identifier "R2RMLTC014d" ;
- test:purpose "Mapping specification showing reuse of ObjectMap elements" ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d014> ;
- rdb2rdftest:hasExpectedOutput false ;
- rdb2rdftest:mappingDocument "r2rmld.ttl" ;
-.
-
-<tc0014e> a rdb2rdftest:R2RML ;
- dcterms:title "3 tables extended example" ;
- dcterms:identifier "R2RMLTC014e" ;
- test:purpose "Mapping Specification for the LIKES Table" ;
- test:specificationReference "#dfn-output-dataset" ;
- test:reviewStatus test:unreviewed ;
- rdb2rdftest:database <d014> ;
- rdb2rdftest:hasExpectedOutput false ;
- rdb2rdftest:mappingDocument "r2rmld.ttl" ;
-.
--- a/D014-3tablesExample/mappeda.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,5 +0,0 @@
-_:Department10 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/ns#dept> <http://example.com/ns#DeptGraph> .
-_:Department10 <http://example.com/dept#deptno> "10"^^<http://www.w3.org/2001/XMLSchema#positiveInteger> <http://example.com/ns#DeptGraph> .
-_:Department10 <http://example.com/dept#name> "APPSERVER" <http://example.com/ns#DeptGraph> .
-_:Department10 <http://example.com/dept#location> "NEW YORK" <http://example.com/ns#DeptGraph> .
-_:Department10 <http://example.com/dept#COMPANY> "EXAMPLE Corporation" <http://example.com/ns#DeptGraph> .
\ No newline at end of file
--- a/D014-3tablesExample/mappedb.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,12 +0,0 @@
-<http://example.com/emp/7369> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/ns#emp> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#jobtype> <http://example.com/emp/job/CLERK> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/emp/job/CLERK> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#emptype> <http://example.com/emp/etype/PART_TIME> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/emp/etype/PART_TIME> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#empno> "7369"^^<http://www.w3.org/2001/XMLSchema#integer> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#name> "SMITH" <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#job> "CLERK" <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#deptNum> "10"^^<http://www.w3.org/2001/XMLSchema#integer> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#etype> "PART TIME" <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#c_ref_deptno> _:Department10 <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#name> "SMITH" <http://example.com/emp#empNameGraph> .
\ No newline at end of file
--- a/D014-3tablesExample/mappedc.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,12 +0,0 @@
-<http://example.com/emp/7369> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/ns#emp> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#jobtype> <http://example.com/emp/job/CLERK> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/emp/job/CLERK> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#emptype> <http://example.com/emp/etype/PART_TIME> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/emp/etype/PART_TIME> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#empno> "7369"^^<http://www.w3.org/2001/XMLSchema#integer> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#name> "SMITH" <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#job> "CLERK" <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#deptNum> "10"^^<http://www.w3.org/2001/XMLSchema#integer> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#etype> "PART TIME" <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#c_ref_deptno> _:Department10 <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#name> "SMITH" <http://example.com/emp#empNameGraph> .
--- a/D014-3tablesExample/mappedd.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,12 +0,0 @@
-<http://example.com/emp/7369> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/ns#emp> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#jobtype> <http://example.com/emp/job/CLERK> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/emp/job/CLERK> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#emptype> <http://example.com/emp/etype/PART_TIME> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://example.com/emp/etype/PART_TIME> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#empno> "7369"^^<http://www.w3.org/2001/XMLSchema#integer> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#name> "SMITH" <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#job> "CLERK" <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#deptNum> "10"^^<http://www.w3.org/2001/XMLSchema#integer> <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#etype> "PART TIME" <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#c_ref_deptno> _:Department10 <http://example.com/graph/CLERK/PART_TIME> .
-<http://example.com/emp/7369> <http://example.com/emp#name> "SMITH" <http://example.com/emp#empNameGraph> .
--- a/D014-3tablesExample/mappede.nq Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,2 +0,0 @@
-<http://example.com/emp/7369> <http://example.com/emp/likes/Playing> "Soccer" <http://example.com/ns#LikesGraph> .
-<http://example.com/emp/7369> <http://example.com/emp/likes/Watching> "Basketball" <http://example.com/ns#LikesGraph> .
\ No newline at end of file
--- a/D014-3tablesExample/r2rmla.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,47 +0,0 @@
-@prefix rr: <http://www.w3.org/ns/r2rml#> .
-@prefix ex: <http://example.com/ns#> .
-@prefix emp: <http://example.com/emp#> .
-@prefix dept: <http://example.com/dept#> .
-@prefix likes: <http://example.com/likes#> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
-
-<TriplesMap1>
- a rr:TriplesMap;
- rr:logicalTable [ rr:sqlQuery """
- Select ('Department' || "deptno") AS "deptId"
- , "deptno"
- , "dname"
- , "loc"
- from SCOTT.DEPT
- """ ];
-
- rr:subjectMap [ rr:column "deptId"; rr:termType rr:BlankNode;
- rr:class ex:dept;
- rr:graphMap [ rr:graph ex:DeptGraph; ];
- rr:inverseExpression "{deptno} = substr({deptId},length('Department')+1)"];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:deptno ];
- rr:objectMap [ rr:column "deptno"; rr:datatype xsd:positiveInteger ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:name ];
- rr:objectMap [ rr:column "dname" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:location ];
- rr:objectMap [ rr:column "loc" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:COMPANY ];
- rr:objectMap [ rr:object "EXAMPLE Corporation" ]
- ]
-.
\ No newline at end of file
--- a/D014-3tablesExample/r2rmlb.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,135 +0,0 @@
-@prefix rr: <http://www.w3.org/ns/r2rml#> .
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix ex: <http://example.com/ns#> .
-@prefix emp: <http://example.com/emp#> .
-@prefix dept: <http://example.com/dept#> .
-@prefix likes: <http://example.com/likes#> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
-
-
-<TriplesMap1>
- a rr:TriplesMap;
- rr:logicalTable [ rr:sqlQuery """
- Select ('Department' || deptno) AS deptId
- , deptno
- , dname
- , loc
- from SCOTT.DEPT
- """ ];
-
- rr:subjectMap [ rr:column "deptId"; rr:termType rr:BlankNode;
- rr:class ex:dept;
- rr:graphMap [ rr:graph ex:DeptGraph; ];
- rr:inverseExpression "{deptno} = substr({deptId},length('Department')+1)"];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:deptno ];
- rr:objectMap [ rr:column "deptno"; rr:datatype xsd:positiveInteger ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:name ];
- rr:objectMap [ rr:column "dname" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:location ];
- rr:objectMap [ rr:column "loc" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:COMPANY ];
- rr:objectMap [ rr:object "EXAMPLE Corporation" ]
- ]
-.
-
-<TriplesMap2>
- a rr:TriplesMap;
- rr:logicalTable [ rr:sqlQuery """
- Select ('http://example.com/emp/' || empno) AS empURI
- , empno
- , ename
- , ('http://example.com/emp/job/'|| job) AS jobTypeURI
- , job
- , deptno
- , ('http://example.com/emp/etype/'|| etype) AS empTypeURI
- , etype
- , ('http://example.com/graph/'|| job || '/' || etype) AS graphURI
- from SCOTT.EMP
- """ ];
-
- rr:subjectMap [ rr:column "empURI";
- rr:class ex:emp;
- rr:graphMap [ rr:column "graphURI" ]; ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:jobtype ];
- rr:objectMap [ rr:column "jobTypeURI" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate rdf:type ];
- rr:objectMap [ rr:column "jobTypeURI" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:emptype ];
- rr:objectMap [ rr:column "empTypeURI" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [rdf:predicate rdf:type ];
- rr:objectMap [ rr:column "empTypeURI" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:empno ];
- rr:objectMap [ rr:column "empno" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:name ];
- rr:objectMap [ rr:column "ename" ];
- rr:graphMap [ rr:graph emp:empNameGraph ];
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:job ];
- rr:objectMap [ rr:column "job" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:deptNum ];
- rr:objectMap [ rr:column "deptno" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:etype ];
- rr:objectMap [ rr:column "etype" ]
- ];
-
- rr:predicateObjectMap [
- rr:predicateMap [ rr:predicate emp:c_ref_deptno ];
- rr:refObjectMap [
- rr:parentTriplesMap <TriplesMap1>;
- rr:joinCondition [
- rr:child "deptno";
- rr:parent "deptno";
- ];
- ];
- ]
- .
\ No newline at end of file
--- a/D014-3tablesExample/r2rmlc.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,127 +0,0 @@
-@prefix rr: <http://www.w3.org/ns/r2rml#> .
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix ex: <http://example.com/ns#> .
-@prefix emp: <http://example.com/emp#> .
-@prefix dept: <http://example.com/dept#> .
-@prefix likes: <http://example.com/likes#> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
-
-
-
-<TriplesMap1>
- a rr:TriplesMap;
- rr:logicalTable [ rr:sqlQuery """
- Select ('Department' || deptno) AS deptId
- , deptno
- , dname
- , loc
- from SCOTT.DEPT
- """ ];
-
- rr:subjectMap [ rr:column "deptId"; rr:termType rr:BlankNode;
- rr:class ex:dept;
- rr:graphMap [ rr:graph ex:DeptGraph; ];
- rr:inverseExpression "{deptno} = substr({deptId},length('Department')+1)"];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:deptno ];
- rr:objectMap [ rr:column "deptno"; rr:datatype xsd:positiveInteger ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:name ];
- rr:objectMap [ rr:column "dname" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:location ];
- rr:objectMap [ rr:column "loc" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:COMPANY ];
- rr:objectMap [ rr:object "EXAMPLE Corporation" ]
- ]
-.
-
-<TriplesMap2>
- a rr:TriplesMap;
-
- rr:logicalTable [ rr:tableName "SCOTT.EMP" ];
-
- rr:subjectMap [ rr:template "http://example.com/emp/{empno}";
- rr:class ex:emp;
- rr:graphMap [ rr:template "http://example.com/graph/{job}/{etype}"; ];
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:jobtype ];
- rr:objectMap [ rr:template "http://example.com/emp/job/{job}" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate rdf:type ];
- rr:objectMap [ rr:template "http://example.com/emp/job/{job}" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:emptype ];
- rr:objectMap [ rr:template "http://example.com/emp/etype/{etype}" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate rdf:type ];
- rr:objectMap [ rr:template "http://example.com/emp/etype/{etype}" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:empno ];
- rr:objectMap [ rr:column "empno" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:name ];
- rr:objectMap [ rr:column "ename" ];
- rr:graphMap [ rr:graph emp:empNameGraph ];
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:job ];
- rr:objectMap [ rr:column "job" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:deptNum ];
- rr:objectMap [ rr:column "deptno" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:etype ];
- rr:objectMap [ rr:column "etype" ]
- ];
-
- rr:predicateObjectMap [
- rr:predicateMap [ rr:predicate emp:c_ref_deptno ];
- rr:refObjectMap [
- rr:parentTriplesMap <TriplesMap1>;
- rr:joinCondition [
- rr:child "deptno";
- rr:parent "deptno";
- ];
- ];
- ]
- .
\ No newline at end of file
--- a/D014-3tablesExample/r2rmld.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,136 +0,0 @@
-@prefix rr: <http://www.w3.org/ns/r2rml#> .
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix ex: <http://example.com/ns#> .
-@prefix emp: <http://example.com/emp#> .
-@prefix dept: <http://example.com/dept#> .
-@prefix likes: <http://example.com/likes#> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
-
-<TriplesMap1>
- a rr:TriplesMap;
- rr:logicalTable [ rr:sqlQuery """
- Select ('Department' || deptno) AS deptId
- , deptno
- , dname
- , loc
- from SCOTT.DEPT
- """ ];
-
- rr:subjectMap [ rr:column "deptId"; rr:termType rr:BlankNode;
- rr:class ex:dept;
- rr:graphMap [ rr:graph ex:DeptGraph; ];
- rr:inverseExpression "{deptno} = substr({deptId},length('Department')+1)"];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:deptno ];
- rr:objectMap [ rr:column "deptno"; rr:datatype xsd:positiveInteger ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:name ];
- rr:objectMap [ rr:column "dname" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:location ];
- rr:objectMap [ rr:column "loc" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate dept:COMPANY ];
- rr:objectMap [ rr:object "EXAMPLE Corporation" ]
- ]
-.
-
-
-<#jobtypeObjectMap>
- a rr:ObjectMap;
- rr:template "http://example.com/emp/job/{job}"
- .
-
-<#emptypeObjectMap>
- a rr:ObjectMap;
- rr:template "http://example.com/emp/etype/{etype}"
- .
-
-<TriplesMap2>
- a rr:TriplesMap;
-
- rr:logicalTable [ rr:tableName "SCOTT.EMP" ];
-
- rr:subjectMap [ rr:template "http://example.com/emp/{empno}";
- rr:class ex:emp;
- rr:graphMap [ rr:template "http://example.com/graph/{job}/{etype}"; ];
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:jobtype ];
- rr:objectMap <#jobtypeObjectMap>
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate rdf:type ];
- rr:objectMap <#jobtypeObjectMap>
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:emptype ];
- rr:objectMap <#emptypeObjectMap>
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate rdf:type ];
- rr:objectMap <#emptypeObjectMap>
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:empno ];
- rr:objectMap [ rr:column "empno" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:name ];
- rr:objectMap [ rr:column "ename" ];
- rr:graphMap [ rr:graph emp:empNameGraph ];
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:job ];
- rr:objectMap [ rr:column "job" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:deptNum ];
- rr:objectMap [ rr:column "deptno" ]
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:predicate emp:etype ];
- rr:objectMap [ rr:column "etype" ]
- ];
-
- rr:predicateObjectMap [
- rr:predicateMap [ rr:predicate emp:c_ref_deptno ];
- rr:refObjectMap [
- rr:parentTriplesMap <TriplesMap1>;
- rr:joinCondition [
- rr:child "deptno";
- rr:parent "deptno";
- ];
- ];
- ]
- .
\ No newline at end of file
--- a/D014-3tablesExample/r2rmle.ttl Tue Sep 27 15:51:56 2011 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,29 +0,0 @@
-@prefix rr: <http://www.w3.org/ns/r2rml#> .
-@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
-@prefix ex: <http://example.com/ns#> .
-@prefix emp: <http://example.com/emp#> .
-@prefix dept: <http://example.com/dept#> .
-@prefix likes: <http://example.com/likes#> .
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-@base <http://mappingpedia.org/rdb2rdf/r2rml/tc/> .
-
-<TriplesMap3>
- a rr:TriplesMap;
- rr:logicalTable [ rr:sqlQuery """
- Select ('http://example.com/emp/' || id) AS empId
- , ('http://example.com/emp/likes/' || likeType) AS empLikes
- , likedObj
- from SCOTT.LIKES
- """ ];
-
- rr:subjectMap [
- rr:column "empId";
- rr:graphMap [ rr:graph ex:LikesGraph ];
- ];
-
- rr:predicateObjectMap
- [
- rr:predicateMap [ rr:column "empLikes" ];
- rr:objectMap [ rr:column "likedObj" ]
- ]
- .
\ No newline at end of file