- From: Boris Villazon-Terrazas <bvillazon@fi.upm.es>
- Date: Wed, 14 Mar 2012 02:14:12 +0100
- To: Eric Prud'hommeaux <eric@w3.org>
- Cc: public-rdb2rdf-wg@w3.org
- Message-Id: <1F273CA3-20BC-4EE7-BC0F-64B9CE52F40D@fi.upm.es>
Thanks Eric!
I've updated the TCs [1]
Boris
[1] http://www.w3.org/2001/sw/rdb2rdf/test-cases/
On Mar 13, 2012, at 4:44 PM, Eric Prud'hommeaux wrote:
> 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 Wednesday, 14 March 2012 01:14:41 UTC