[Git][qa/jenkins.debian.net][master] fixup³: tests.r-b.o/debian: ignore i386 when cross-checking db and fs for breakage

[Holger Levsen (@holger)]

Holger Levsen pushed to branch master at Debian QA / jenkins.debian.net


Commits:
12436370 by Holger Levsen at 2025-05-25T23:56:46+02:00
fixup³: tests.r-b.o/debian: ignore i386 when cross-checking db and fs for breakage

Signed-off-by: Holger Levsen <holger at layer-acht.org>

- - - - -


1 changed file:

- bin/reproducible_html_breakages.py


Changes:

=====================================
bin/reproducible_html_breakages.py
=====================================
@@ -291,7 +291,7 @@ def alien_rbpkg():
 
 def alien_history():
     log.info('running alien_history check...')
-    result = query_db('SELECT DISTINCT name FROM sources WHERE NOT s.architecture="i386"')
+    result = query_db('SELECT DISTINCT name FROM sources WHERE s.architecture != "i386"')
 
     actual_packages = [x[0] for x in result]
     bad_files = []
@@ -334,7 +334,7 @@ def create_breakages_graph(png_file, main_label, limit=100000):
     png_fullpath = os.path.join(DISTRO_BASE, png_file)
     table = "stats_breakages"
     columns = ["datum", "diffoscope_timeouts", "diffoscope_crashes"]
-    query = " SELECT {fields} FROM (SELECT {fields} FROM {table} WHERE NOT s.architecture='i386' ORDER BY datum DESC LIMIT {limit} ) {table} ORDER BY datum ASC".format(
+    query = " SELECT {fields} FROM (SELECT {fields} FROM {table} WHERE s.architecture != 'i386' ORDER BY datum DESC LIMIT {limit} ) {table} ORDER BY datum ASC".format(
         fields=", ".join(columns), table=table, limit=limit)
     result = query_db(query)
     result_rearranged = [dict(zip(columns, row)) for row in result]



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/124363703f74a055705fc23bc7143549e3f70061

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/124363703f74a055705fc23bc7143549e3f70061
You're receiving this email because of your account on salsa.debian.org.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/qa-jenkins-scm/attachments/20250525/9eb51a1d/attachment-0001.htm>