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 | e35cd35aada2c0ca461ad4f7a4542e49dc0a6f51 (patch) | |
| tree | aa5a455fc920e504ddd4dbd25121aa3f979b0102 /bin | |
| parent | 5744488aeb36816df043e29bf39daa246f51568f (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): |