From 1b9c4741e886afe5f2bf6a4583d977bac225bdad Mon Sep 17 00:00:00 2001 From: Emilio Pozuelo Monfort Date: Tue, 3 Dec 2019 14:54:55 +0100 Subject: security_db: don't hardcode the list of supported releases At times there will just be two, so get that list from the config. --- lib/python/security_db.py | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'lib') 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 -- cgit v1.2.3