[Qa-jenkins-scm] [jenkins.debian.net] 01/01: reproducible: provide default '0' value for all columns in stats_bugs (fixup for f9147e8b)
Holger Levsen
holger at moszumanska.debian.org
Wed Jun 17 11:24:56 UTC 2015
This is an automated email from the git hooks/post-receive script.
holger pushed a commit to branch master
in repository jenkins.debian.net.
commit 6fe50c56622917146213eb5f8eecd392a49340c0
Author: Holger Levsen <holger at layer-acht.org>
Date: Wed Jun 17 13:24:06 2015 +0200
reproducible: provide default '0' value for all columns in stats_bugs (fixup for f9147e8b)
---
bin/reproducible_db_maintenance.py | 38 ++++++++++++++++++++++++++++++++++++++
1 file changed, 38 insertions(+)
diff --git a/bin/reproducible_db_maintenance.py b/bin/reproducible_db_maintenance.py
index 3c31da9..588d3cd 100755
--- a/bin/reproducible_db_maintenance.py
+++ b/bin/reproducible_db_maintenance.py
@@ -380,6 +380,44 @@ schema_updates = {
'''ALTER TABLE stats_bugs ADD COLUMN open_ftbfs INTEGER''',
'''ALTER TABLE stats_bugs ADD COLUMN done_ftbfs INTEGER''',
'INSERT INTO rb_schema VALUES ("15", "' + now + '")'],
+ 16: [ # add default value to stats_bugs.(open|done)_ftbfs 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',
+ done_environment INTEGER DEFAULT '0',
+ open_umask INTEGER DEFAULT '0',
+ done_umask INTEGER DEFAULT '0',
+ open_ftbfs INTEGER DEFAULT '0',
+ done_ftbfs 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 ("16", "' + now + '")'],
}
--
Alioth's /usr/local/bin/git-commit-notice on /srv/git.debian.org/git/qa/jenkins.debian.net.git
More information about the Qa-jenkins-scm
mailing list