summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorHolger Levsen <holger@layer-acht.org>2015-05-03 14:27:32 +0200
committerHolger Levsen <holger@layer-acht.org>2015-05-03 14:27:32 +0200
commit5d51da46d2fa84d5db4d0faa644b71fddd01cb64 (patch)
treeaffad94f08e6021a2d18ae226d61fdf4b3fd0c9d
parent375f8e7ce66fb4670e0432dd1b8a1fce0ce10c5c (diff)
downloadjenkins.debian.net-5d51da46d2fa84d5db4d0faa644b71fddd01cb64.tar.xz
reproducible: sort breakage by package names and suites
-rwxr-xr-xbin/reproducible_breakages.py21
1 files changed, 14 insertions, 7 deletions
diff --git a/bin/reproducible_breakages.py b/bin/reproducible_breakages.py
index 653726a5..0fe6155a 100755
--- a/bin/reproducible_breakages.py
+++ b/bin/reproducible_breakages.py
@@ -25,7 +25,8 @@ def unrep_with_dbd_issues():
bad_dbd = []
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"'''
+ WHERE r.status="unreproducible"
+ ORDER BY s.name ASC, s.suite DESC'''
results = query_db(query)
for pkg, version, suite, arch in results:
eversion = strip_epoch(version)
@@ -51,7 +52,8 @@ def not_unrep_with_dbd_file():
bad_pkgs = []
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"'''
+ WHERE r.status != "unreproducible"
+ ORDER BY s.name ASC, s.suite DESC'''
results = query_db(query)
for pkg, version, suite, arch in results:
eversion = strip_epoch(version)
@@ -69,7 +71,8 @@ def lack_rbuild():
bad_pkgs = []
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 != "" AND r.status != "blacklisted"'''
+ WHERE r.status != "" AND r.status != "blacklisted"
+ ORDER BY s.name ASC, s.suite DESC'''
results = query_db(query)
for pkg, version, suite, arch in results:
eversion = strip_epoch(version)
@@ -87,7 +90,8 @@ def pbuilder_dep_fail():
bad_pkgs = []
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"'''
+ WHERE r.status = "FTBFS"
+ ORDER BY s.name ASC, s.suite DESC'''
results = query_db(query)
for pkg, version, suite, arch in results:
eversion = strip_epoch(version)
@@ -109,7 +113,8 @@ def alien_rbuild():
query = '''SELECT s.name
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}"'''
+ AND s.architecture="{arch}"
+ ORDER BY s.name ASC, s.suite DESC'''
bad_files = []
for root, dirs, files in os.walk(RBUILD_PATH):
if not files:
@@ -133,7 +138,8 @@ def alien_dbd():
query = '''SELECT r.status
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}"'''
+ AND s.architecture="{arch}"
+ ORDER BY s.name ASC, s.suite DESC'''
bad_files = []
for root, dirs, files in os.walk(DBD_PATH):
if not files:
@@ -166,7 +172,8 @@ def alien_rbpkg():
query = '''SELECT s.name
FROM sources AS s
WHERE s.name="{pkg}" AND s.suite="{suite}"
- AND s.architecture="{arch}"'''
+ AND s.architecture="{arch}"
+ ORDER BY s.name ASC, s.suite DESC'''
bad_files = []
for root, dirs, files in os.walk(RB_PKG_PATH):
if not files: