From 4881690364b5826a45c7832550cb95b351e41217 Mon Sep 17 00:00:00 2001
From: Holger Levsen <holger@layer-acht.org>
Date: Fri, 27 Feb 2015 23:49:39 +0100
Subject: reproducible: track new usertag, umask

---
 bin/make_graph.py                  | 2 +-
 bin/reproducible_db_maintenance.py | 4 ++++
 bin/reproducible_html_graphs.sh    | 4 ++--
 3 files changed, 7 insertions(+), 3 deletions(-)

(limited to 'bin')

diff --git a/bin/make_graph.py b/bin/make_graph.py
index 73bc5ab2..4fc3bbc4 100755
--- a/bin/make_graph.py
+++ b/bin/make_graph.py
@@ -37,7 +37,7 @@ def main():
                      "#729fcf", "#204a87", "#ef2929", "#a40000", \
                      "#888a85", "#2e3436", "#75507b", "#cc0000", \
                      "#ce5c00", "#73d216", "#edd400", "#f57900", \
-                     "#c17d11", "#3465a4"))')
+                     "#c17d11", "#3465a4", "#666666", "#AAAAAA", ))')
     r('v <- t[0:nrow(t),0:'+colors+']')
     # make graph since day 1
     r('barplot(t(v),col = 1:'+columns+', main="'+mainlabel+'", xlab="", ylab="'+ylabel+'", space=0, border=NA)')
diff --git a/bin/reproducible_db_maintenance.py b/bin/reproducible_db_maintenance.py
index 7dff97a9..5cf776be 100755
--- a/bin/reproducible_db_maintenance.py
+++ b/bin/reproducible_db_maintenance.py
@@ -214,6 +214,10 @@ schema_updates = {
             build_duration TEXT NOT NULL,
             UNIQUE (name, version, suite, architecture, build_date))''',
         'INSERT INTO rb_schema VALUES ("2", "' + now + '")']
+    3: [ # add columns to stats_bugs for new usertag umask
+        '''ALTER TABLE stats_bugs ADD COLUMN open_umask INTEGER''',
+        '''ALTER TABLE stats_bugs ADD COLUMN done_umask INTEGER''',
+        'INSERT INTO rb_schema VALUES ("3", "' + now + '")'],
 }
 
 
diff --git a/bin/reproducible_html_graphs.sh b/bin/reproducible_html_graphs.sh
index 121683d5..a203ece6 100755
--- a/bin/reproducible_html_graphs.sh
+++ b/bin/reproducible_html_graphs.sh
@@ -139,7 +139,7 @@ done
 #
 # gather bugs stats
 #
-USERTAGS="toolchain infrastructure timestamps fileordering buildpath username hostname uname randomness buildinfo cpu signatures environment"
+USERTAGS="toolchain infrastructure timestamps fileordering buildpath username hostname uname randomness buildinfo cpu signatures environment umask"
 RESULT=$(sqlite3 -init ${INIT} ${PACKAGES_DB} "SELECT * from ${TABLE[3]} WHERE datum = \"$DATE\"")
 if [ -z $RESULT ] ; then
 	declare -a DONE
@@ -179,7 +179,7 @@ FIELDS[6]="datum, reproducible, unreproducible, FTBFS, other"
 COLOR[0]=5
 COLOR[1]=4
 COLOR[2]=3
-COLOR[3]=26
+COLOR[3]=28
 COLOR[4]=1
 COLOR[5]=1
 COLOR[6]=4
-- 
cgit v1.2.3-70-g09d2