[Git][qa/jenkins.debian.net][master] rdn stats: support FAIL packages in v1

[Holger Levsen (@holger)]

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


Commits:
752ecf0e by Jochen Sprickerhof at 2025-09-06T17:25:42+02:00
rdn stats: support FAIL packages in v1

(cherry picked from commit e66c76b6c403c34bf3cb3ada959b859f8a11ac5c)
Signed-off-by: Holger Levsen <holger at layer-acht.org>

- - - - -


1 changed file:

- bin/rebuilderd_stats.py


Changes:

=====================================
bin/rebuilderd_stats.py
=====================================
@@ -150,19 +150,18 @@ def main() -> None:
 
     messages_packages: dict[str, list] = {k: [] for k in error_messages.keys()}  # Preserve keys order
     total = 0
-    filter_release = ""
-    if args.release:
-        filter_release = f"AND s.release = '{args.release}'"
+
     if cu.execute("SELECT COUNT(name) FROM sqlite_schema WHERE name = 'rebuild_artifacts'").fetchall()[0][0] == 1:
         sql = (
             "SELECT a.name, s.name, r.id, l.build_log, d.diffoscope_log, a.id"
             " FROM rebuild_artifacts a"
             " LEFT JOIN diffoscope_logs d ON a.diffoscope_log_id = d.id"
-            " JOIN rebuilds r ON a.rebuild_id = r.id"
+            " RIGHT JOIN rebuilds r ON a.rebuild_id = r.id"
             " JOIN build_logs l ON r.build_log_id = l.id"
             " JOIN build_inputs i ON r.build_input_id = i.id"
             " JOIN source_packages s ON i.source_package_id = s.id"
-            f" WHERE a.status = 'BAD' AND s.seen_in_last_sync = True {filter_release} group by a.name HAVING r.id = MAX(r.id) ORDER BY r.built_at"
+            f" WHERE (a.status = 'BAD' OR r.status = 'FAIL') AND s.seen_in_last_sync = True AND s.release = '{args.release}'"
+            " GROUP BY a.name HAVING r.id = MAX(r.id) ORDER BY r.built_at"
         )
         api = "../api/v1"
     else:
@@ -172,9 +171,13 @@ def main() -> None:
             " WHERE p.status = 'BAD' ORDER BY p.build_id"
         )
         api = "api/v0"
+
     for name, src_name, build_id, build_log, diffoscope, diffoscope_id in cu.execute(sql):
         total += 1
 
+        if not name:
+            name = f"src:{src_name}"
+
         if build_id in cache:
             cache_new[build_id] = cache[build_id]
             message, difflen = cache[build_id]



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

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/752ecf0e9c66628b38815043d6f8a46ad4fe32f7
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/20250906/672f83cb/attachment-0001.htm>