From 53ebc0909d2672ed1dc501321520ba165df08465 Mon Sep 17 00:00:00 2001 From: Emilio Pozuelo Monfort Date: Fri, 30 Apr 2021 14:17:31 +0200 Subject: tracker_service: also sort CVEs on stable-like pages --- bin/tracker_service.py | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'bin') diff --git a/bin/tracker_service.py b/bin/tracker_service.py index 3065715a04..4092a58bd9 100755 --- a/bin/tracker_service.py +++ b/bin/tracker_service.py @@ -712,7 +712,8 @@ to improve our documentation and procedures, so feedback is welcome.""")])]) self.db.cursor().execute( """SELECT package, bug, section, urgency, vulnerable, remote, no_dsa, no_dsa_reason FROM %s_status - WHERE (bug LIKE 'CVE-%%' OR bug LIKE 'TEMP-%%')""" % release): + WHERE (bug LIKE 'CVE-%%' OR bug LIKE 'TEMP-%%') + ORDER BY package, bug COLLATE version""" % release): if bf.urgencyFiltered(urgency, vulnerable): continue if bf.remoteFiltered(remote): @@ -768,7 +769,8 @@ to improve our documentation and procedures, so feedback is welcome.""")])]) in self.db.cursor().execute( """SELECT package, bug, section, urgency, vulnerable, unstable_vulnerable, testing_security_fixed, remote, no_dsa - FROM testing_status"""): + FROM testing_status + ORDER BY package, bug COLLATE version"""): if bf.urgencyFiltered(urgency, vulnerable): continue if bf.remoteFiltered(remote): -- cgit v1.2.3