~ moving the servlet bits
authorAlexandre Bertails <alexandre@bertails.org>
Sun, 31 Oct 2010 15:56:24 -0400
changeset 239 1885daa02788
parent 238 a5507f0ee9d8
child 240 54f3e70945e0
~ moving the servlet bits
sparqlendpoint/src/main/resources/database.properties
sparqlendpoint/src/main/resources/ddl.txt
sparqlendpoint/src/main/resources/default-sparql-query.txt
sparqlendpoint/src/main/resources/rdb2rdf.properties
sparqlendpoint/src/main/webapp/WEB-INF/web.xml
src/main/resources/database.properties
src/main/resources/ddl.txt
src/main/resources/default-sparql-query.txt
src/main/resources/rdb2rdf.properties
src/main/webapp/WEB-INF/web.xml
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/sparqlendpoint/src/main/resources/database.properties	Sun Oct 31 15:56:24 2010 -0400
@@ -0,0 +1,3 @@
+host = localhost
+user = root
+password = 
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/sparqlendpoint/src/main/resources/ddl.txt	Sun Oct 31 15:56:24 2010 -0400
@@ -0,0 +1,3 @@
+CREATE TABLE Employee (empid INT, PRIMARY KEY (empid), lastName STRING, birthday DATE, manager INT, FOREIGN KEY (manager) REFERENCES Employee(empid));
+CREATE TABLE Tasks (taskid INT, PRIMARY KEY (taskid), name STRING, lead INT, FOREIGN KEY (lead) REFERENCES Employee(empid));
+CREATE TABLE TaskAssignments (id INT PRIMARY KEY, PRIMARY KEY (id), task INT, FOREIGN KEY (task) REFERENCES Tasks(taskid), employee INT, FOREIGN KEY (employee) REFERENCES Employee(empid));
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/sparqlendpoint/src/main/resources/default-sparql-query.txt	Sun Oct 31 15:56:24 2010 -0400
@@ -0,0 +1,17 @@
+PREFIX empP : <http://hr.example/DB/Employee#>
+PREFIX task : <http://hr.example/DB/Tasks#>
+PREFIX tass : <http://hr.example/DB/TaskAssignments#>
+PREFIX xsd : <http://www.w3.org/2001/XMLSchema#>
+SELECT ?name ?bday
+ WHERE { { ?above   tass:employee  ?who .
+           ?above   tass:task      ?atask .
+           ?atask   task:lead      ?taskLead .
+           ?taskLead empP:lastName  ?name }
+         UNION
+         { ?below   tass:task     ?btask .
+           ?btask   task:lead     ?who .
+           ?below   tass:employee ?managed .
+           ?managed empP:lastName  ?name .
+           ?managed empP:birthday  ?bday } 
+         ?who empP:lastName "Smith"^^xsd:string .
+         ?who empP:birthday ?bday }
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/sparqlendpoint/src/main/resources/rdb2rdf.properties	Sun Oct 31 15:56:24 2010 -0400
@@ -0,0 +1,1 @@
+default-stemuri = http://hr.example/DB/
\ No newline at end of file
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/sparqlendpoint/src/main/webapp/WEB-INF/web.xml	Sun Oct 31 15:56:24 2010 -0400
@@ -0,0 +1,10 @@
+<web-app xmlns="http://java.sun.com/xml/ns/javaee" version="2.5">
+  <servlet>
+    <servlet-name>sparqlendpoint</servlet-name>
+    <servlet-class>org.w3.sparql2sql.servlet.SparqlEndpoint</servlet-class>
+  </servlet>
+  <servlet-mapping>
+    <servlet-name>sparqlendpoint</servlet-name>
+    <url-pattern>/sparql/*</url-pattern>
+  </servlet-mapping>
+</web-app>
--- a/src/main/resources/database.properties	Sun Oct 31 15:17:31 2010 -0400
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-host = localhost
-user = root
-password = 
--- a/src/main/resources/ddl.txt	Sun Oct 31 15:17:31 2010 -0400
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,3 +0,0 @@
-CREATE TABLE Employee (empid INT, PRIMARY KEY (empid), lastName STRING, birthday DATE, manager INT, FOREIGN KEY (manager) REFERENCES Employee(empid));
-CREATE TABLE Tasks (taskid INT, PRIMARY KEY (taskid), name STRING, lead INT, FOREIGN KEY (lead) REFERENCES Employee(empid));
-CREATE TABLE TaskAssignments (id INT PRIMARY KEY, PRIMARY KEY (id), task INT, FOREIGN KEY (task) REFERENCES Tasks(taskid), employee INT, FOREIGN KEY (employee) REFERENCES Employee(empid));
--- a/src/main/resources/default-sparql-query.txt	Sun Oct 31 15:17:31 2010 -0400
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,17 +0,0 @@
-PREFIX empP : <http://hr.example/DB/Employee#>
-PREFIX task : <http://hr.example/DB/Tasks#>
-PREFIX tass : <http://hr.example/DB/TaskAssignments#>
-PREFIX xsd : <http://www.w3.org/2001/XMLSchema#>
-SELECT ?name ?bday
- WHERE { { ?above   tass:employee  ?who .
-           ?above   tass:task      ?atask .
-           ?atask   task:lead      ?taskLead .
-           ?taskLead empP:lastName  ?name }
-         UNION
-         { ?below   tass:task     ?btask .
-           ?btask   task:lead     ?who .
-           ?below   tass:employee ?managed .
-           ?managed empP:lastName  ?name .
-           ?managed empP:birthday  ?bday } 
-         ?who empP:lastName "Smith"^^xsd:string .
-         ?who empP:birthday ?bday }
--- a/src/main/resources/rdb2rdf.properties	Sun Oct 31 15:17:31 2010 -0400
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,1 +0,0 @@
-default-stemuri = http://hr.example/DB/
\ No newline at end of file
--- a/src/main/webapp/WEB-INF/web.xml	Sun Oct 31 15:17:31 2010 -0400
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,10 +0,0 @@
-<web-app xmlns="http://java.sun.com/xml/ns/javaee" version="2.5">
-  <servlet>
-    <servlet-name>sparqlendpoint</servlet-name>
-    <servlet-class>org.w3.sparql2sql.servlet.SparqlEndpoint</servlet-class>
-  </servlet>
-  <servlet-mapping>
-    <servlet-name>sparqlendpoint</servlet-name>
-    <url-pattern>/sparql/*</url-pattern>
-  </servlet-mapping>
-</web-app>