o Discovering and storing jobs in addition to the build.

2 files changed, 22 insertions, 5 deletions

diff --git a/src/main/resources/ddl-jenkins.sql b/src/main/resources/ddl-jenkins.sql
index df98185..70db7f9 100755
--- a/src/main/resources/ddl-jenkins.sql
+++ b/src/main/resources/ddl-jenkins.sql
@@ -1,6 +1,7 @@
 BEGIN;
 
 DROP TABLE IF EXISTS jenkins_build;
+DROP TABLE IF EXISTS jenkins_job;
 DROP TABLE IF EXISTS jenkins_server;
 
 CREATE TABLE jenkins_server (
@@ -12,12 +13,26 @@ CREATE TABLE jenkins_server (
   CONSTRAINT uq_jenkins_server__url UNIQUE (url)
 );
 
-CREATE TABLE jenkins_build (
+CREATE TABLE jenkins_job (
   uuid         CHAR(36)      NOT NULL,
   created_date TIMESTAMP     NOT NULL,
 
   server       CHAR(36)      NOT NULL,
 
+  url          VARCHAR(1000) NOT NULL,
+  display_name VARCHAR(100),
+
+  CONSTRAINT pk_jenkins_job PRIMARY KEY (UUID),
+  CONSTRAINT fk_jenkins_job__server FOREIGN KEY (server) REFERENCES jenkins_server (uuid),
+  CONSTRAINT uq_jenkins_job__url UNIQUE (url)
+);
+
+CREATE TABLE jenkins_build (
+  uuid         CHAR(36)      NOT NULL,
+  created_date TIMESTAMP     NOT NULL,
+
+  job          CHAR(36)      NOT NULL,
+
   entry_id     VARCHAR(1000) NOT NULL,
   url          VARCHAR(1000) NOT NULL,
   result       VARCHAR(100)  NOT NULL,
@@ -26,7 +41,7 @@ CREATE TABLE jenkins_build (
   timestamp    TIMESTAMP     NOT NULL,
 
   CONSTRAINT pk_jenkins_build PRIMARY KEY (UUID),
-  CONSTRAINT fk_jenkins_build__server FOREIGN KEY (server) REFERENCES jenkins_server (uuid),
+  CONSTRAINT fk_jenkins_build__job FOREIGN KEY (job) REFERENCES jenkins_job (uuid),
   CONSTRAINT uq_jenkins_build__id UNIQUE (entry_id)
 );
 
diff --git a/src/main/resources/logback-test.xml b/src/main/resources/logback-test.xml
index 49aa8bc..a865432 100755
--- a/src/main/resources/logback-test.xml
+++ b/src/main/resources/logback-test.xml
@@ -2,17 +2,19 @@
 
   <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
     <encoder>
-      <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
+      <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %-30logger{1} - %msg%n</pattern>
     </encoder>
   </appender>
 
-  <logger name="org.apache.http.headers" level="INFO"/>
+  <logger name="org.apache.http.headers" level="DEBUG"/>
   <logger name="org.apache.http.wire" level="INFO"/>
   <logger name="org.apache.http" level="INFO"/>
   <!-- Gitorious spews out a few invalid cookies -->
   <logger name="org.apache.http.client.protocol.ResponseProcessCookies" level="ERROR"/>
 
-  <root>
+  <logger name="io.trygvis.esper.testing.util.HttpClient" level="DEBUG"/>
+
+  <root level="INFO">
     <appender-ref ref="STDOUT"/>
   </root>
 </configuration>