diff options
| author | Holger Levsen <holger@layer-acht.org> | 2015-03-09 19:15:57 +0100 |
|---|---|---|
| committer | Holger Levsen <holger@layer-acht.org> | 2015-03-09 19:15:57 +0100 |
| commit | 62cb693a4aaef9b35565a3dfdee26e41e108533d (patch) | |
| tree | 3f609aba5b24eeb66cf541266d5df56379d34762 /bin | |
| parent | 6c8d41ecc7c971279889e64f8bb26d32d32be878 (diff) | |
| download | jenkins.debian.net-62cb693a4aaef9b35565a3dfdee26e41e108533d.tar.xz | |
reproducible: refactor: move another function to html_graphs.sh. correct function descriptions.
Diffstat (limited to 'bin')
| -rwxr-xr-x | bin/reproducible_common.sh | 11 | ||||
| -rwxr-xr-x | bin/reproducible_html_graphs.sh | 24 |
2 files changed, 21 insertions, 14 deletions
diff --git a/bin/reproducible_common.sh b/bin/reproducible_common.sh index 9a181a3e..c096ac36 100755 --- a/bin/reproducible_common.sh +++ b/bin/reproducible_common.sh @@ -246,14 +246,3 @@ gen_packages_html() { cd "$CWD" } -gather_stats() { - COUNT_BAD=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT COUNT(s.name) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='$SUITE' AND r.status = \"unreproducible\"") - COUNT_UGLY=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT COUNT(s.name) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='$SUITE' AND r.status = \"FTBFS\"") - COUNT_SOURCELESS=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT COUNT(s.name) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='$SUITE' AND r.status = \"404\"") - COUNT_NOTFORUS=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT COUNT(s.name) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='$SUITE' AND r.status = \"not for us\"") - COUNT_BLACKLISTED=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT COUNT(s.name) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='$SUITE' AND r.status = \"blacklisted\"") - PERCENT_BAD=$(echo "scale=1 ; ($COUNT_BAD*100/$COUNT_TOTAL)" | bc) - PERCENT_UGLY=$(echo "scale=1 ; ($COUNT_UGLY*100/$COUNT_TOTAL)" | bc) - PERCENT_NOTFORUS=$(echo "scale=1 ; ($COUNT_NOTFORUS*100/$COUNT_TOTAL)" | bc) - PERCENT_SOURCELESS=$(echo "scale=1 ; ($COUNT_SOURCELESS*100/$COUNT_TOTAL)" | bc) -} diff --git a/bin/reproducible_html_graphs.sh b/bin/reproducible_html_graphs.sh index 9ddb48ad..09c0b14b 100755 --- a/bin/reproducible_html_graphs.sh +++ b/bin/reproducible_html_graphs.sh @@ -22,7 +22,7 @@ init_html gather_stats # -# create stats +# init # # we only do stats up until yesterday... we also could do today too but not update the db yet... DATE=$(date -d "1 day ago" '+%Y-%m-%d') @@ -36,7 +36,7 @@ TABLE[5]=stats_issues TABLE[6]=stats_meta_pkg_state # -# gather package + build stats +# update package + build stats # RESULT=$(sqlite3 -init ${INIT} ${PACKAGES_DB} "SELECT datum,suite from ${TABLE[0]} WHERE datum = \"$DATE\" AND suite = \"$SUITE\"") if [ -z $RESULT ] ; then @@ -83,7 +83,7 @@ if [ -z $RESULT ] ; then fi # -# gather notes stats +# update notes stats # RESULT=$(sqlite3 -init ${INIT} ${PACKAGES_DB} "SELECT datum from ${TABLE[4]} WHERE datum = \"$DATE\"") if [ -z $RESULT ] ; then @@ -105,6 +105,21 @@ if [ -z $RESULT ] ; then fi # +# gather packages stats +# +gather_stats() { + COUNT_BAD=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT COUNT(s.name) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='$SUITE' AND r.status = \"unreproducible\"") + COUNT_UGLY=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT COUNT(s.name) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='$SUITE' AND r.status = \"FTBFS\"") + COUNT_SOURCELESS=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT COUNT(s.name) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='$SUITE' AND r.status = \"404\"") + COUNT_NOTFORUS=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT COUNT(s.name) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='$SUITE' AND r.status = \"not for us\"") + COUNT_BLACKLISTED=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT COUNT(s.name) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='$SUITE' AND r.status = \"blacklisted\"") + PERCENT_BAD=$(echo "scale=1 ; ($COUNT_BAD*100/$COUNT_TOTAL)" | bc) + PERCENT_UGLY=$(echo "scale=1 ; ($COUNT_UGLY*100/$COUNT_TOTAL)" | bc) + PERCENT_NOTFORUS=$(echo "scale=1 ; ($COUNT_NOTFORUS*100/$COUNT_TOTAL)" | bc) + PERCENT_SOURCELESS=$(echo "scale=1 ; ($COUNT_SOURCELESS*100/$COUNT_TOTAL)" | bc) +} + +# # gather meta pkg stats # gather_meta_stats() { @@ -141,6 +156,9 @@ gather_meta_stats() { fi } +# +# update meta pkg stats +# if [ "$SUITE" != "experimental" ] ; then # no meta pkg sets in experimental for i in $(seq 1 ${#META_PKGSET[@]}) ; do |