From f981271026761bb30fa05a2c754085b8e448f702 Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Tue, 10 Mar 2015 02:13:40 +0100 Subject: reproducible: db schema 8: add default value to stats_bugs to get a full 'done vs open bugs' graph --- bin/reproducible_db_maintenance.py | 36 ++++++++++++++++++++++++++++++++++++ 1 file changed, 36 insertions(+) (limited to 'bin/reproducible_db_maintenance.py') diff --git a/bin/reproducible_db_maintenance.py b/bin/reproducible_db_maintenance.py index 74fd8e91..a2fc1149 100755 --- a/bin/reproducible_db_maintenance.py +++ b/bin/reproducible_db_maintenance.py @@ -293,6 +293,42 @@ schema_updates = { 'DROP TABLE results', 'ALTER TABLE results_tmp RENAME TO results', 'INSERT INTO rb_schema VALUES ("7", "' + now + '")'], + 8: [ # add default value to stats_bugs to get a full 'done vs open bugs' graph + '''CREATE TABLE stats_bugs_tmp + (datum TEXT NOT NULL, + open_toolchain INTEGER DEFAULT '0', + done_toolchain INTEGER DEFAULT '0', + open_infrastructure INTEGER DEFAULT '0', + done_infrastructure INTEGER DEFAULT '0', + open_timestamps INTEGER DEFAULT '0', + done_timestamps INTEGER DEFAULT '0', + open_fileordering INTEGER DEFAULT '0', + done_fileordering INTEGER DEFAULT '0', + open_buildpath INTEGER DEFAULT '0', + done_buildpath INTEGER DEFAULT '0', + open_username INTEGER DEFAULT '0', + done_username INTEGER DEFAULT '0', + open_hostname INTEGER DEFAULT '0', + done_hostname INTEGER DEFAULT '0', + open_uname INTEGER DEFAULT '0', + done_uname INTEGER DEFAULT '0', + open_randomness INTEGER DEFAULT '0', + done_randomness INTEGER DEFAULT '0', + open_buildinfo INTEGER DEFAULT '0', + done_buildinfo INTEGER DEFAULT '0', + open_cpu INTEGER DEFAULT '0', + done_cpu INTEGER DEFAULT '0', + open_signatures INTEGER DEFAULT '0', + done_signatures INTEGER DEFAULT '0', + open_environment INTEGER DEFAULT '0', + one_environment INTEGER DEFAULT '0', + open_umask INTEGER DEFAULT '0', + done_umask INTEGER DEFAULT '0', + PRIMARY KEY (datum))''', + 'INSERT INTO stats_bugs_tmp SELECT * FROM stats_bugs', + 'DROP TABLE stats_bugs', + 'ALTER TABLE stats_bugs_tmp RENAME TO stats_bugs', + 'INSERT INTO rb_schema VALUES ("8", "' + now + '")'], } -- cgit v1.2.3-54-g00ecf