summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorHolger Levsen <holger@layer-acht.org>2014-10-18 00:54:08 +0200
committerHolger Levsen <holger@layer-acht.org>2014-10-18 01:32:35 +0200
commitd0162e88678b76e1906f874e74f788dab1e8d85b (patch)
tree11fb216591c2798980e47c07139bf0915c10e5b6
parenta0b4a3c0659e56937ac4ba5ded3aa017a0da9b27 (diff)
downloadjenkins.debian.net-d0162e88678b76e1906f874e74f788dab1e8d85b.tar.xz
reproducible: add info about unscheduled packages on schedule page
-rwxr-xr-xbin/reproducible_common.sh25
1 files changed, 22 insertions, 3 deletions
diff --git a/bin/reproducible_common.sh b/bin/reproducible_common.sh
index 38c1333f..595d1ace 100755
--- a/bin/reproducible_common.sh
+++ b/bin/reproducible_common.sh
@@ -357,6 +357,23 @@ process_packages() {
done
}
+gather_schedule_stats() {
+ SCHEDULED=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT name FROM sources_scheduled ORDER BY date_scheduled DESC" | xargs echo)
+ COUNT_SCHEDULED=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT count(name) FROM sources_scheduled ORDER BY date_scheduled DESC" | xargs echo)
+ let "COUNT_NOTYET=AMOUNT-COUNT_TOTAL-COUNT_SCHEDULED"
+ QUERY=" SELECT count(sources.name) FROM sources,source_packages
+ WHERE sources.name NOT IN
+ (SELECT sources.name FROM sources,sources_scheduled
+ WHERE sources.name=sources_scheduled.name)
+ AND sources.name IN
+ (SELECT sources.name FROM sources,source_packages
+ WHERE sources.name=source_packages.name
+ AND sources.version!=source_packages.version
+ AND source_packages.status!='blacklisted')
+ AND sources.name=source_packages.name"
+ COUNT_NEW_VERSIONS=$(sqlite3 -init $INIT $PACKAGES_DB "$QUERY")
+}
+
gather_stats() {
COUNT_BAD=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT COUNT(name) FROM source_packages WHERE status = \"unreproducible\"")
COUNT_UGLY=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT COUNT(name) FROM source_packages WHERE status = \"FTBFS\"")
@@ -370,14 +387,16 @@ gather_stats() {
}
update_html_schedule() {
- gather_stats
- SCHEDULED=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT name FROM sources_scheduled ORDER BY date_scheduled DESC" | xargs echo)
- COUNT_SCHEDULED=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT count(name) FROM sources_scheduled ORDER BY date_scheduled DESC" | xargs echo)
VIEW=scheduled
BUILDINFO_SIGNS=true
PAGE=index_${VIEW}.html
echo "$(date) - starting to write $PAGE page."
write_page_header $VIEW "Overview of reproducible builds of ${SPOKENTARGET[$VIEW]}"
+ gather_schedule_stats
+ if [ ${COUNT_NEW_VERSIONS} -ne 0 ] ; then
+ write_page "<p>For ${COUNT_NEW_VERSIONS} packages newer versions are available which have not been tested yet.</p>"
+ fi
+ write_page "<p>${COUNT_NOTYET} packages have not been tested at all.</p>"
write_page "<p>${COUNT_SCHEDULED} packages are currently scheduled for testing: <code>"
force_package_targets $SCHEDULED
link_packages $SCHEDULED