Secure testing commits - Dec 2006 - r5101 - lib/python

Author: fw
Date: 2006-12-10 18:44:41 +0100 (Sun, 10 Dec 2006)
New Revision: 5101

Modified:
   lib/python/security_db.py
Log:
lib/python/security_db.py (DB.getBugsForBinaryPackage,
    DB.getBugsForSourcePackage):
  Ignore bugs in woody.


Modified: lib/python/security_db.py
==================================================================---
lib/python/security_db.py	2006-12-10 17:35:42 UTC (rev 5100)
+++ lib/python/security_db.py	2006-12-10 17:44:41 UTC (rev 5101)
@@ -1775,7 +1775,9 @@
             AND st2.package = sp2.rowid AND st2.bug_name = st.bug_name
             ORDER BY st2.vulnerable DESC), 1)) AS vulnerable
             FROM source_packages AS sp, source_package_status AS st, bugs
-            WHERE sp.name = ? AND sp.subrelease <>
''security''
+            WHERE sp.name = ?
+	    AND sp.release <> ''woody''
+	    AND sp.subrelease <> ''security''
             AND st.package = sp.rowid
             AND bugs.name = st.bug_name
             AND st.urgency <> ''unimportant''
@@ -1791,7 +1793,9 @@
             FROM (SELECT bugs.name AS name, bugs.description AS description,
             MAX(st.vulnerable) AS vulnerable
             FROM binary_packages AS bp, binary_package_status AS st, bugs
-            WHERE bp.name = ? AND st.package = bp.rowid
+            WHERE bp.name = ?
+	    AND bp.release <> ''woody'' 
+	    AND st.package = bp.rowid
             AND st.urgency <> ''unimportant''
             AND bugs.name = st.bug_name
             GROUP BY bugs.name, bugs.description)