diff options
| author | Sebastien Delafond <seb@debian.org> | 2017-08-10 21:07:04 +0000 |
|---|---|---|
| committer | Sebastien Delafond <seb@debian.org> | 2017-08-10 21:07:04 +0000 |
| commit | 592c7c87336d6c7884dae4fc3c1ebda607cdc051 (patch) | |
| tree | f2d87df8360264fa867f90be344786aae4b7d374 /lib | |
| parent | 940e46b5cfbab19692334777e4f47103c6b85c49 (diff) | |
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
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/python/security_db.py | 10 |
1 files changed, 7 insertions, 3 deletions
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 |