A few fixes to issues reported by Juan
authorBoris Villazon-Terrazas <bvillazon@fi.upm.es>
Mon, 05 Mar 2012 19:32:23 +0100
changeset 63 4a4e97d06560
parent 62 6073eaeda218
child 64 cc7299a53d0c
A few fixes to issues reported by Juan
D003-1table3columns1row/mappedd.nq
D008-1table1compositeprimarykey3columns1row/r2rmlc.ttl
D010-1table1primarykey3colums3rows/r2rmlc.ttl
D016-1table1primarykey10columns3rowsSQLdatatypes/create.sql
D016-1table1primarykey10columns3rowsSQLdatatypes/mappedc.nq
ts1.zip
--- a/D003-1table3columns1row/mappedd.nq	Wed Feb 29 20:44:12 2012 +0100
+++ b/D003-1table3columns1row/mappedd.nq	Mon Mar 05 19:32:23 2012 +0100
@@ -1,4 +1,4 @@
-<http://example.com/Student10VenusWilliams> <http://xmlns.com/foaf/0.1/firstName> <http://example.com/data/Venus> .
-<http://example.com/Student10VenusWilliams> <http://example.com//lastName> <http://example.com/data/Williams> .
+<http://example.com/Student10VenusWilliams> <http://example.com/firstName> <http://example.com/data/Venus> .
+<http://example.com/Student10VenusWilliams> <http://example.com/lastName> <http://example.com/data/Williams> .
 <http://example.com/Student10VenusWilliams> <http://example.com/id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
 
--- a/D008-1table1compositeprimarykey3columns1row/r2rmlc.ttl	Wed Feb 29 20:44:12 2012 +0100
+++ b/D008-1table1compositeprimarykey3columns1row/r2rmlc.ttl	Mon Mar 05 19:32:23 2012 +0100
@@ -23,7 +23,7 @@
     rr:predicateObjectMap
     [ 
 		rr:predicateMap [ rr:constant ex:id; ];
-		rr:objectMap    [ rr:column "\"ID\"\"; rr:datatype xsd:integer ]
+		rr:objectMap    [ rr:column "\"ID\""; rr:datatype xsd:integer ]
     ];
 
     rr:predicateObjectMap
--- a/D010-1table1primarykey3colums3rows/r2rmlc.ttl	Wed Feb 29 20:44:12 2012 +0100
+++ b/D010-1table1primarykey3colums3rows/r2rmlc.ttl	Mon Mar 05 19:32:23 2012 +0100
@@ -14,6 +14,6 @@
     rr:predicateObjectMap
     [ 
       rr:predicateMap [ rr:constant ex:code ]; 
-      rr:objectMap    [ rr:template "\\{\\{\\{ {ISO 3166} \\}\\}\\}" ]
+      rr:objectMap    [ rr:template "\\{\\{\\{ {\"ISO 3166\"} \\}\\}\\}"; rr:termType rr:Literal; ]
     ]
     .
\ No newline at end of file
--- a/D016-1table1primarykey10columns3rowsSQLdatatypes/create.sql	Wed Feb 29 20:44:12 2012 +0100
+++ b/D016-1table1primarykey10columns3rowsSQLdatatypes/create.sql	Mon Mar 05 19:32:23 2012 +0100
@@ -8,13 +8,13 @@
 "BirthDate" DATE,
 "EntranceDate" TIMESTAMP,
 "PaidInAdvance" BOOLEAN,
-"Photo" BINARY(20),
+"Photo" VARBINARY(20),
 PRIMARY KEY ("ID")
 );
 
 INSERT INTO "Patient" ("ID", "FirstName","LastName","Sex","Weight","Height","BirthDate","EntranceDate","PaidInAdvance","Photo") 
-VALUES (10,'Monica','Geller','female',80.25,1.65,'1981-10-10','2009-10-10 12:12:22','FALSE',CAST('monica' as BINARY(20)) );
+VALUES (10,'Monica','Geller','female',80.25,1.65,'1981-10-10','2009-10-10 12:12:22','FALSE',CAST('monica' as VARBINARY(20)) );
 INSERT INTO "Patient" ("ID", "FirstName","LastName","Sex","Weight","Height","BirthDate","EntranceDate","PaidInAdvance","Photo") 
-VALUES (11,'Rachel','Green','female',70.22,1.70,'1982-11-12','2008-11-12 09:45:44','TRUE',CAST('rachel' as BINARY(20)));
+VALUES (11,'Rachel','Green','female',70.22,1.70,'1982-11-12','2008-11-12 09:45:44','TRUE',CAST('rachel' as VARBINARY(20)));
 INSERT INTO "Patient" ("ID", "FirstName","LastName","Sex","Weight","Height","BirthDate","EntranceDate","PaidInAdvance","Photo") 
-VALUES (12,'Chandler','Bing','male',90.31,1.76,'1978-04-06','2007-03-12 02:13:14','TRUE',CAST('chandler' as BINARY(20)));
+VALUES (12,'Chandler','Bing','male',90.31,1.76,'1978-04-06','2007-03-12 02:13:14','TRUE',CAST('chandler' as VARBINARY(20)));
--- a/D016-1table1primarykey10columns3rowsSQLdatatypes/mappedc.nq	Wed Feb 29 20:44:12 2012 +0100
+++ b/D016-1table1primarykey10columns3rowsSQLdatatypes/mappedc.nq	Mon Mar 05 19:32:23 2012 +0100
@@ -1,10 +1,10 @@
 <http://example.com/Patient10> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
 <http://example.com/Patient10> <http://example.com/birthdate> "1981-10-10"^^<http://www.w3.org/2001/XMLSchema#date> .
-<http://example.com/Patient10> <http://example.com/entrancedate> "2009-10-10 12:12:22"^^<http://www.w3.org/2001/XMLSchema#dateTime> .
+<http://example.com/Patient10> <http://example.com/entrancedate> "2009-10-10T12:12:22"^^<http://www.w3.org/2001/XMLSchema#dateTime> .
 <http://example.com/Patient11> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
 <http://example.com/Patient11> <http://example.com/birthdate> "1982-11-12"^^<http://www.w3.org/2001/XMLSchema#date> .
-<http://example.com/Patient11> <http://example.com/entrancedate> "2008-11-12 09:45:44"^^<http://www.w3.org/2001/XMLSchema#dateTime> .
+<http://example.com/Patient11> <http://example.com/entrancedate> "2008-11-12T09:45:44"^^<http://www.w3.org/2001/XMLSchema#dateTime> .
 <http://example.com/Patient12> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> .
 <http://example.com/Patient12> <http://example.com/birthdate> "1978-04-06"^^<http://www.w3.org/2001/XMLSchema#date> .
-<http://example.com/Patient12> <http://example.com/entrancedate> "2007-03-12 02:13:14"^^<http://www.w3.org/2001/XMLSchema#dateTime> .
+<http://example.com/Patient12> <http://example.com/entrancedate> "2007-03-12T02:13:14"^^<http://www.w3.org/2001/XMLSchema#dateTime> .
 
Binary file ts1.zip has changed