From c8575052bf5e748590948e44a57e5f60a4120f8c Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Wed, 7 Oct 2015 03:48:25 +0200 Subject: reproducible: only graph pkg_to_fix since testing+experimental/amd64 are tested --- bin/reproducible_common.sh | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'bin') diff --git a/bin/reproducible_common.sh b/bin/reproducible_common.sh index d3e02e56..ef21e23b 100755 --- a/bin/reproducible_common.sh +++ b/bin/reproducible_common.sh @@ -574,6 +574,13 @@ create_png_from_table() { 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" ] + # testing/amd64 was only build since... + WHERE2_EXTRA="WHERE s.datum >= '2015-03-08'" + elif [ "$ARCH" = "amd64" ] && [ "SUITE" = "experimental" ] + # 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 -- cgit v1.2.3-54-g00ecf