From 343bfa89524e42ddf836cbcd3dd7d67687ba379a Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Wed, 15 Oct 2014 19:49:53 +0200 Subject: reproducible: add stats page with graphs --- bin/reproducible_common.sh | 29 ++++++++++++++++++++++++++++- 1 file changed, 28 insertions(+), 1 deletion(-) (limited to 'bin/reproducible_common.sh') diff --git a/bin/reproducible_common.sh b/bin/reproducible_common.sh index b78ecf07..3e77542a 100755 --- a/bin/reproducible_common.sh +++ b/bin/reproducible_common.sh @@ -42,7 +42,34 @@ elif [ ! -f ${PACKAGES_DB} ] ; then CREATE TABLE sources (name TEXT NOT NULL, version TEXT NOT NULL)' - # 30 seconds timeout when trying to get a lock + sqlite3 ${PACKAGES_DB} ' + CREATE TABLE stats_pkg_state + (datum TEXT NOT NULL, + suite TEXT NOT NULL, + untested INTEGER, + reproducible INTEGER, + unreproducible INTEGER, + FTBFS INTEGER, + other INTEGER, + PRIMARY KEY (datum))' + sqlite3 ${PACKAGES_DB} ' + CREATE TABLE stats_builds_per_day + (datum TEXT NOT NULL, + suite TEXT NOT NULL, + reproducible INTEGER, + unreproducible INTEGER, + FTBFS INTEGER, + other INTEGER, + PRIMARY KEY (datum))' + sqlite3 ${PACKAGES_DB} ' + CREATE TABLE stats_builds_age + (datum TEXT NOT NULL, + suite TEXT NOT NULL, + oldest_reproducible REAL, + oldest_unreproducible REAL, + oldest_FTBFS REAL, + PRIMARY KEY (datum))' + # 60 seconds timeout when trying to get a lock cat >/var/lib/jenkins/reproducible.init <<-EOF .timeout 60000 EOF -- cgit v1.2.3-54-g00ecf