Modify the R2RM
authorBoris Villazon-Terrazas <bvillazon@fi.upm.es>
Tue, 06 Mar 2012 00:07:59 +0100
changeset 64 cc7299a53d0c
parent 63 4a4e97d06560
child 65 84c19dc80dd6
Modify the R2RM
L TC0016 Binary column
D016-1table1primarykey10columns3rowsSQLdatatypes/create.sql
D016-1table1primarykey10columns3rowsSQLdatatypes/directGraph.nt
D016-1table1primarykey10columns3rowsSQLdatatypes/mappede.nq
D016-1table1primarykey10columns3rowsSQLdatatypes/r2rmle.ttl
ts1.zip
--- a/D016-1table1primarykey10columns3rowsSQLdatatypes/create.sql	Mon Mar 05 19:32:23 2012 +0100
+++ b/D016-1table1primarykey10columns3rowsSQLdatatypes/create.sql	Tue Mar 06 00:07:59 2012 +0100
@@ -8,13 +8,13 @@
 "BirthDate" DATE,
 "EntranceDate" TIMESTAMP,
 "PaidInAdvance" BOOLEAN,
-"Photo" VARBINARY(20),
+"Photo" VARBINARY(200),
 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 VARBINARY(20)) );
+VALUES (10,'Monica','Geller','female',80.25,1.65,'1981-10-10','2009-10-10 12:12:22','FALSE',CAST('iVBORw0KGgoAAAANSUhEUgAAAAUAAAAFCAYAAACNbyblAAAAHElEQVQI12P4//8/w38GIAXDIBKE0DHxgljNBAAO9TXL0Y4OHwAAAABJRU5ErkJggg==' as VARBINARY(200)) );
 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 VARBINARY(20)));
+VALUES (11,'Rachel','Green','female',70.22,1.70,'1982-11-12','2008-11-12 09:45:44','TRUE',CAST('iVBORw0KGgoAAAANSUhEUgAAAAUAAAAFCAYAAACNbyblAAAAHElEQVQI12P5//8/w38GIAXDIBKE0DHxgljNBAAO9TXL0Y4OHwAAAABJRU5ErkJggg==' as VARBINARY(200)));
 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 VARBINARY(20)));
+VALUES (12,'Chandler','Bing','male',90.31,1.76,'1978-04-06','2007-03-12 02:13:14','TRUE',CAST('iVBORw0KGgoAAAANSUhEUgAAAAUAAAAFCAYAAACNbyblAAAAHElEQVQI12P5//6/w38GIAXDIBKE0DHxgljNBAAO9TXL0Y4OHwAAAABJRU5ErkJggg==' as VARBINARY(200)));
--- a/D016-1table1primarykey10columns3rowsSQLdatatypes/directGraph.nt	Mon Mar 05 19:32:23 2012 +0100
+++ b/D016-1table1primarykey10columns3rowsSQLdatatypes/directGraph.nt	Tue Mar 06 00:07:59 2012 +0100
@@ -8,7 +8,7 @@
 <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> "iVBORw0KGgoAAAANSUhEUgAAAAUAAAAFCAYAAACNbyblAAAAHElEQVQI12P4//8/w38GIAXDIBKE0DHxgljNBAAO9TXL0Y4OHwAAAABJRU5ErkJggg=="^^<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" .
@@ -19,7 +19,7 @@
 <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> "iVBORw0KGgoAAAANSUhEUgAAAAUAAAAFCAYAAACNbyblAAAAHElEQVQI12P5//8/w38GIAXDIBKE0DHxgljNBAAO9TXL0Y4OHwAAAABJRU5ErkJggg=="^^<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" .
@@ -30,4 +30,4 @@
 <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> "iVBORw0KGgoAAAANSUhEUgAAAAUAAAAFCAYAAACNbyblAAAAHElEQVQI12P5//6/w38GIAXDIBKE0DHxgljNBAAO9TXL0Y4OHwAAAABJRU5ErkJggg=="^^<http://www.w3.org/2001/XMLSchema#base64Binary> .
\ No newline at end of file
--- a/D016-1table1primarykey10columns3rowsSQLdatatypes/mappede.nq	Mon Mar 05 19:32:23 2012 +0100
+++ b/D016-1table1primarykey10columns3rowsSQLdatatypes/mappede.nq	Tue Mar 06 00:07:59 2012 +0100
@@ -1,7 +1,7 @@
 <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/photo> "eILK"^^<http://www.w3.org/2001/XMLSchema#base64Binary> .
+<http://example.com/Patient10> <http://example.com/photo> "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAUAAAAFCAYAAACNbyblAAAAHElEQVQI12P4//8/w38GIAXDIBKE0DHxgljNBAAO9TXL0Y4OHwAAAABJRU5ErkJggg=="^^<http://www.w3.org/2001/XMLSchema#anyURI>
 <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/photo> "utH1"^^<http://www.w3.org/2001/XMLSchema#base64Binary> .
+<http://example.com/Patient11> <http://example.com/photo> "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAUAAAAFCAYAAACNbyblAAAAHElEQVQI12P5//8/w38GIAXDIBKE0DHxgljNBAAO9TXL0Y4OHwAAAABJRU5ErkJggg=="^^<http://www.w3.org/2001/XMLSchema#anyURI>
 <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/photo> "0bfl+w=="^^<http://www.w3.org/2001/XMLSchema#base64Binary> .
+<http://example.com/Patient12> <http://example.com/photo> "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAUAAAAFCAYAAACNbyblAAAAHElEQVQI12P5//6/w38GIAXDIBKE0DHxgljNBAAO9TXL0Y4OHwAAAABJRU5ErkJggg=="^^<http://www.w3.org/2001/XMLSchema#anyURI>
 
--- a/D016-1table1primarykey10columns3rowsSQLdatatypes/r2rmle.ttl	Mon Mar 05 19:32:23 2012 +0100
+++ b/D016-1table1primarykey10columns3rowsSQLdatatypes/r2rmle.ttl	Tue Mar 06 00:07:59 2012 +0100
@@ -22,7 +22,7 @@
     rr:predicateObjectMap
     [ 
       rr:predicate ex:photo;
-      rr:objectMap    [ rr:column "\"Photo\""; rr:datatype xsd:base64Binary ]
+      rr:objectMap [ rr:template "data:image/png;base64,{\"Photo\"}"; ];
     ];
 
     .
Binary file ts1.zip has changed