summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorHolger Levsen <holger@layer-acht.org>2015-01-01 15:36:11 +0100
committerHolger Levsen <holger@layer-acht.org>2015-01-01 15:36:11 +0100
commit04cb6e8f06bee56d966d86dd4a7f3a62b1b62c4d (patch)
tree95b465d30c6dc4dc9cffc4406c7aaaec23ada048
parent3ab572ef870b7e5f6b1c4c1fe6b1fe358ed089ae (diff)
downloadjenkins.debian.net-04cb6e8f06bee56d966d86dd4a7f3a62b1b62c4d.tar.xz
reproducible: add graph about number of investigated packages and known issues
-rwxr-xr-xbin/reproducible_common.sh6
-rwxr-xr-xbin/reproducible_html_graphs.sh14
2 files changed, 18 insertions, 2 deletions
diff --git a/bin/reproducible_common.sh b/bin/reproducible_common.sh
index ba5bdb15..b2bc51dd 100755
--- a/bin/reproducible_common.sh
+++ b/bin/reproducible_common.sh
@@ -94,6 +94,12 @@ elif [ ! -f ${PACKAGES_DB} ] ; then
open_randomness INTEGER,
done_randomness INTEGER,
PRIMARY KEY (datum))'
+ sqlite3 ${PACKAGES_DB} '
+ CREATE TABLE stats_notes
+ (datum TEXT NOT NULL,
+ packages_with_notes INTEGER,
+ known_issues INTEGER,
+ PRIMARY KEY (datum))'
# 60 seconds timeout when trying to get a lock
cat > $INIT <<-EOF
.timeout 60000
diff --git a/bin/reproducible_html_graphs.sh b/bin/reproducible_html_graphs.sh
index 5e5c9a19..ec9011c0 100755
--- a/bin/reproducible_html_graphs.sh
+++ b/bin/reproducible_html_graphs.sh
@@ -23,6 +23,7 @@ TABLE[0]=stats_pkg_state
TABLE[1]=stats_builds_per_day
TABLE[2]=stats_builds_age
TABLE[3]=stats_bugs
+TABLE[4]=stats_notes
RESULT=$(sqlite3 -init ${INIT} ${PACKAGES_DB} "SELECT datum,suite from ${TABLE[0]} WHERE datum = \"$DATE\" AND suite = \"$SUITE\"")
if [ -z $RESULT ] ; then
ALL=$(sqlite3 -init ${INIT} ${PACKAGES_DB} "SELECT count(name) from sources")
@@ -53,6 +54,11 @@ if [ -z $RESULT ] ; then
# force regeneration of the image
touch -d "$DATE 00:00" ${TABLE[$i]}.png
done
+ # gather notes stats
+ # FIXME: hard-coding another job path is meh
+ NOTES=$(grep -c -v "^ " /var/lib/jenkins/jobs/reproducible_html_notes/workspace/packages.yml)
+ ISSUES=$(grep -c -v "^ " /var/lib/jenkins/jobs/reproducible_html_notes/workspace/issues.yml)
+ sqlite3 -init ${INIT} ${PACKAGES_DB} "INSERT INTO ${TABLE[4]} VALUES (\"$DATE\", \"$NOTES\", \"$ISSUES\")
fi
# query bts
@@ -90,22 +96,26 @@ FIELDS[3]="datum "
for TAG in $USERTAGS ; do
FIELDS[3]="${FIELDS[3]}, open_$TAG, done_$TAG"
done
+FIELDS[4]="datum, packages_with_notes, known_issues"
COLOR[0]=5
COLOR[1]=4
COLOR[2]=3
COLOR[3]=18
+COLOR[4]=2
MAINLABEL[0]="Package reproducibility status"
MAINLABEL[1]="Amount of packages build each day"
MAINLABEL[2]="Age in days of oldest kind of logfile"
MAINLABEL[3]="Bugs with usertags for user reproducible-builds@lists.alioth.debian.org"
+MAINLABEL[0]="Notes on investigated packages"
YLABEL[0]="Amount (total)"
YLABEL[1]="Amount (per day)"
YLABEL[2]="Age in days"
YLABEL[3]="Amount of bugs"
+YLABEL[4]="Amounts"
redo_png() {
echo "${FIELDS[$i]}" > ${TABLE[$i]}.csv
- # TABLE[3] doesn't have a suite column...
- if [ $i -ne 3 ] ; then
+ # TABLE[3+4] don't have a suite column...
+ if [ $i -ne 3 ] || [ $i -ne 4 ] ; then
WHERE_SUITE="WHERE suite = '$SUITE'"
else
WHERE_SUITE=""