[Qa-jenkins-scm] [jenkins.debian.net] 01/02: reproducible: order by architecture too

[Holger Levsen]

This is an automated email from the git hooks/post-receive script.

holger pushed a commit to branch master
in repository jenkins.debian.net.

commit 8357261a1c103300f2c4351c7370c5859009c4ba
Author: Holger Levsen <holger at layer-acht.org>
Date:   Tue Sep 22 21:07:55 2015 +0200

    reproducible: order by architecture too
---
 bin/reproducible_html_breakages.py | 18 +++++++++---------
 1 file changed, 9 insertions(+), 9 deletions(-)

diff --git a/bin/reproducible_html_breakages.py b/bin/reproducible_html_breakages.py
index fd64456..b8d42e0 100755
--- a/bin/reproducible_html_breakages.py
+++ b/bin/reproducible_html_breakages.py
@@ -18,7 +18,7 @@ def unrep_with_dbd_issues():
     query = '''SELECT s.name, r.version, s.suite, s.architecture
                FROM sources AS s JOIN results AS r ON r.package_id=s.id
                WHERE r.status="unreproducible"
-               ORDER BY s.name ASC, s.suite DESC'''
+               ORDER BY s.name ASC, s.suite DESC, s.architecture ASC'''
     results = query_db(query)
     for pkg, version, suite, arch in results:
         eversion = strip_epoch(version)
@@ -45,7 +45,7 @@ def not_unrep_with_dbd_file():
     query = '''SELECT s.name, r.version, s.suite, s.architecture
                FROM sources AS s JOIN results AS r ON r.package_id=s.id
                WHERE r.status != "unreproducible"
-               ORDER BY s.name ASC, s.suite DESC'''
+               ORDER BY s.name ASC, s.suite DESC, s.architecture ASC'''
     results = query_db(query)
     for pkg, version, suite, arch in results:
         eversion = strip_epoch(version)
@@ -64,7 +64,7 @@ def lack_rbuild():
     query = '''SELECT s.name, r.version, s.suite, s.architecture
                FROM sources AS s JOIN results AS r ON r.package_id=s.id
                WHERE r.status NOT IN ("blacklisted", "")
-               ORDER BY s.name ASC, s.suite DESC'''
+               ORDER BY s.name ASC, s.suite DESC, s.architecture ASC'''
     results = query_db(query)
     for pkg, version, suite, arch in results:
         if not pkg_has_rbuild(pkg, version, suite, arch):
@@ -81,7 +81,7 @@ def lack_buildinfo():
                FROM sources AS s JOIN results AS r ON r.package_id=s.id
                WHERE r.status NOT IN
                 ("blacklisted", "not for us", "FTBFS", "depwait", "404", "")
-               ORDER BY s.name ASC, s.suite DESC'''
+               ORDER BY s.name ASC, s.suite DESC, s.architecture ASC'''
     results = query_db(query)
     for pkg, version, suite, arch in results:
         eversion = strip_epoch(version)
@@ -103,7 +103,7 @@ def pbuilder_dep_fail():
     query = '''SELECT s.name, r.version, s.suite, s.architecture
                FROM sources AS s JOIN results AS r ON r.package_id=s.id
                WHERE r.status = "FTBFS" AND s.suite = "testing"
-               ORDER BY s.name ASC, s.suite DESC'''
+               ORDER BY s.name ASC, s.suite DESC, s.architecture ASC'''
     results = query_db(query)
     for pkg, version, suite, arch in results:
         eversion = strip_epoch(version)
@@ -131,7 +131,7 @@ def alien_log(directory=None):
                FROM sources AS s JOIN results AS r ON r.package_id=s.id
                WHERE r.status != "" AND s.name="{pkg}" AND s.suite="{suite}"
                AND s.architecture="{arch}"
-               ORDER BY s.name ASC, s.suite DESC'''
+               ORDER BY s.name ASC, s.suite DESC, s.architecture ASC'''
     bad_files = []
     for root, dirs, files in os.walk(directory):
         if not files:
@@ -158,7 +158,7 @@ def alien_buildinfo():
                WHERE r.status != "" AND s.name="{pkg}" AND s.suite="{suite}"
                AND s.architecture="{arch}"
                AND r.status IN ("reproducible", "unreproducible")
-               ORDER BY s.name ASC, s.suite DESC'''
+               ORDER BY s.name ASC, s.suite DESC, s.architecture ASC'''
     bad_files = []
     for root, dirs, files in os.walk(BUILDINFO_PATH):
         if not files:
@@ -189,7 +189,7 @@ def alien_dbd(directory=None):
                FROM sources AS s JOIN results AS r on r.package_id=s.id
                WHERE s.name="{pkg}" AND s.suite="{suite}"
                AND s.architecture="{arch}"
-               ORDER BY s.name ASC, s.suite DESC'''
+               ORDER BY s.name ASC, s.suite DESC, s.architecture ASC'''
     bad_files = []
     for root, dirs, files in os.walk(directory):
         if not files:
@@ -223,7 +223,7 @@ def alien_rbpkg():
                FROM sources AS s
                WHERE s.name="{pkg}" AND s.suite="{suite}"
                AND s.architecture="{arch}"
-               ORDER BY s.name ASC, s.suite DESC'''
+               ORDER BY s.name ASC, s.suite DESC, s.architecture ASC'''
     bad_files = []
     for root, dirs, files in os.walk(RB_PKG_PATH):
         if not files:

-- 
Alioth's /usr/local/bin/git-commit-notice on /srv/git.debian.org/git/qa/jenkins.debian.net.git