From 7a6eee49d49db578d68629c75db43b78fc0381c1 Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Sun, 28 Sep 2014 11:05:16 +0200 Subject: reproducible: polish --- bin/reproducible_build.sh | 3 ++- bin/reproducible_stats.sh | 9 ++++++--- 2 files changed, 8 insertions(+), 4 deletions(-) diff --git a/bin/reproducible_build.sh b/bin/reproducible_build.sh index 30f4feb4..15ff056a 100755 --- a/bin/reproducible_build.sh +++ b/bin/reproducible_build.sh @@ -42,6 +42,7 @@ if [[ $1 =~ ^-?[0-9]+$ ]] ; then rm $TMPFILE else PACKAGES="$@" + AMOUNT="${#@}" fi set +x echo @@ -124,7 +125,7 @@ for SRCPACKAGE in $PACKAGES ; do set +x echo "==============================================================" - echo "$COUNT_TOTAL of ${#PACKAGES} done." + echo "$COUNT_TOTAL of $AMOUNT done." echo "==============================================================" set -x done diff --git a/bin/reproducible_stats.sh b/bin/reproducible_stats.sh index 07e7e03f..a56e4526 100755 --- a/bin/reproducible_stats.sh +++ b/bin/reproducible_stats.sh @@ -3,6 +3,9 @@ # Copyright 2014 Holger Levsen # released under the GPLv=2 +. /srv/jenkins/bin/common-functions.sh +common_init "$@" + set +x PACKAGES_DB=/var/lib/jenkins/reproducible.db if [ ! -f $PACKAGES_DB ] ; then @@ -12,11 +15,11 @@ fi GOOD=$(sqlite3 $PACKAGES_DB "SELECT name FROM source_packages WHERE status = \"reproducible\" ORDER BY name" | xargs echo) COUNT_GOOD=$(sqlite3 $PACKAGES_DB "SELECT COUNT(name) FROM source_packages WHERE status = \"reproducible\"") -BAD=$(sqlite3 $PACKAGES_DB "SELECT name FROM source_packages WHERE status = \"unreproducible\" ORDER BY build_date" | xargs echo) +BAD=$(sqlite3 $PACKAGES_DB "SELECT name FROM source_packages WHERE status = \"unreproducible\" ORDER BY build_date DESC" | xargs echo) COUNT_BAD=$(sqlite3 $PACKAGES_DB "SELECT COUNT(name) FROM source_packages WHERE status = \"unreproducible\"") -UGLY=$(sqlite3 $PACKAGES_DB "SELECT name FROM source_packages WHERE status = \"FTBFS\" ORDER BY build_date" | xargs echo) +UGLY=$(sqlite3 $PACKAGES_DB "SELECT name FROM source_packages WHERE status = \"FTBFS\" ORDER BY build_date DESC" | xargs echo) COUNT_UGLY=$(sqlite3 $PACKAGES_DB "SELECT COUNT(name) FROM source_packages WHERE status = \"FTBFS\"") -SOURCELESS=$(sqlite3 $PACKAGES_DB "SELECT name FROM source_packages WHERE status = \"404\" ORDER BY build_date" | xargs echo) +SOURCELESS=$(sqlite3 $PACKAGES_DB "SELECT name FROM source_packages WHERE status = \"404\" ORDER BY build_date DESC" | xargs echo) COUNT_SOURCELESS=$(sqlite3 $PACKAGES_DB "SELECT COUNT(name) FROM source_packages WHERE status = \"404\"" | xargs echo) COUNT_TOTAL=$(sqlite3 $PACKAGES_DB "SELECT COUNT(name) FROM source_packages") -- cgit v1.2.3-70-g09d2