diff options
author | Holger Levsen <holger@layer-acht.org> | 2015-10-04 04:15:40 +0200 |
---|---|---|
committer | Holger Levsen <holger@layer-acht.org> | 2015-10-04 04:15:40 +0200 |
commit | 51ed3da77e3e370a077bcbda8f3392ee1675d8a7 (patch) | |
tree | 153b964adfad274102af0283c93a159e70d1b127 /bin/reproducible_common.sh | |
parent | 381aa559adb29bfa8fbcbe83ebac4f57cadc4a36 (diff) | |
download | jenkins.debian.net-51ed3da77e3e370a077bcbda8f3392ee1675d8a7.tar.xz |
reproducible: create https://reproducible.debian.net/$suite/$arch/stats_pkgs_to_fix.png instead, still not linked
Diffstat (limited to 'bin/reproducible_common.sh')
-rwxr-xr-x | bin/reproducible_common.sh | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/bin/reproducible_common.sh b/bin/reproducible_common.sh index a63be612..a09bc867 100755 --- a/bin/reproducible_common.sh +++ b/bin/reproducible_common.sh @@ -574,8 +574,8 @@ create_png_from_table() { sqlite3 -init ${INIT} -csv ${PACKAGES_DB} "SELECT datum, $SUM_DONE, $SUM_OPEN from ${TABLE[3]} ORDER BY datum" >> ${TABLE[$1]}.csv elif [ $1 -eq 8 ] ; then sqlite3 -init ${INIT} --nullvalue 0 -csv ${PACKAGES_DB} "SELECT s.datum, - (SELECT (e.unreproducible+e.ftbfs) FROM ${TABLE[0]} AS e WHERE s.datum=e.datum AND e.suite='unstable' AND e.architecture='$ARCH') AS unfixed_unstable, - COALESCE((SELECT (e.unreproducible+e.ftbfs) FROM ${TABLE[0]} AS e WHERE s.datum=e.datum AND e.suite='testing' AND e.architecture='$ARCH'),0) AS unfixed_testing + (SELECT e.ftbfs FROM ${TABLE[0]} AS e WHERE s.datum=e.datum AND e.suite='$SUITE' AND e.architecture='$ARCH') AS unfixed_ftbfs, + COALESCE((SELECT e.unreproducible FROM ${TABLE[0]} AS e WHERE s.datum=e.datum AND e.suite='$SUITE' AND e.architecture='$ARCH'),0) AS unfixed_ftbr FROM ${TABLE[0]} AS s $WHERE2_EXTRA GROUP BY s.datum" >> ${TABLE[$1]}.csv else sqlite3 -init ${INIT} -csv ${PACKAGES_DB} "SELECT ${FIELDS[$1]} from ${TABLE[$1]} ${WHERE_EXTRA} ORDER BY datum" >> ${TABLE[$1]}.csv |