author | Boris Villazon-Terrazas <bvillazon@fi.upm.es> |
Mon, 05 Mar 2012 19:32:23 +0100 | |
changeset 63 | 4a4e97d06560 |
parent 62 | 6073eaeda218 |
child 64 | cc7299a53d0c |
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> .