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.

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

1 files changed, 21 insertions, 6 deletions

diff --git a/bin/tracker_service.py b/bin/tracker_service.py
index d922e88190..db482a0678 100644
--- a/bin/tracker_service.py
+++ b/bin/tracker_service.py
@@ -102,6 +102,8 @@ function onSearch(query) {
         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 @@ aware of and/or help us improve the quality of this information by """,
              '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 @@ for this vulnerability.)''')])
              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 @@ for this vulnerability.)''')])
                  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 @@ for this vulnerability.)''')])
                     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 @@ for this vulnerability.)''')])
              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)