From 04cb6e8f06bee56d966d86dd4a7f3a62b1b62c4d Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Thu, 1 Jan 2015 15:36:11 +0100 Subject: reproducible: add graph about number of investigated packages and known issues --- bin/reproducible_common.sh | 6 ++++++ bin/reproducible_html_graphs.sh | 14 ++++++++++++-- 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="" -- cgit v1.2.3-70-g09d2