Author: fw Date: 2008-12-03 20:02:24 +0000 (Wed, 03 Dec 2008) New Revision: 10607 Modified: bin/tracker_service.py Log: bin/tracker_service.py: Add overview page for stable backports This compares the version numbers against unstable (instead of testing, which would be more appropriate), but it is better than nothing. Modified: bin/tracker_service.py ==================================================================--- bin/tracker_service.py 2008-12-03 19:59:09 UTC (rev 10606) +++ bin/tracker_service.py 2008-12-03 20:02:24 UTC (rev 10607) @@ -102,6 +102,8 @@ self.register(''source-package/*'', self.page_source_package) self.register(''binary-package/*'', self.page_binary_package) self.register(''status/release/stable'', self.page_status_release_stable) + self.register(''status/release/stable-backports'', + self.page_status_release_stable_backports) self.register(''status/release/testing'', self.page_status_release_testing) self.register(''status/release/unstable'', @@ -158,6 +160,8 @@ ''Vulnerable packages in the testing suite''), (''status/release/stable'', ''Vulnerable packages in the stable suite''), + (''status/release/stable-backports'', + ''Vulnerable packages in backports for stable''), (''status/dtsa-candidates'', "Candidates for DTSAs"), (''status/todo'', ''TODO items''), (''status/itp'', ''ITPs with potential security issues''), @@ -690,7 +694,8 @@ make_table(gen(), caption=("Package", "Bug", "Urgency", "Remote"))]) - def page_status_release_unstable(self, path, params, url): + def page_status_release_unstable_like(self, path, params, url, + rel, title): bf = BugFilter(params) def gen(): @@ -703,9 +708,9 @@ WHERE cve_name = st.bug_name) FROM source_package_status AS st, source_packages AS sp WHERE st.vulnerable AND st.urgency <> ''unimportant'' - AND sp.rowid = st.package AND sp.release = ''sid'' + AND sp.rowid = st.package AND sp.release = ? AND sp.subrelease = '''' - ORDER BY sp.name, st.bug_name"""): + ORDER BY sp.name, st.bug_name""", (rel,)): if bf.urgencyFiltered(urgency): continue if bf.remoteFiltered(remote): @@ -733,10 +738,8 @@ urgency = self.make_red(urgency) yield pkg_name, self.make_xref(url, bug_name), urgency, remote - - return self.create_page( - url, ''Vulnerable source packages in the unstable suite'', + url, title, [P("""Note that the list below is based on source packages. This means that packages are not listed here once a new, fixed source version has been uploaded to the archive, even @@ -746,6 +749,18 @@ make_table(gen(), caption=(''Package'', ''Bug'', ''Urgency'', ''Remote''))]) + def page_status_release_unstable(self, path, params, url): + return self.page_status_release_unstable_like( + path, params, url, + title=''Vulnerable source packages in the unstable suite'', + rel=''sid'') + + def page_status_release_stable_backports(self, path, params, url): + return self.page_status_release_unstable_like( + path, params, url, + title=''Vulnerable source packages among backports for stable'', + rel=''etch-backports'') + def page_status_dtsa_candidates(self, path, params, url): bf = BugFilter(params)