author | Boris Villazon-Terrazas <bvillazon@fi.upm.es> |
Tue, 06 Mar 2012 00:07:59 +0100 | |
changeset 64 | cc7299a53d0c |
parent 63 | 4a4e97d06560 |
child 65 | 84c19dc80dd6 |
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\"}"; ]; ]; .