Author: fw
Date: 2005-12-27 15:08:37 +0000 (Tue, 27 Dec 2005)
New Revision: 3166
Modified:
bin/tracker_service.py
Log:
bin/tracker_service.py (TrackerService.page_data_latently_vulnerable):
Report on "unimportant" urgency.
Modified: bin/tracker_service.py
==================================================================---
bin/tracker_service.py 2005-12-27 13:59:04 UTC (rev 3165)
+++ bin/tracker_service.py 2005-12-27 15:08:37 UTC (rev 3166)
@@ -830,6 +830,30 @@
bugs = bugs.split('','')
yield pkg, self.make_xref_list(url, bugs)
+ def gen_unimportant():
+ for pkg, bugs in self.db.cursor().execute(
+ """SELECT package, string_set(bug_name)
+ FROM package_notes AS p1
+ WHERE release <> ''''
+ AND urgency <> ''unimportant''
+ AND (bug_name LIKE ''CVE-%'' OR bug_name LIKE
''FAKE-%'')
+ AND EXISTS (SELECT 1 FROM package_notes AS p2
+ WHERE p2.bug_name = p1.bug_name
+ AND p2.package = p1.package
+ AND release = '''')
+ AND NOT EXISTS (SELECT 1 FROM package_notes AS p2
+ WHERE p2.bug_name = p1.bug_name
+ AND p2.package = p1.package
+ AND urgency <>
''unimportant''
+ AND release = '''')
+ AND EXISTS (SELECT 1 FROM source_packages
+ WHERE name = p1.package AND release =
''sid'')
+ GROUP BY package
+ ORDER BY package"""):
+ pkg = self.make_source_package_ref(url, pkg)
+ bugs = bugs.split('','')
+ yield pkg, self.make_xref_list(url, bugs)
+
return self.create_page(
url, "Latently vulnerable packages in unstable",
[P(
@@ -839,7 +863,16 @@
unstable, of course)."""),
make_table(gen(),
caption=("Package", "Bugs"),
- replacement="No latently vulnerable packages were
found.")])
+ replacement="No latently vulnerable packages were
found."),
+ P(
+"""The next table lists issues which are marked unimportant for
+unstable, but for which release-specific annotations exist which are
+not unimportant."""),
+ make_table(gen_unimportant(),
+ caption=("Package", "Bugs"),
+ replacement+ "No packages with unimportant latent
vulnerabilities were found."),
+ ])
def page_data_releases(self, path, params, url):
def gen():