+ non-hierarchy-handling test
authorEric Prud'hommeaux <eric@w3.org>
Wed, 02 Feb 2011 10:47:33 -0500
changeset 314 238ca9b12a84
parent 313 14f369196a72
child 315 e0928b57615b
+ non-hierarchy-handling test
sharedtestdata/directmappingspec/non-hier_tabl.sql
sharedtestdata/directmappingspec/non-hier_tabl.ttl
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/sharedtestdata/directmappingspec/non-hier_tabl.sql	Wed Feb 02 10:47:33 2011 -0500
@@ -0,0 +1,13 @@
+CREATE TABLE Addresses (ID INT PRIMARY KEY, city STRING, state STRING);
+INSERT INTO Addresses (ID, city, state) VALUES (18, "Cambridge", "MA");
+CREATE TABLE People (ID INT PRIMARY KEY, fname STRING, addr INT,
+                     FOREIGN KEY (addr) REFERENCES Addresses(ID));
+INSERT INTO People (ID, fname, addr) VALUES (7, "Bob", 18);
+CREATE TABLE Offices (ID INT PRIMARY KEY,
+                      building INT, ofcNumber STRING,
+                      FOREIGN KEY (ID) REFERENCES Addresses(ID));
+INSERT INTO Offices (ID, building, ofcNumber) VALUES (18, 32, "G528");
+CREATE TABLE ExecutiveOffices (ID INT PRIMARY KEY,
+                               desk STRING,
+                               FOREIGN KEY (ID) REFERENCES Offices(ID));
+INSERT INTO ExecutiveOffices (ID, desk) VALUES (18, "oak");
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/sharedtestdata/directmappingspec/non-hier_tabl.ttl	Wed Feb 02 10:47:33 2011 -0500
@@ -0,0 +1,19 @@
+@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
+<ExecutiveOffices/ID.18#_> a <ExecutiveOffices> .
+<ExecutiveOffices/ID.18#_> <ExecutiveOffices#ID> <Offices/ID.18#_> .
+<ExecutiveOffices/ID.18#_> <ExecutiveOffices#desk> "oak" . 
+
+<Offices/ID.18#_> a <Offices> .
+<Offices/ID.18#_> <Offices#ID> <Addresses/ID.18#_> .
+<Offices/ID.18#_> <Offices#building> 32 .
+<Offices/ID.18#_> <Offices#ofcNumber> "G528" . 
+
+<People/ID.7#_> a <People> .
+<People/ID.7#_> <People#ID> 7 .
+<People/ID.7#_> <People#fname> "Bob" .
+<People/ID.7#_> <People#addr> <Addresses/ID.18#_> .
+
+<Addresses/ID.18#_> a <Addresses> .
+<Addresses/ID.18#_> <Addresses#ID> 18 .
+<Addresses/ID.18#_> <Addresses#city> "Cambridge" .
+<Addresses/ID.18#_> <Addresses#state> "MA" .