diff options
author | Emilio Pozuelo Monfort <pochu@debian.org> | 2021-04-30 14:17:31 +0200 |
---|---|---|
committer | Emilio Pozuelo Monfort <pochu@debian.org> | 2021-04-30 14:31:02 +0200 |
commit | 53ebc0909d2672ed1dc501321520ba165df08465 (patch) | |
tree | 95ff6101c4b84fd255e40d982a5606c7d0ebc182 /bin | |
parent | b0c641ac53b60527df6f300de27f28c5acde1659 (diff) |
tracker_service: also sort CVEs on stable-like pages
Diffstat (limited to 'bin')
-rwxr-xr-x | bin/tracker_service.py | 6 |
1 files changed, 4 insertions, 2 deletions
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): |