summaryrefslogtreecommitdiffstats
path: root/bin/reproducible_html_dashboard.sh
diff options
context:
space:
mode:
authorHolger Levsen <holger@layer-acht.org>2016-10-02 14:43:44 +0200
committerHolger Levsen <holger@layer-acht.org>2016-10-02 14:43:44 +0200
commit87099ace45b70c33c2d321992e7047aa24096bcd (patch)
tree1e7cd219bf7fafc17bd39a83daf8a6a7d87c2bb2 /bin/reproducible_html_dashboard.sh
parent9710ef92f03eb88b0ca56dce1252fb95b782209e (diff)
downloadjenkins.debian.net-87099ace45b70c33c2d321992e7047aa24096bcd.tar.xz
reproducible Debian: show stats for packages with issue in testing too
Diffstat (limited to 'bin/reproducible_html_dashboard.sh')
-rwxr-xr-xbin/reproducible_html_dashboard.sh18
1 files changed, 15 insertions, 3 deletions
diff --git a/bin/reproducible_html_dashboard.sh b/bin/reproducible_html_dashboard.sh
index af6a3639..7f64f22b 100755
--- a/bin/reproducible_html_dashboard.sh
+++ b/bin/reproducible_html_dashboard.sh
@@ -493,7 +493,10 @@ create_dashboard_page() {
local TD_PKG_SID_FTBR="<tr><td class=\"left\">&nbsp;&nbsp;- unreproducible ones</a></td><td></td>"
local TD_PKG_SID_FTBFS="<tr><td class=\"left\">&nbsp;&nbsp;- failing to build</a></td><td></td>"
local TD_PKG_SID_ISSUES="<tr><td class=\"left\">packages in unstable which need to be fixed</td><td></td>"
- local TD_PKG_TESTING_ISSUES="<tr><td class=\"left\">&nbsp;&nbsp;- in testing</td><td></td>"
+ local TD_PKG_TESTING_NOISSUES="<tr><td class=\"left\">packages in testing with issues but without identified ones</td><td></td>"
+ local TD_PKG_TESTING_FTBR="<tr><td class=\"left\">&nbsp;&nbsp;- unreproducible ones</a></td><td></td>"
+ local TD_PKG_TESTING_FTBFS="<tr><td class=\"left\">&nbsp;&nbsp;- failing to build</a></td><td></td>"
+ local TD_PKG_TESTING_ISSUES="<tr><td class=\"left\">packages in testing which need to be fixed</td><td></td>"
for ARCH in ${ARCHS} ; do
SUITE="unstable"
gather_suite_arch_stats
@@ -509,14 +512,23 @@ create_dashboard_page() {
SUITE="testing"
gather_suite_arch_stats
TD_PKG_TESTING_ISSUES="$TD_PKG_TESTING_ISSUES<td>$(echo $COUNT_BAD + $COUNT_UGLY |bc) / $(echo $PERCENT_BAD + $PERCENT_UGLY|bc)%</td>"
+ RESULT=$(sqlite3 -init ${INIT} ${PACKAGES_DB} "SELECT COUNT(*) FROM (SELECT s.id FROM sources AS s JOIN results AS r ON r.package_id=s.id WHERE r.status IN ('unreproducible', 'FTBFS', 'blacklisted') AND s.id NOT IN (SELECT package_id FROM notes) AND s.suite='$SUITE' AND s.architecture='$ARCH')")
+ TD_PKG_TESTING_NOISSUES="$TD_PKG_TESTING_NOISSUES<td><a href=\"/debian/$SUITE/$ARCH/index_no_notes.html\">$RESULT</a> / $(echo "scale=1 ; ($RESULT*100/$COUNT_TOTAL)" | bc)%</td>"
+ RESULT=$(sqlite3 -init ${INIT} ${PACKAGES_DB} "SELECT COUNT(*) FROM (SELECT s.id FROM sources AS s JOIN results AS r ON r.package_id=s.id WHERE r.status='unreproducible' AND s.id NOT IN (SELECT package_id FROM notes) AND s.suite='$SUITE' AND s.architecture='$ARCH')")
+ TD_PKG_TESTING_FTBR="$TD_PKG_TESTING_FTBR<td>$RESULT / $(echo "scale=1 ; ($RESULT*100/$COUNT_TOTAL)" | bc)%</td>"
+ RESULT=$(sqlite3 -init ${INIT} ${PACKAGES_DB} "SELECT COUNT(*) FROM (SELECT s.id FROM sources AS s JOIN results AS r ON r.package_id=s.id WHERE r.status='FTBFS' AND s.id NOT IN (SELECT package_id FROM notes) AND s.suite='$SUITE' AND s.architecture='$ARCH')")
+ TD_PKG_TESTING_FTBFS="$TD_PKG_TESTING_FTBFS<td>$RESULT / $(echo "scale=1 ; ($RESULT*100/$COUNT_TOTAL)" | bc)%</td>"
done
- ARCH="amd64"
- SUITE="unstable"
write_page "$TD_PKG_SID_NOISSUES</tr>"
write_page "$TD_PKG_SID_FTBR</tr>"
write_page "$TD_PKG_SID_FTBFS</tr>"
write_page "$TD_PKG_SID_ISSUES</tr>"
+ write_page "$TD_PKG_TESTING_NOISSUES</tr>"
+ write_page "$TD_PKG_TESTING_FTBR</tr>"
+ write_page "$TD_PKG_TESTING_FTBFS</tr>"
write_page "$TD_PKG_TESTING_ISSUES</tr>"
+ ARCH="amd64"
+ SUITE="unstable"
# in the following two write_page() calls we use the same
# insane grep to filter people who committed with several