Mercurial > hg > rdb2rdf-tests / changeset
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset
Minor thing
authorBoris Villazon-Terrazas <bvillazon@fi.upm.es>
Thu, 22 Mar 2012 13:32:53 +0100
changeset 78 aa95d07e0144
parent 77 8b880c641cd5
child 79 4724234ce060
Minor thing
ref-all-nulls/create.sql file | annotate | diff | comparison | revisions
ref-all-nulls/directGraph.ttl file | annotate | diff | comparison | revisions
ref-no-pk/create.sql file | annotate | diff | comparison | revisions
ref-no-pk/directGraph.ttl file | annotate | diff | comparison | revisions
ref-not-pk/create.sql file | annotate | diff | comparison | revisions
ref-not-pk/directGraph.ttl file | annotate | diff | comparison | revisions
ref-some-nulls/create.sql file | annotate | diff | comparison | revisions
ref-some-nulls/directGraph.ttl file | annotate | diff | comparison | revisions
spec-ref-no-pk/create.sql file | annotate | diff | comparison | revisions
spec-ref-no-pk/directGraph.ttl file | annotate | diff | comparison | revisions 
--- a/ref-all-nulls/create.sql	Thu Mar 22 13:30:20 2012 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,33 +0,0 @@
-CREATE TABLE "Target" (
-	"PK" INT,
-	PRIMARY KEY("PK"),
-	"key1attr1" CHAR(5),
-	"key1attr2" CHAR(5),
-	UNIQUE ("key1attr1", "key1attr2"),
-	"key2attr1" CHAR(5),
-	"key2attr2" CHAR(5),
-	UNIQUE ("key2attr2", "key2attr1")
-);
-
-CREATE TABLE "Source" (
-	"ID" INT,
-	PRIMARY KEY("ID"),
-	"attrA" CHAR(5),
-	"attrB" CHAR(5),
-	FOREIGN KEY ("attrA", "attrB") REFERENCES "Target"("key2attr2", "key2attr1")
-);
-
-INSERT INTO "Target" ("PK", "key1attr1", "key1attr2", "key2attr1", "key2attr2")
-              VALUES (1010, 'K1A11'    , 'K1A21'    , 'K2A11'    , 'K2A21'    );
-INSERT INTO "Target" ("PK", "key1attr1", "key1attr2", "key2attr1", "key2attr2")
-              VALUES (1011, 'K1A12'    , 'K1A22'    , NULL       , 'K2A22'    );
-INSERT INTO "Target" ("PK", "key1attr1", "key1attr2", "key2attr1", "key2attr2")
-              VALUES (1012, 'K1A13'    , 'K1A23'    , NULL       , NULL       );
-
-INSERT INTO "Source" ("ID", "attrA", "attrB")
-              VALUES (1100, 'K2A21', 'K2A11');
-INSERT INTO "Source" ("ID", "attrA", "attrB")
-              VALUES (1101, 'K2A22', NULL   );
-INSERT INTO "Source" ("ID", "attrA", "attrB")
-              VALUES (1102, NULL   , NULL   );
-
--- a/ref-all-nulls/directGraph.ttl	Thu Mar 22 13:30:20 2012 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,35 +0,0 @@
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-<Target/PK-1010> a <Target> .
-<Target/PK-1010> <Target#PK> 1010 .
-<Target/PK-1010> <Target#key1attr1> "K1A11" .
-<Target/PK-1010> <Target#key1attr2> "K1A21" .
-<Target/PK-1010> <Target#key2attr1> "K2A11" .
-<Target/PK-1010> <Target#key2attr2> "K2A21" .
-
-<Target/PK-1011> a <Target> .
-<Target/PK-1011> <Target#PK> 1011 .
-<Target/PK-1011> <Target#key1attr1> "K1A12" .
-<Target/PK-1011> <Target#key1attr2> "K1A22" .
-<Target/PK-1011> <Target#key2attr2> "K2A22" .
-
-<Target/PK-1012> a <Target> .
-<Target/PK-1012> <Target#PK> 1012 .
-<Target/PK-1012> <Target#key1attr1> "K1A13" .
-<Target/PK-1012> <Target#key1attr2> "K1A23" .
-
-<Source/ID-1100> a <Source> .
-<Source/ID-1100> <Source#ID> 1100 .
-<Source/ID-1100> <Source#attrA> "K2A21" .
-<Source/ID-1100> <Source#attrB> "K2A11" .
-<Source/ID-1100> <Source#ref-attrA.attrB> <Target/PK-1010> .
-
-<Source/ID-1101> a <Source> .
-<Source/ID-1101> <Source#ID> 1101 .
-<Source/ID-1101> <Source#attrA> "K2A22" .
-<Source/ID-1101> <Source#ref-attrA.attrB> <Target/PK-1011> .
-
-<Source/ID-1102> a <Source> .
-<Source/ID-1102> <Source#ID> 1102 .
-<Source/ID-1102> <Source#ref-attrA.attrB> <Target/PK-1012> .
-
--- a/ref-no-pk/create.sql	Thu Mar 22 13:30:20 2012 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,24 +0,0 @@
-CREATE TABLE "Target" (
-	"litattr1" INT,
-	-- PRIMARY KEY("PK"),
-	"key1attr1" CHAR(4),
-	"key1attr2" CHAR(4),
-	UNIQUE ("key1attr1", "key1attr2"),
-	"key2attr1" CHAR(4),
-	"key2attr2" CHAR(4),
-	UNIQUE ("key2attr2", "key2attr1")
-);
-
-CREATE TABLE "Source" (
-	"ID" INT,
-	PRIMARY KEY("ID"),
-	"attrA" CHAR(4),
-	"attrB" CHAR(4),
-	FOREIGN KEY ("attrA", "attrB") REFERENCES "Target"("key2attr2", "key2attr1")
-);
-
-INSERT INTO "Target" ("litattr1", "key1attr1", "key1attr2", "key2attr1", "key2attr2")
-              VALUES (1010      , 'K1A1'     , 'K1A2'     , 'K2A1'     , 'K2A2');
-
-INSERT INTO "Source" ("ID", "attrA", "attrB")
-              VALUES (1100, 'K2A2' , 'K2A1' );
--- a/ref-no-pk/directGraph.ttl	Thu Mar 22 13:30:20 2012 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,15 +0,0 @@
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-_:a a <Target> .
-_:a <Target#litattr1> 1010 .
-_:a <Target#key1attr1> "K1A1" .
-_:a <Target#key1attr2> "K1A2" .
-_:a <Target#key2attr1> "K2A1" .
-_:a <Target#key2attr2> "K2A2" .
-
-<Source/ID-1100> a <Source> .
-<Source/ID-1100> <Source#ID> 1100 .
-<Source/ID-1100> <Source#attrA> "K2A2" .
-<Source/ID-1100> <Source#attrB> "K2A1" .
-<Source/ID-1100> <Source#ref-attrA.attrB> _:a .
-
--- a/ref-not-pk/create.sql	Thu Mar 22 13:30:20 2012 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,24 +0,0 @@
-CREATE TABLE "Target" (
-	"PK" INT,
-	PRIMARY KEY("PK"),
-	"key1attr1" CHAR(4),
-	"key1attr2" CHAR(4),
-	UNIQUE ("key1attr1", "key1attr2"),
-	"key2attr1" CHAR(4),
-	"key2attr2" CHAR(4),
-	UNIQUE ("key2attr2", "key2attr1")
-);
-
-CREATE TABLE "Source" (
-	"ID" INT,
-	PRIMARY KEY("ID"),
-	"attrA" CHAR(4),
-	"attrB" CHAR(4),
-	FOREIGN KEY ("attrA", "attrB") REFERENCES "Target"("key2attr2", "key2attr1")
-);
-
-INSERT INTO "Target" ("PK", "key1attr1", "key1attr2", "key2attr1", "key2attr2")
-              VALUES (1010, 'K1A1'     , 'K1A2'     , 'K2A1'     , 'K2A2'     );
-
-INSERT INTO "Source" ("ID", "attrA", "attrB")
-              VALUES (1100, 'K2A2' , 'K2A1' );
--- a/ref-not-pk/directGraph.ttl	Thu Mar 22 13:30:20 2012 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,15 +0,0 @@
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-<Target/PK-1010> a <Target> .
-<Target/PK-1010> <Target#PK> 1010 .
-<Target/PK-1010> <Target#key1attr1> "K1A1" .
-<Target/PK-1010> <Target#key1attr2> "K1A2" .
-<Target/PK-1010> <Target#key2attr1> "K2A1" .
-<Target/PK-1010> <Target#key2attr2> "K2A2" .
-
-<Source/ID-1100> a <Source> .
-<Source/ID-1100> <Source#ID> 1100 .
-<Source/ID-1100> <Source#attrA> "K2A2" .
-<Source/ID-1100> <Source#attrB> "K2A1" .
-<Source/ID-1100> <Source#ref-attrA.attrB> <Target/PK-1010> .
-
--- a/ref-some-nulls/create.sql	Thu Mar 22 13:30:20 2012 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,29 +0,0 @@
-CREATE TABLE "Target" (
-	"PK" INT,
-	PRIMARY KEY("PK"),
-	"key1attr1" CHAR(5),
-	"key1attr2" CHAR(5),
-	UNIQUE ("key1attr1", "key1attr2"),
-	"key2attr1" CHAR(5),
-	"key2attr2" CHAR(5),
-	UNIQUE ("key2attr2", "key2attr1")
-);
-
-CREATE TABLE "Source" (
-	"ID" INT,
-	PRIMARY KEY("ID"),
-	"attrA" CHAR(5),
-	"attrB" CHAR(5),
-	FOREIGN KEY ("attrA", "attrB") REFERENCES "Target"("key2attr2", "key2attr1")
-);
-
-INSERT INTO "Target" ("PK", "key1attr1", "key1attr2", "key2attr1", "key2attr2")
-              VALUES (1010, 'K1A11'    , 'K1A21'    , 'K2A11'    , 'K2A21'    );
-INSERT INTO "Target" ("PK", "key1attr1", "key1attr2", "key2attr1", "key2attr2")
-              VALUES (1011, 'K1A12'    , 'K1A22'    , NULL       , 'K2A22'    );
-
-INSERT INTO "Source" ("ID", "attrA", "attrB")
-              VALUES (1100, 'K2A21', 'K2A11');
-INSERT INTO "Source" ("ID", "attrA", "attrB")
-              VALUES (1101, 'K2A22', NULL   );
-
--- a/ref-some-nulls/directGraph.ttl	Thu Mar 22 13:30:20 2012 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,26 +0,0 @@
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-<Target/PK-1010> a <Target> .
-<Target/PK-1010> <Target#PK> 1010 .
-<Target/PK-1010> <Target#key1attr1> "K1A11" .
-<Target/PK-1010> <Target#key1attr2> "K1A21" .
-<Target/PK-1010> <Target#key2attr1> "K2A11" .
-<Target/PK-1010> <Target#key2attr2> "K2A21" .
-
-<Target/PK-1011> a <Target> .
-<Target/PK-1011> <Target#PK> 1011 .
-<Target/PK-1011> <Target#key1attr1> "K1A12" .
-<Target/PK-1011> <Target#key1attr2> "K1A22" .
-<Target/PK-1011> <Target#key2attr2> "K2A22" .
-
-<Source/ID-1100> a <Source> .
-<Source/ID-1100> <Source#ID> 1100 .
-<Source/ID-1100> <Source#attrA> "K2A21" .
-<Source/ID-1100> <Source#attrB> "K2A11" .
-<Source/ID-1100> <Source#ref-attrA.attrB> <Target/PK-1010> .
-
-<Source/ID-1101> a <Source> .
-<Source/ID-1101> <Source#ID> 1101 .
-<Source/ID-1101> <Source#attrA> "K2A22" .
-<Source/ID-1101> <Source#ref-attrA.attrB> <Target/PK-1011> .
-
--- a/spec-ref-no-pk/create.sql	Thu Mar 22 13:30:20 2012 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,67 +0,0 @@
-CREATE TABLE "Addresses" (
-	"ID" INT,
-	PRIMARY KEY("ID"),
-	"city" VARCHAR(10),
-	"state" CHAR(2)
-);
-
-CREATE TABLE "Department" (
-	"ID" INT,
-	PRIMARY KEY("ID"),
-	"name" VARCHAR(10),
-	"city" VARCHAR(10),
-	UNIQUE ("name", "city"),
-	"manager" INT,
-	FOREIGN KEY ("manager") REFERENCES "People"("ID")
-);
-
-CREATE TABLE "People" (
-	"ID" INT,
-	PRIMARY KEY("ID"),
-	"fname" VARCHAR(10),
-	"addr" INT,
-	FOREIGN KEY ("addr") REFERENCES "Addresses"("ID"),
-	"deptName" VARCHAR(10),
-	"deptCity" VARCHAR(10),
-	FOREIGN KEY ("deptName", "deptCity") REFERENCES "Department"("name", "city")
-);
-
-INSERT INTO "Addresses" ("ID", "city",      "state")
-                 VALUES (18,   'Cambridge', 'MA');
-
-INSERT INTO "People" ("ID", "fname", "addr", "deptName", "deptCity" )
-              VALUES (8,    'Sue',   NULL,   NULL,       NULL);
-
-INSERT INTO "Department" ("ID", "name",       "city",      "manager")
-                  VALUES (23,   'accounting', 'Cambridge', 8);
-
-INSERT INTO "People" ("ID", "fname", "addr", "deptName",   "deptCity" )
-              VALUES (7,    'Bob',   18,     'accounting', 'Cambridge');
-
-CREATE TABLE "Projects" (
-	"lead" INT,
-	FOREIGN KEY ("lead") REFERENCES "People"("ID"),
-	"name" VARCHAR(50), 
-	UNIQUE ("lead", "name"), 
-	"deptName" VARCHAR(50), 
-	"deptCity" VARCHAR(50),
-	UNIQUE ("name", "deptName", "deptCity"),
-	FOREIGN KEY ("deptName", "deptCity") REFERENCES "Department"("name", "city")
-);
-CREATE TABLE "TaskAssignments" (
-	"worker" INT,
-	FOREIGN KEY ("worker") REFERENCES "People"("ID"),
-	"project" VARCHAR(50), 
-	PRIMARY KEY ("worker", "project"), 
-	"deptName" VARCHAR(50), 
-	"deptCity" VARCHAR(50),
-	FOREIGN KEY ("worker") REFERENCES "People"("ID"),
-	FOREIGN KEY ("project", "deptName", "deptCity") REFERENCES "Projects"("name", "deptName", "deptCity"),
-	FOREIGN KEY ("deptName", "deptCity") REFERENCES "Department"("name", "city")
-);
-INSERT INTO  "Projects" ("lead", "name",          "deptName",   "deptCity" )
-                 VALUES (8,      'pencil survey', 'accounting', 'Cambridge');
-INSERT INTO  "Projects" ("lead", "name",          "deptName",   "deptCity" )
-                 VALUES (8,      'eraser survey', 'accounting', 'Cambridge');
-INSERT INTO "TaskAssignments" ("worker", "project",       "deptName",   "deptCity" )
-                       VALUES (7,        'pencil survey', 'accounting', 'Cambridge');
--- a/spec-ref-no-pk/directGraph.ttl	Thu Mar 22 13:30:20 2012 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,50 +0,0 @@
-@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
-
-<People/ID-7> a <People> .
-<People/ID-7> <People#ID> 7 .
-<People/ID-7> <People#fname> "Bob" .
-<People/ID-7> <People#addr> 18 .
-<People/ID-7> <People#ref-addr> <Addresses/ID-18> .
-<People/ID-7> <People#deptName> "accounting" .
-<People/ID-7> <People#deptCity> "Cambridge" .
-<People/ID-7> <People#ref-deptName.deptCity> <Department/ID-23> .
-<People/ID-8> a <People> .
-<People/ID-8> <People#ID> 8 .
-<People/ID-8> <People#fname> "Sue" .
-
-<Addresses/ID-18> a <Addresses> .
-<Addresses/ID-18> <Addresses#ID> 18 .
-<Addresses/ID-18> <Addresses#city> "Cambridge" .
-<Addresses/ID-18> <Addresses#state> "MA" .
-
-<Department/ID-23> a <Department> .
-<Department/ID-23> <Department#ID> 23 .
-<Department/ID-23> <Department#name> "accounting" .
-<Department/ID-23> <Department#city> "Cambridge" .
-<Department/ID-23> <Department#manager> 8; .
-<Department/ID-23> <Department#ref-manager> <People/ID-8> .
-
-_:c a <Projects> .
-_:c <Projects#lead> 8 .
-_:c <Projects#ref-lead> <People/ID-8> .
-_:c <Projects#name> "pencil survey" .
-_:c <Projects#deptName> "accounting" .
-_:c <Projects#deptCity> "Cambridge" .
-_:c <Projects#ref-deptName.deptCity> <Department/ID-23> .
-
-_:d a <Projects> .
-_:d <Projects#lead> 8 .
-_:d <Projects#ref-lead> <People/ID-8> .
-_:d <Projects#name> "eraser survey" .
-_:d <Projects#deptName> "accounting" .
-_:d <Projects#deptCity> "Cambridge" .
-_:d <Projects#ref-deptName.deptCity> <Department/ID-23> .
-
-<TaskAssignments/worker-7.project-pencil%20survey> a <TaskAssignments> .
-<TaskAssignments/worker-7.project-pencil%20survey> <TaskAssignments#worker> 7 .
-<TaskAssignments/worker-7.project-pencil%20survey> <TaskAssignments#ref-worker> <People/ID-7> .
-<TaskAssignments/worker-7.project-pencil%20survey> <TaskAssignments#project> "pencil survey" .
-<TaskAssignments/worker-7.project-pencil%20survey> <TaskAssignments#deptName> "accounting" .
-<TaskAssignments/worker-7.project-pencil%20survey> <TaskAssignments#deptCity> "Cambridge" .
-<TaskAssignments/worker-7.project-pencil%20survey> <TaskAssignments#ref-deptName.deptCity> <Department/ID-23> .
-<TaskAssignments/worker-7.project-pencil%20survey> <TaskAssignments#ref-project.deptName.deptCity> _:c .
\ No newline at end of file
rdb2rdf-tests

Hosted by W3C Systems Team, please report bugs to sysreq@w3.org