[Git][qa/jenkins.debian.net][master] reproduce.d.n/stats: Link to tests.r-b.o

[Holger Levsen (@holger)]

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


Commits:
9b2d3771 by Jochen Sprickerhof at 2025-01-25T17:05:42+01:00
reproduce.d.n/stats: Link to tests.r-b.o

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

- - - - -


1 changed file:

- bin/rebuilderd_stats.py


Changes:

=====================================
bin/rebuilderd_stats.py
=====================================
@@ -90,10 +90,12 @@ def main() -> None:
     package_logs = dict()
     bad_packages = set()
     has_diffoscope = set()
-    for row in cu.execute("SELECT p.name, p.build_id, p.has_diffoscope FROM packages p WHERE p.status ='BAD'"):
+    src_package = dict()
+    for row in cu.execute("SELECT p.name, s.name, p.build_id, p.has_diffoscope FROM packages p JOIN pkgbases s ON s.id = p.pkgbase_id WHERE p.status ='BAD'"):
         bad_packages.add(row[0])
-        package_logs[row[0]] = int(row[1])
-        if row[2]:
+        package_logs[row[0]] = int(row[2])
+        src_package[row[0]] = row[1]
+        if row[3]:
             has_diffoscope.add(row[0])
     found_packages = {pkg for lst in messages_packages.values() for pkg in lst}
 
@@ -121,19 +123,19 @@ def main() -> None:
         )
     print("</table>")
 
-    def format_link(pkg):
-        link = f'<a href="https://{arch}.reproduce.debian.net/api/v0/builds/{package_logs.get(pkg, 0)}/log">{pkg}</a><a href="https://tracker.debian.org/pkg/{pkg}">🍥</a>'
-        if pkg in has_diffoscope:
-            return f'{link}<a href="https://{arch}.reproduce.debian.net/api/v0/builds/{package_logs.get(pkg, 0)}/diffoscope">💠</a>'
-        return link
-
     for message, packages in messages_packages.items():
         anchor = message.replace(" ", "-")
         message = sub(r'(#)([0-9]*)', r'https://bugs.debian.org/\2', message)
         message = sub(r'(https://[a-z.A-Z_0-9/]*)', r'<a href="\1">\1</a>', message)
         print(f'\n<h2 id="{anchor}">{message}</h2>')
         packages = sorted(packages, key=lambda pkg: package_logs.get(pkg, 0))
-        print("\n".join(format_link(pkg) for pkg in packages))
+        for pkg in packages:
+            print(f'<a href="https://{arch}.reproduce.debian.net/api/v0/builds/{package_logs.get(pkg, 0)}/log">{pkg}</a>', end='')
+            if pkg in has_diffoscope:
+                print(f'<a href="https://{arch}.reproduce.debian.net/api/v0/builds/{package_logs.get(pkg, 0)}/diffoscope">💠</a>', end='')
+            print(f'<a href="https://tracker.debian.org/pkg/{src_package[pkg]}">🍥</a>', end='')
+            print(f'<a href="https://tests.reproducible-builds.org/debian/rb-pkg/trixie/{arch}/{src_package[pkg]}.html">♻</a>', end='')
+            print(" ")
 
     print("<br/><br/><hr/><a href=\"https://salsa.debian.org/qa/jenkins.debian.net/-/blob/master/bin/rebuilderd_stats.py\">rebuilderd_stats.py<a/> - patches welcome.</main></body></html>")
 



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

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/9b2d377185ef38294a6fcd7bb6064ab376f88610
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/20250125/7d887775/attachment-0001.htm>