security_db: don't hardcode the list of supported releases

At times there will just be two, so get that list from the
config.

1 files changed, 6 insertions, 5 deletions

diff --git a/lib/python/security_db.py b/lib/python/security_db.py
index a4281274a7..f77710ef5e 100644
--- a/lib/python/security_db.py
+++ b/lib/python/security_db.py
@@ -496,11 +496,12 @@ class DB:
             ORDER BY sp.name, st.urgency, st.bug_name"""
             % (testing, testing, testing))
 
-        releases = (('stable', config.get_release_codename('stable')),
-                    ('oldstable', config.get_release_codename('oldstable')),
-                    ('oldoldstable', config.get_release_codename('oldoldstable')))
+        releases = config.get_supported_releases()
+        releases.remove(config.get_release_codename('testing'))
+        releases.remove('sid')
 
-        for (name, nickname) in releases:
+        for release in releases:
+            alias = config.get_release_alias(release)
             cursor.execute(
                 """CREATE TEMPORARY VIEW %s_status AS
                 SELECT DISTINCT sp.name AS package, st.bug_name AS bug,
@@ -527,7 +528,7 @@ class DB:
                 AND secst.bug_name = st.bug_name
                 AND secst.package = secp.rowid), 0)
                 ORDER BY sp.name, urgency_to_number(urgency), st.bug_name"""
-                % (name, nickname, nickname, nickname, nickname))
+                % (alias, release, release, release, release))
 
         cursor.execute(
             """CREATE TEMPORARY VIEW debian_cve AS