diff options
author | Holger Levsen <holger@layer-acht.org> | 2015-10-09 15:46:15 +0200 |
---|---|---|
committer | Holger Levsen <holger@layer-acht.org> | 2015-10-09 15:46:15 +0200 |
commit | 1a29cdf01f84c4bcc223de68541e5ae6e777bce7 (patch) | |
tree | 2d1dbc208026c15fd7bc67dcca05e19a1b7c31a1 /bin/reproducible_common.sh | |
parent | bd0e008b8a90f47f5fe5103afde634fef25a8b93 (diff) | |
download | jenkins.debian.net-1a29cdf01f84c4bcc223de68541e5ae6e777bce7.tar.xz |
reproducible: drop redundant 'stats_pkgs_to_fix' graphs
Diffstat (limited to 'bin/reproducible_common.sh')
-rwxr-xr-x | bin/reproducible_common.sh | 20 |
1 files changed, 4 insertions, 16 deletions
diff --git a/bin/reproducible_common.sh b/bin/reproducible_common.sh index a7b25e57..7bed37fc 100755 --- a/bin/reproducible_common.sh +++ b/bin/reproducible_common.sh @@ -78,7 +78,6 @@ TABLE[4]=stats_notes TABLE[5]=stats_issues TABLE[6]=stats_meta_pkg_state TABLE[7]=stats_bugs_state -TABLE[8]=stats_pkgs_to_fix # known package sets META_PKGSET[1]="essential" @@ -549,6 +548,10 @@ create_png_from_table() { # armhf was only build since 2015-08-30 WHERE_EXTRA="$WHERE_EXTRA AND datum >= '2015-08-30'" fi + # testing/amd64 was only build since... + # WHERE2_EXTRA="WHERE s.datum >= '2015-03-08'" + # experimental/amd64 was only build since... + # WHERE2_EXTRA="WHERE s.datum >= '2015-02-28'" fi # run query if [ $1 -eq 1 ] ; then @@ -573,18 +576,6 @@ create_png_from_table() { sqlite3 -init ${INIT} -csv ${PACKAGES_DB} "SELECT datum, oldest_reproducible FROM ${TABLE[$1]} ${WHERE_EXTRA} ORDER BY datum" >> ${TABLE[$1]}.csv elif [ $1 -eq 7 ] ; then 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 - if [ "$ARCH" = "amd64" ] && [ "$SUITE" = "testing" ] ; then - # testing/amd64 was only build since... - WHERE2_EXTRA="WHERE s.datum >= '2015-03-08'" - elif [ "$ARCH" = "amd64" ] && [ "$SUITE" = "experimental" ] ; then - # experimental/amd64 was only build since... - WHERE2_EXTRA="WHERE s.datum >= '2015-02-28'" - fi - sqlite3 -init ${INIT} --nullvalue 0 -csv ${PACKAGES_DB} "SELECT s.datum, - (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 fi @@ -600,9 +591,6 @@ create_png_from_table() { fi local WIDTH=1920 local HEIGHT=960 - if [ $1 -eq 8 ] ; then - HEIGHT=480 - fi # only generate graph if the query returned data if [ $(cat ${TABLE[$1]}.csv | wc -l) -gt 1 ] ; then echo "Updating $2..." |