Merge branch 'devel'

* devel:
  add more tests
  inside the hook, we check if we can add more than one task for this project
  add configuration option to skip some branches; add tests for the Hook
  that's why we want datetime
  use DateTime
  update templates to show informations about running tasks
  column started_when: datetime when the build started
  prepare to update schema again
  display current build if any
  add sql schema for various version
  don't ignore .sql files
  script to migrate/upgrade dbix schema
  add version to our schema
  update templates and css
  we want a find, not a search here
  add pending status to the schema (TODO: need a script to migrate the schema)
  load tasks and display them on the dashboard

6 files changed, 153 insertions, 0 deletions

diff --git a/sql/MySQL/deploy/1/001-auto-__VERSION.sql b/sql/MySQL/deploy/1/001-auto-__VERSION.sql
new file mode 100644
index 0000000..597d180
--- /dev/null
+++ b/sql/MySQL/deploy/1/001-auto-__VERSION.sql
@@ -0,0 +1,18 @@
+-- 
+-- Created by SQL::Translator::Producer::MySQL
+-- Created on Mon Jan 24 21:25:06 2011
+-- 
+;
+SET foreign_key_checks=0;
+--
+-- Table: `dbix_class_deploymenthandler_versions`
+--
+CREATE TABLE `dbix_class_deploymenthandler_versions` (
+  `id` integer NOT NULL auto_increment,
+  `version` varchar(50) NOT NULL,
+  `ddl` text,
+  `upgrade_sql` text,
+  PRIMARY KEY (`id`),
+  UNIQUE `dbix_class_deploymenthandler_versions_version` (`version`)
+);
+SET foreign_key_checks=1
\ No newline at end of file
diff --git a/sql/MySQL/deploy/1/001-auto.sql b/sql/MySQL/deploy/1/001-auto.sql
new file mode 100644
index 0000000..2a8b829
--- /dev/null
+++ b/sql/MySQL/deploy/1/001-auto.sql
@@ -0,0 +1,46 @@
+-- 
+-- Created by SQL::Translator::Producer::MySQL
+-- Created on Mon Jan 24 21:25:06 2011
+-- 
+;
+SET foreign_key_checks=0;
+--
+-- Table: `project`
+--
+CREATE TABLE `project` (
+  `projectid` integer NOT NULL auto_increment,
+  `name` text NOT NULL,
+  `url` text NOT NULL,
+  `description` text NOT NULL,
+  `owner` text NOT NULL,
+  PRIMARY KEY (`projectid`),
+  UNIQUE `project_name` (`name`)
+) ENGINE=InnoDB;
+--
+-- Table: `commit_push`
+--
+CREATE TABLE `commit_push` (
+  `sha256` text NOT NULL,
+  `content` text NOT NULL,
+  `projectid` integer NOT NULL,
+  `timestamp` datetime NOT NULL,
+  INDEX `commit_push_idx_projectid` (`projectid`),
+  PRIMARY KEY (`sha256`),
+  CONSTRAINT `commit_push_fk_projectid` FOREIGN KEY (`projectid`) REFERENCES `project` (`projectid`)
+) ENGINE=InnoDB;
+--
+-- Table: `task`
+--
+CREATE TABLE `task` (
+  `taskid` integer NOT NULL auto_increment,
+  `sha256` text NOT NULL,
+  `projectid` integer NOT NULL,
+  INDEX `task_idx_sha256` (`sha256`),
+  INDEX `task_idx_projectid` (`projectid`),
+  PRIMARY KEY (`taskid`),
+  UNIQUE `task_projectid` (`projectid`),
+  UNIQUE `task_sha256` (`sha256`),
+  CONSTRAINT `task_fk_sha256` FOREIGN KEY (`sha256`) REFERENCES `commit_push` (`sha256`),
+  CONSTRAINT `task_fk_projectid` FOREIGN KEY (`projectid`) REFERENCES `project` (`projectid`)
+) ENGINE=InnoDB;
+SET foreign_key_checks=1
\ No newline at end of file
diff --git a/sql/MySQL/deploy/2/001-auto-__VERSION.sql b/sql/MySQL/deploy/2/001-auto-__VERSION.sql
new file mode 100644
index 0000000..e91854a
--- /dev/null
+++ b/sql/MySQL/deploy/2/001-auto-__VERSION.sql
@@ -0,0 +1,18 @@
+-- 
+-- Created by SQL::Translator::Producer::MySQL
+-- Created on Mon Jan 24 21:26:42 2011
+-- 
+;
+SET foreign_key_checks=0;
+--
+-- Table: `dbix_class_deploymenthandler_versions`
+--
+CREATE TABLE `dbix_class_deploymenthandler_versions` (
+  `id` integer NOT NULL auto_increment,
+  `version` varchar(50) NOT NULL,
+  `ddl` text,
+  `upgrade_sql` text,
+  PRIMARY KEY (`id`),
+  UNIQUE `dbix_class_deploymenthandler_versions_version` (`version`)
+);
+SET foreign_key_checks=1
\ No newline at end of file
diff --git a/sql/MySQL/deploy/2/001-auto.sql b/sql/MySQL/deploy/2/001-auto.sql
new file mode 100644
index 0000000..d208773
--- /dev/null
+++ b/sql/MySQL/deploy/2/001-auto.sql
@@ -0,0 +1,47 @@
+-- 
+-- Created by SQL::Translator::Producer::MySQL
+-- Created on Mon Jan 24 21:26:41 2011
+-- 
+;
+SET foreign_key_checks=0;
+--
+-- Table: `project`
+--
+CREATE TABLE `project` (
+  `projectid` integer NOT NULL auto_increment,
+  `name` text NOT NULL,
+  `url` text NOT NULL,
+  `description` text NOT NULL,
+  `owner` text NOT NULL,
+  PRIMARY KEY (`projectid`),
+  UNIQUE `project_name` (`name`)
+) ENGINE=InnoDB;
+--
+-- Table: `commit_push`
+--
+CREATE TABLE `commit_push` (
+  `sha256` text NOT NULL,
+  `content` text NOT NULL,
+  `projectid` integer NOT NULL,
+  `timestamp` datetime NOT NULL,
+  INDEX `commit_push_idx_projectid` (`projectid`),
+  PRIMARY KEY (`sha256`),
+  CONSTRAINT `commit_push_fk_projectid` FOREIGN KEY (`projectid`) REFERENCES `project` (`projectid`)
+) ENGINE=InnoDB;
+--
+-- Table: `task`
+--
+CREATE TABLE `task` (
+  `taskid` integer NOT NULL auto_increment,
+  `sha256` text NOT NULL,
+  `projectid` integer NOT NULL,
+  `running` bool NOT NULL DEFAULT '0',
+  INDEX `task_idx_sha256` (`sha256`),
+  INDEX `task_idx_projectid` (`projectid`),
+  PRIMARY KEY (`taskid`),
+  UNIQUE `task_projectid` (`projectid`),
+  UNIQUE `task_sha256` (`sha256`),
+  CONSTRAINT `task_fk_sha256` FOREIGN KEY (`sha256`) REFERENCES `commit_push` (`sha256`),
+  CONSTRAINT `task_fk_projectid` FOREIGN KEY (`projectid`) REFERENCES `project` (`projectid`)
+) ENGINE=InnoDB;
+SET foreign_key_checks=1
\ No newline at end of file
diff --git a/sql/MySQL/downgrade/2-1/001-auto.sql b/sql/MySQL/downgrade/2-1/001-auto.sql
new file mode 100644
index 0000000..3285916
--- /dev/null
+++ b/sql/MySQL/downgrade/2-1/001-auto.sql
@@ -0,0 +1,12 @@
+-- Convert schema 'sql/_source/deploy/2/001-auto.yml' to 'sql/_source/deploy/1/001-auto.yml':;
+
+;
+BEGIN;
+
+;
+ALTER TABLE task DROP COLUMN running;
+
+;
+
+COMMIT;
+
diff --git a/sql/MySQL/upgrade/1-2/001-auto.sql b/sql/MySQL/upgrade/1-2/001-auto.sql
new file mode 100644
index 0000000..1183d23
--- /dev/null
+++ b/sql/MySQL/upgrade/1-2/001-auto.sql
@@ -0,0 +1,12 @@
+-- Convert schema 'sql/_source/deploy/1/001-auto.yml' to 'sql/_source/deploy/2/001-auto.yml':;
+
+;
+BEGIN;
+
+;
+ALTER TABLE task ADD COLUMN running bool NOT NULL DEFAULT '0';
+
+;
+
+COMMIT;
+