[Qa-jenkins-scm] [jenkins.debian.net] 01/01: reproducible: fix query for reproducible-tracker.json to correctly exclude packages in status 'not for us'

[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 7c8f3794c1494f126ebb1f17fe757ef35e46d032
Author: Holger Levsen <holger at layer-acht.org>
Date:   Sat Nov 14 19:43:31 2015 +0100

    reproducible: fix query for reproducible-tracker.json to correctly exclude packages in status 'not for us'
---
 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 82afb06..0200ded 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 IN ("not-for-us", "404", "blacklisted" ) AND (( status != "FTBFS" ) OR ' \
+        'WHERE status != "" AND status NOT IN ("not for us", "404", "blacklisted" ) 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