Included more test cases
authorBoris Villazon-Terrazas <bvillazon@fi.upm.es>
Wed, 20 Jul 2011 19:12:51 +0100
changeset 10 270a11b2adc2
parent 9 8c8d201b55a1
child 11 fd20eac2d562
Included more test cases
D010-I18NnoSpecialChars/create.sql
D010-I18NnoSpecialChars/directGraph.nt
D010-I18NnoSpecialChars/manifest.ttl
D011-M2MRelations/create.sql
D011-M2MRelations/directGraph.nt
D011-M2MRelations/manifest.ttl
D011-M2MRelations/mapped.nq
D011-M2MRelations/r2rml.ttl
D012-2tables2duplicates0nulls/create.sql
D012-2tables2duplicates0nulls/manifest.ttl
D012-2tables2duplicates0nulls/mappeda.nq
D012-2tables2duplicates0nulls/mappedb.nq
D012-2tables2duplicates0nulls/r2rmla.ttl
D012-2tables2duplicates0nulls/r2rmlb.ttl
D013-1table3columns2rows1nullvalue/create.sql
D013-1table3columns2rows1nullvalue/directGraph.nt
D013-1table3columns2rows1nullvalue/manifest.ttl
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D010-I18NnoSpecialChars/directGraph.nt	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,13 @@
+<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" .
+
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D010-I18NnoSpecialChars/manifest.ttl	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,21 @@
+@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:output "directGraph.nt" ;
+.
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D011-M2MRelations/create.sql	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,29 @@
+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);
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D011-M2MRelations/directGraph.nt	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,44 @@
+<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" .
+
+
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D011-M2MRelations/manifest.ttl	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,33 @@
+@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> ;
+	rdb2rdftest:relatedTestCase <tc0011> ;	
+.
+
+<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:output "directGraph.nt" ;
+.
+
+<tc0011> a rdb2rdftest:R2RML ;	
+	dcterms:title "M to N relation" ; 
+	dcterms:identifier "R2RMLTC011" ;
+	test:purpose "Tests, M to N relations." ;
+	test:specificationReference "#dfn-output-dataset" ;
+	test:reviewStatus test:unreviewed ;
+	rdb2rdftest:database <d011> ;
+	rdb2rdftest:output "mapped.nq" ;
+	rdb2rdftest:mappingDocument "r2rml.ttl" ;
+.
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D011-M2MRelations/mapped.nq	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,19 @@
+<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> .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D011-M2MRelations/r2rml.ttl	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,67 @@
+@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:TriplesMapClass;
+
+       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:TriplesMapClass;
+
+    rr:tableOwner "boricles";
+    rr:tableName "Sport";
+
+    rr:subjectMap [ rr:template "http://example.com/{ID}{Description}" ];
+
+    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" ]
+    ]
+    .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D012-2tables2duplicates0nulls/create.sql	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,29 @@
+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);
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D012-2tables2duplicates0nulls/manifest.ttl	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,36 @@
+@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/> .
+
+<d012> a rdb2rdftest:DataBase;
+	dcterms:title "Two tables two duplicates zero nulls" ;
+	dcterms:identifier "D012-2tables2duplicates0nulls" ;
+	rdb2rdftest:sqlScriptFile "create.sql";
+	rdb2rdftest:relatedTestCase <tc0012a> ;
+	rdb2rdftest:relatedTestCase <tc0012b> ;
+.
+
+<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: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:output "mappeda.nq" ;
+	rdb2rdftest:mappingDocument "r2rmlb.ttl" ;
+.
+
+
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D012-2tables2duplicates0nulls/mappeda.nq	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,6 @@
+_: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> .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D012-2tables2duplicates0nulls/mappedb.nq	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,6 @@
+_: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> .
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D012-2tables2duplicates0nulls/r2rmla.ttl	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,34 @@
+@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:TriplesMapClass;
+
+    rr:subjectMap [
+            rr:template "{fname}_{lname}_{amount}"; 
+            rr:termtype "BlankNode";
+            rr:class ex:IOU; 
+      ];
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:name ]; 
+      rr:objectMap    [ 
+            rr:template "{fname} {lname}";
+            rr:termtype "Literal" 
+      ]
+    ];
+    
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate ex:amount ]; 
+      rr:objectMap    [ 
+            rr:column "amount";
+            rr:termtype "Literal";
+            rr:datatype xsd:float;
+      ]
+    ];
+	.
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D012-2tables2duplicates0nulls/r2rmlb.ttl	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,46 @@
+@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:TriplesMapClass;
+    rr:tableName "IOUs"
+    rr:tableOwner "alex"
+
+    rr:subjectMap [
+            rr:template "{fname}_{lname}"; 
+            rr:termtype "BlankNode";
+            rr:class ex:IOU; 
+      ];
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate foaf:name ]; 
+      rr:objectMap    [ 
+            rr:template "{fname} {lname}";
+            rr:termtype "Literal" 
+      ]
+    ];
+    .
+<TriplesMap2>
+    a rr:TriplesMapClass;
+    rr:tableName "Lives"
+    rr:tableOwner "alex"
+
+    rr:subjectMap [
+            rr:template "{fname}_{lname}"; 
+            rr:termtype "BlankNode";
+            rr:class ex:IOU; 
+      ];
+	
+    rr:predicateObjectMap
+    [ 
+      rr:predicateMap [ rr:predicate ex:city ]; 
+      rr:objectMap    [ 
+            rr:column "city";
+            rr:termtype "Literal" 
+      ]
+    ];
+	.
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D013-1table3columns2rows1nullvalue/create.sql	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,7 @@
+CREATE TABLE Person (
+ID integer,
+Name varchar(50),
+DateOfBirth varchar(50)
+);
+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
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D013-1table3columns2rows1nullvalue/directGraph.nt	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,10 @@
+<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
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/D013-1table3columns2rows1nullvalue/manifest.ttl	Wed Jul 20 19:12:51 2011 +0100
@@ -0,0 +1,21 @@
+@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:output "directGraph.nt" ;
+.