- From: Eric Prud'hommeaux <eric@w3.org>
- Date: Tue, 13 Mar 2012 11:44:35 -0400
- To: public-rdb2rdf-wg@w3.org
With this patches, I can pass all the DM tests. Many of these changes
are name changes (e.g. matching case in the create.sql). Also, to
enable graph equivalence, I changed the reference graphs to canonical
lexical forms (e.g. for xsd:double). These directMapping.nt files
parse as Turtle.
diff -r 3384c8fd0baa D002-1table2columns1row/directGraph.nt
--- a/D002-1table2columns1row/directGraph.nt Tue Feb 28 20:14:35 2012 +0100
+++ b/D002-1table2columns1row/directGraph.nt Tue Mar 13 11:39:51 2012 -0400
@@ -1,3 +1,3 @@
_:a <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-_:a <Student#id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-_:a <Student#name> "Venus" .
+_:a <Student#ID> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+_:a <Student#Name> "Venus" .
diff -r 3384c8fd0baa D003-1table3columns1row/directGraph.nt
--- a/D003-1table3columns1row/directGraph.nt Tue Feb 28 20:14:35 2012 +0100
+++ b/D003-1table3columns1row/directGraph.nt Tue Mar 13 11:39:51 2012 -0400
@@ -1,4 +1,4 @@
_:a <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-_:a <Student#ID> "10"<http://www.w3.org/2001/XMLSchema#integer> .
+_:a <Student#ID> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
_:a <Student#FirstName> "Venus" .
_:a <Student#LastName> "Williams" .
diff -r 3384c8fd0baa D005-1table3columns3rows2duplicates/directGraph.nt
--- a/D005-1table3columns3rows2duplicates/directGraph.nt Tue Feb 28 20:14:35 2012 +0100
+++ b/D005-1table3columns3rows2duplicates/directGraph.nt Tue Mar 13 11:39:51 2012 -0400
@@ -1,15 +1,15 @@
_:a <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <IOUs> .
_:a <IOUs#fname> "Bob" .
_:a <IOUs#lname> "Smith" .
-_:a <IOUs#amount> "30"^^<http://www.w3.org/2001/XMLSchema#float> .
+_:a <IOUs#amount> "3E1"^^<http://www.w3.org/2001/XMLSchema#double> .
_:b <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <IOUs> .
_:b <IOUs#fname> "Sue" .
_:b <IOUs#lname> "Jones" .
-_:b <IOUs#amount> "20"^^<http://www.w3.org/2001/XMLSchema#float> .
+_:b <IOUs#amount> "2E1"^^<http://www.w3.org/2001/XMLSchema#double> .
_:c <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <IOUs> .
_:c <IOUs#fname> "Bob" .
_:c <IOUs#lname> "Smith" .
-_:c <IOUs#amount> "30"^^<http://www.w3.org/2001/XMLSchema#float> .
+_:c <IOUs#amount> "3E1"^^<http://www.w3.org/2001/XMLSchema#double> .
diff -r 3384c8fd0baa D012-2tables2duplicates0nulls/directGraph.nt
--- a/D012-2tables2duplicates0nulls/directGraph.nt Tue Feb 28 20:14:35 2012 +0100
+++ b/D012-2tables2duplicates0nulls/directGraph.nt Tue Mar 13 11:39:51 2012 -0400
@@ -1,15 +1,15 @@
_:a <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <IOUs> .
_:a <IOUs#fname> "Bob" .
_:a <IOUs#lname> "Smith" .
-_:a <IOUs#amount> "30.0"^^<http://www.w3.org/2001/XMLSchema#double> .
+_:a <IOUs#amount> "3E1"^^<http://www.w3.org/2001/XMLSchema#double> .
_:b <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <IOUs> .
_:b <IOUs#fname> "Sue" .
_:b <IOUs#lname> "Jones" .
-_:b <IOUs#amount> "20.0"^^<http://www.w3.org/2001/XMLSchema#double> .
+_:b <IOUs#amount> "2E1"^^<http://www.w3.org/2001/XMLSchema#double> .
_:c <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <IOUs> .
_:c <IOUs#fname> "Bob" .
_:c <IOUs#lname> "Smith" .
-_:c <IOUs#amount> "30.0"^^<http://www.w3.org/2001/XMLSchema#double> .
+_:c <IOUs#amount> "3E1"^^<http://www.w3.org/2001/XMLSchema#double> .
_:d <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Lives> .
_:d <Lives#fname> "Bob" .
_:d <Lives#lname> "Smith" .
diff -r 3384c8fd0baa D014-3tables1primarykey1foreignkey/directGraph.nt
--- a/D014-3tables1primarykey1foreignkey/directGraph.nt Tue Feb 28 20:14:35 2012 +0100
+++ b/D014-3tables1primarykey1foreignkey/directGraph.nt Tue Mar 13 11:39:51 2012 -0400
@@ -13,9 +13,9 @@
_:b <LIKES#id> "7369"^^<http://www.w3.org/2001/XMLSchema#integer> .
_:b <LIKES#likeType> "Watching" .
_:b <LIKES#likedObj> "Basketball" .
-<DEPT/deptno-10> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <DEPT> .
-<DEPT/deptno-10> <DEPT#deptno> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-<DEPT/deptno-10> <DEPT#dname> "APPSERVER" .
-<DEPT/deptno-10> <DEPT#loc> "NEW YORK" .
+_:c <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <DEPT> .
+_:c <DEPT#deptno> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+_:c <DEPT#dname> "APPSERVER" .
+_:c <DEPT#loc> "NEW YORK" .
diff -r 3384c8fd0baa D016-1table1primarykey10columns3rowsSQLdatatypes/create.sql
--- a/D016-1table1primarykey10columns3rowsSQLdatatypes/create.sql Tue Feb 28 20:14:35 2012 +0100
+++ b/D016-1table1primarykey10columns3rowsSQLdatatypes/create.sql Tue Mar 13 11:39:51 2012 -0400
@@ -13,8 +13,8 @@
);
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 BINARY(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 BINARY(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 BINARY(20)));
diff -r 3384c8fd0baa D016-1table1primarykey10columns3rowsSQLdatatypes/directGraph.nt
--- a/D016-1table1primarykey10columns3rowsSQLdatatypes/directGraph.nt Tue Feb 28 20:14:35 2012 +0100
+++ b/D016-1table1primarykey10columns3rowsSQLdatatypes/directGraph.nt Tue Mar 13 11:39:51 2012 -0400
@@ -3,31 +3,31 @@
<Patient/ID-10> <Patient#FirstName> "Monica" .
<Patient/ID-10> <Patient#LastName> "Geller" .
<Patient/ID-10> <Patient#Sex> "female" .
-<Patient/ID-10> <Patient#Weight> "80.25"^^<http://www.w3.org/2001/XMLSchema#double> .
-<Patient/ID-10> <Patient#Height> "1.65"^^<http://www.w3.org/2001/XMLSchema#double> .
+<Patient/ID-10> <Patient#Weight> "8.025E1"^^<http://www.w3.org/2001/XMLSchema#double> .
+<Patient/ID-10> <Patient#Height> "1.65E0"^^<http://www.w3.org/2001/XMLSchema#double> .
<Patient/ID-10> <Patient#BirthDate> "1981-10-10"^^<http://www.w3.org/2001/XMLSchema#date> .
<Patient/ID-10> <Patient#EntranceDate> "2009-10-10 12:12:22"^^<http://www.w3.org/2001/XMLSchema#dateTime> .
<Patient/ID-10> <Patient#PaidInAdvance> "false"^^<http://www.w3.org/2001/XMLSchema#boolean> .
-<Patient/ID-10> <Patient#Photo> "eILK"^^<http://www.w3.org/2001/XMLSchema#base64Binary> .
+<Patient/ID-10> <Patient#Photo> "bW9uaWNh"^^<http://www.w3.org/2001/XMLSchema#base64Binary> .
<Patient/ID-11> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Patient> .
<Patient/ID-11> <Patient#ID> "11"^^<http://www.w3.org/2001/XMLSchema#integer> .
<Patient/ID-11> <Patient#FirstName> "Rachel" .
<Patient/ID-11> <Patient#LastName> "Green" .
<Patient/ID-11> <Patient#Sex> "female" .
-<Patient/ID-11> <Patient#Weight> "70.22"^^<http://www.w3.org/2001/XMLSchema#double> .
-<Patient/ID-11> <Patient#Height> "1.7"^^<http://www.w3.org/2001/XMLSchema#double> .
+<Patient/ID-11> <Patient#Weight> "7.022E1"^^<http://www.w3.org/2001/XMLSchema#double> .
+<Patient/ID-11> <Patient#Height> "1.7E0"^^<http://www.w3.org/2001/XMLSchema#double> .
<Patient/ID-11> <Patient#BirthDate> "1982-11-12"^^<http://www.w3.org/2001/XMLSchema#date> .
<Patient/ID-11> <Patient#EntranceDate> "2008-11-12 09:45:44"^^<http://www.w3.org/2001/XMLSchema#dateTime> .
<Patient/ID-11> <Patient#PaidInAdvance> "true"^^<http://www.w3.org/2001/XMLSchema#boolean> .
-<Patient/ID-11> <Patient#Photo> "utH1"^^<http://www.w3.org/2001/XMLSchema#base64Binary> .
+<Patient/ID-11> <Patient#Photo> "cmFjaGVs"^^<http://www.w3.org/2001/XMLSchema#base64Binary> .
<Patient/ID-12> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Patient> .
<Patient/ID-12> <Patient#ID> "12"^^<http://www.w3.org/2001/XMLSchema#integer> .
<Patient/ID-12> <Patient#FirstName> "Chandler" .
<Patient/ID-12> <Patient#LastName> "Bing" .
<Patient/ID-12> <Patient#Sex> "male" .
-<Patient/ID-12> <Patient#Weight> "90.31"^^<http://www.w3.org/2001/XMLSchema#double> .
-<Patient/ID-12> <Patient#Height> "1.76"^^<http://www.w3.org/2001/XMLSchema#double> .
+<Patient/ID-12> <Patient#Weight> "9.031E1"^^<http://www.w3.org/2001/XMLSchema#double> .
+<Patient/ID-12> <Patient#Height> "1.76E0"^^<http://www.w3.org/2001/XMLSchema#double> .
<Patient/ID-12> <Patient#BirthDate> "1978-04-06"^^<http://www.w3.org/2001/XMLSchema#date> .
<Patient/ID-12> <Patient#EntranceDate> "2007-03-12 02:13:14"^^<http://www.w3.org/2001/XMLSchema#dateTime> .
<Patient/ID-12> <Patient#PaidInAdvance> "true"^^<http://www.w3.org/2001/XMLSchema#boolean> .
-<Patient/ID-12> <Patient#Photo> "0bfl+w=="^^<http://www.w3.org/2001/XMLSchema#base64Binary> .
\ No newline at end of file
+<Patient/ID-12> <Patient#Photo> "Y2hhbmRsZXI="^^<http://www.w3.org/2001/XMLSchema#base64Binary> .
\ No newline at end of file
diff -r 3384c8fd0baa D018-1table1primarykey2columns3rows/create.sql
--- a/D018-1table1primarykey2columns3rows/create.sql Tue Feb 28 20:14:35 2012 +0100
+++ b/D018-1table1primarykey2columns3rows/create.sql Tue Mar 13 11:39:51 2012 -0400
@@ -2,6 +2,6 @@
"ID" INTEGER,
"Name" CHAR(15)
);
-INSERT INTO "Student" ("ID","Name") VALUES (10,'Venus');
-INSERT INTO "Student" ("ID","Name") VALUES (20,'Fernando');
-INSERT INTO "Student" ("ID","Name") VALUES (30,'David');
+INSERT INTO "Student" ("ID","Name") VALUES (10,'Venus ');
+INSERT INTO "Student" ("ID","Name") VALUES (20,'Fernando ');
+INSERT INTO "Student" ("ID","Name") VALUES (30,'David ');
diff -r 3384c8fd0baa D018-1table1primarykey2columns3rows/directGraph.nt
--- a/D018-1table1primarykey2columns3rows/directGraph.nt Tue Feb 28 20:14:35 2012 +0100
+++ b/D018-1table1primarykey2columns3rows/directGraph.nt Tue Mar 13 11:39:51 2012 -0400
@@ -1,9 +1,9 @@
_:a <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-_:a <Student#id> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
-_:a <Student#name> "Venus " .
-_:a <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-_:a <Student#id> "20"^^<http://www.w3.org/2001/XMLSchema#integer> .
-_:a <Student#name> "Fernando " .
-_:a <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
-_:a <Student#id> "30"^^<http://www.w3.org/2001/XMLSchema#integer> .
-_:a <Student#name> "David " .
+_:a <Student#ID> "10"^^<http://www.w3.org/2001/XMLSchema#integer> .
+_:a <Student#Name> "Venus " .
+_:b <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
+_:b <Student#ID> "20"^^<http://www.w3.org/2001/XMLSchema#integer> .
+_:b <Student#Name> "Fernando " .
+_:c <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <Student> .
+_:c <Student#ID> "30"^^<http://www.w3.org/2001/XMLSchema#integer> .
+_:c <Student#Name> "David " .
--
-ericP
Received on Tuesday, 13 March 2012 15:45:14 UTC