From 592c7c87336d6c7884dae4fc3c1ebda607cdc051 Mon Sep 17 00:00:00 2001 From: Sebastien Delafond Date: Thu, 10 Aug 2017 21:07:04 +0000 Subject: Give /tracker/status/release/stable the ability to filter on "ignored" & "postponed" no-dsa substates git-svn-id: svn+ssh://svn.debian.org/svn/secure-testing@54582 e39458fd-73e7-0310-bf30-c45bca0a0e42 --- lib/python/security_db.py | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) (limited to 'lib') diff --git a/lib/python/security_db.py b/lib/python/security_db.py index d059f3e7d1..f613d5e448 100644 --- a/lib/python/security_db.py +++ b/lib/python/security_db.py @@ -500,10 +500,14 @@ class DB: st.vulnerable AS vulnerable, (SELECT range_remote FROM nvd_data WHERE cve_name = st.bug_name) AS remote, - (EXISTS (SELECT * FROM package_notes_nodsa AS pnd + (SELECT comment FROM package_notes_nodsa AS pnd WHERE pnd.bug_name = st.bug_name AND pnd.package = sp.name - AND pnd.release = '%s')) AS no_dsa + AND pnd.release = '%s') AS no_dsa, + (SELECT reason FROM package_notes_nodsa AS pnd + WHERE pnd.bug_name = st.bug_name + AND pnd.package = sp.name + AND pnd.release = '%s') AS no_dsa_reason FROM source_package_status AS st, source_packages AS sp WHERE st.vulnerable > 0 AND sp.rowid = st.package AND sp.release = '%s' AND sp.subrelease = '' @@ -515,7 +519,7 @@ class DB: AND secst.bug_name = st.bug_name AND secst.package = secp.rowid), 0) ORDER BY sp.name, urgency_to_number(urgency), st.bug_name""" - % (name, nickname, nickname, nickname)) + % (name, nickname, nickname, nickname, nickname)) cursor.execute( """CREATE TEMPORARY VIEW debian_cve AS -- cgit v1.2.3