[SCM] build.samba.org - branch master updated

[Jelmer Vernooij]

The branch, master has been updated
       via  7af2d22 Add Tree database table.
      from  5b80a36 Kill commit_revision.

http://gitweb.samba.org/?p=build-farm.git;a=shortlog;h=master


- Log -----------------------------------------------------------------
commit 7af2d22ee31d1a78182074183dec4f0c7d0c4d15
Author: Jelmer Vernooij <jelmer at samba.org>
Date:   Fri Nov 19 20:29:41 2010 +0100

    Add Tree database table.

-----------------------------------------------------------------------

Summary of changes:
 buildfarm/sqldb.py |   38 +++++++++++++++++++++++++++++++++++++-
 1 files changed, 37 insertions(+), 1 deletions(-)


Changeset truncated at 500 lines:

diff --git a/buildfarm/sqldb.py b/buildfarm/sqldb.py
index 9434f0f..e20bbbc 100644
--- a/buildfarm/sqldb.py
+++ b/buildfarm/sqldb.py
@@ -19,6 +19,7 @@
 
 from buildfarm import (
     BuildFarm,
+    Tree,
     )
 from buildfarm.data import (
     Build,
@@ -261,11 +262,46 @@ class StormCachingBuildFarm(BuildFarm):
         self.store.commit()
 
 
+class StormTree(Tree):
+    __storm_table__ = "tree"
+
+    id = Int(primary=True)
+    name = RawStr()
+    scm = Int()
+    branch = RawStr()
+    subdir = RawStr()
+    repo = RawStr()
+    scm = RawStr()
+
+
 def setup_schema(db):
-    db.execute("CREATE TABLE IF NOT EXISTS host (id integer primary key autoincrement, name blob not null, owner text, owner_email text, password text, ssh_access int, fqdn text, platform text, permission text, last_dead_mail int, join_time int);", noresult=True)
+    db.execute("PRAGMA foreign_keys = 1;", noresult=True)
+    db.execute("""
+CREATE TABLE IF NOT EXISTS host (
+    id integer primary key autoincrement,
+    name blob not null,
+    owner text,
+    owner_email text,
+    password text,
+    ssh_access int,
+    fqdn text,
+    platform text,
+    permission text,
+    last_dead_mail int,
+    join_time int
+);""", noresult=True)
     db.execute("CREATE UNIQUE INDEX IF NOT EXISTS unique_hostname ON host (name);", noresult=True)
     db.execute("CREATE TABLE IF NOT EXISTS build (id integer primary key autoincrement, tree blob not null, revision blob, host blob not null, compiler blob not null, checksum blob, age int, status blob, basename blob);", noresult=True)
     db.execute("CREATE UNIQUE INDEX IF NOT EXISTS unique_checksum ON build (checksum);", noresult=True)
+    db.execute("""
+CREATE TABLE IF NOT EXISTS tree (
+    id integer primary key autoincrement,
+    name blob not null,
+    scm int,
+    branch blob,
+    subdir blob,
+    repo blob
+    );""", noresult=True)
 
 
 def memory_store():


-- 
build.samba.org