diff options
author | Holger Levsen <holger@layer-acht.org> | 2014-09-28 08:49:01 +0200 |
---|---|---|
committer | Holger Levsen <holger@layer-acht.org> | 2014-09-28 08:49:01 +0200 |
commit | fc02b5f033995b019cdc21a2d325ecd2720f131b (patch) | |
tree | 57a78fec0081b47391fa02c107c9f774f3422e57 | |
parent | d7be2f96d11650c9441b62b4dfbfc2e126c9cbf4 (diff) | |
download | jenkins.debian.net-fc02b5f033995b019cdc21a2d325ecd2720f131b.tar.xz |
reproducible: order problematic logs by date
-rwxr-xr-x | bin/reproducible_stats.sh | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/bin/reproducible_stats.sh b/bin/reproducible_stats.sh index d31f3b1c..aabe7c1c 100755 --- a/bin/reproducible_stats.sh +++ b/bin/reproducible_stats.sh @@ -12,11 +12,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 name" | xargs echo) +BAD=$(sqlite3 $PACKAGES_DB "SELECT name FROM source_packages WHERE status = \"unreproducible\" ORDER BY build_date" | 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 name" | xargs echo) +UGLY=$(sqlite3 $PACKAGES_DB "SELECT name FROM source_packages WHERE status = \"FTBFS\" ORDER BY build_date" | 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 name" | xargs echo) +SOURCELESS=$(sqlite3 $PACKAGES_DB "SELECT name FROM source_packages WHERE status = \"404\" ORDER BY build_date" | 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") |