show unimportant issues on the per-package pages (closes: #479727)

git-svn-id: svn+ssh://svn.debian.org/svn/secure-testing@16215 e39458fd-73e7-0310-bf30-c45bca0a0e42

1 files changed, 5 insertions, 4 deletions

diff --git a/lib/python/security_db.py b/lib/python/security_db.py
index 207051ee35..93808ccb7d 100644
--- a/lib/python/security_db.py
+++ b/lib/python/security_db.py
@@ -1665,7 +1665,7 @@ class DB:
             (pkg,))
         return flag
 
-    def getBugsForSourcePackage(self, cursor, pkg, vulnerable):
+    def getBugsForSourcePackage(self, cursor, pkg, vulnerable, unimportant):
         """Returns a generator for a list of (BUG, DESCRIPTION) pairs
         which have the requested status.  Only bugs affecting supported
         releases are returned."""
@@ -1678,7 +1678,8 @@ class DB:
             WHERE sp2.name = sp.name AND sp2.release = sp.release
             AND sp2.subrelease = 'security' AND sp2.archive = sp.archive
             AND st2.package = sp2.rowid AND st2.bug_name = st.bug_name
-            ORDER BY st2.vulnerable DESC), 1)) AS vulnerable
+            ORDER BY st2.vulnerable DESC), 1)) AS vulnerable,
+            st.urgency = 'unimportant' OR NOT vulnerable AS unimportant
             FROM source_packages AS sp, source_package_status AS st, bugs
             WHERE sp.name = ?
 	    AND sp.release IN ('lenny', 'squeeze', 'wheezy', 'sid')
@@ -1687,8 +1688,8 @@ class DB:
             AND bugs.name = st.bug_name
             AND bugs.name NOT LIKE 'DSA-%'
             GROUP BY bugs.name, bugs.description, sp.name)
-            WHERE vulnerable = ?
-            ORDER BY name""", (pkg, vulnerable))
+            WHERE vulnerable = ? AND unimportant = ?
+            ORDER BY name""", (pkg, vulnerable, unimportant))
 
     def getDSAsForSourcePackage(self, cursor, package):
         return cursor.execute(