[Qa-jenkins-scm] [jenkins.debian.net] 01/02: reproducible: also exclude 404 packages from the json, cause they are usually problems on our side

[Holger Levsen]

This is an automated email from the git hooks/post-receive script.

holger pushed a commit to branch master
in repository jenkins.debian.net.

commit 01826d9a4924a1e78c33d19b4deb833cd4c8f3b3
Author: Holger Levsen <holger at layer-acht.org>
Date:   Sun Sep 13 15:06:48 2015 +0200

    reproducible: also exclude 404 packages from the json, cause they are usually problems on our side
---
 bin/reproducible_json.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/bin/reproducible_json.py b/bin/reproducible_json.py
index 59c69a8..32a90a6 100755
--- a/bin/reproducible_json.py
+++ b/bin/reproducible_json.py
@@ -25,7 +25,7 @@ log.info('Creating json dump of current reproducible status')
 # filter_query is defined in reproducible_common.py and excludes some FTBFS issues
 query = 'SELECT s.name, r.version, s.suite, s.architecture, r.status, r.build_date ' + \
         'FROM results AS r JOIN sources AS s ON r.package_id = s.id '+ \
-        'WHERE status != "" AND status != "not-for-us" AND (( status != "FTBFS" ) OR ' \
+        'WHERE status != "" AND status NOT IN ("not-for-us", "404" ) AND (( status != "FTBFS" ) OR ' \
         ' ( status = "FTBFS" and r.package_id NOT IN (SELECT n.package_id FROM NOTES AS n WHERE ' + filter_query + ' )))'
 
 result = sorted(query_db(query))

-- 
Alioth's /usr/local/bin/git-commit-notice on /srv/git.debian.org/git/qa/jenkins.debian.net.git