[Git][qa/jenkins.debian.net][master] 2 commits: improve language in comment

[Holger Levsen (@holger)]

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


Commits:
77dbf257 by Holger Levsen at 2024-04-21T17:34:04+02:00
improve language in comment

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

- - - - -
c88e08df by Holger Levsen at 2024-04-22T08:03:52+02:00
reproducible Debian breakages: add graph about the last 100 days only

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

- - - - -


2 changed files:

- bin/reproducible_html_breakages.py
- bin/reproducible_html_packages.py


Changes:

=====================================
bin/reproducible_html_breakages.py
=====================================
@@ -322,12 +322,12 @@ def _gen_files_html(header, entries):
     return html
 
 
-def create_breakages_graph(png_file, main_label):
+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 {table} ORDER BY datum".format(
-        fields=", ".join(columns), table=table)
+    query = " SELECT {fields} FROM (SELECT {fields} FROM {table} 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]
 
@@ -340,7 +340,7 @@ def create_breakages_graph(png_file, main_label):
 
         graph_command = os.path.join(BIN_PATH, "make_graph.py")
         y_label = "Amount (packages)"
-        log.info("Creating graph for stats_breakges.")
+        log.info("Creating graph " + png_file + " from " + table + ".")
         check_call([graph_command, csv_tmp_file, png_fullpath, '2', main_label,
                     y_label, '1920', '960'])
 
@@ -382,13 +382,19 @@ def gen_html():
     html += str(count_pkgs(without_dbd)) + ') or sometimes both.'
     # gather stats and add graph
     update_stats_breakages(count_pkgs(bad_dbd), count_pkgs(without_dbd))
+    png_file = 'stats_breakages_100d.png'
+    main_label = "source packages causing Diffoscope to timeout or crash in the last 100 days"
+    create_breakages_graph(png_file, main_label, 100)
+    html += '\n<br>'
+    html += '<a href="/debian/' + png_file + '"><img src="/debian/'
+    html += png_file + '" class="halfview" alt="' + main_label + '"></a>'
     png_file = 'stats_breakages.png'
-    main_label = "source packages causing Diffoscope to timeout and crash"
+    main_label = "source packages causing Diffoscope to timeout or crash"
     create_breakages_graph(png_file, main_label)
-    html += '<br> <a href="/debian/' + png_file + '"><img src="/debian/'
-    html += png_file + '" alt="' + main_label + '"></a>'
+    html += '<a href="/debian/' + png_file + '"><img src="/debian/'
+    html += png_file + '" class="halfview" alt="' + main_label + '"></a>'
     # link artifacts
-    html += '<br/> <a href="https://tests.reproducible-builds.org/debian/artifacts/">'
+    html += '\n<br/> <a href="https://tests.reproducible-builds.org/debian/artifacts/">'
     html += 'Artifacts diffoscope crashed</a> on are available for 48h for download.'
 
     html += _gen_packages_html('are marked as FTBR, but there is no ' +


=====================================
bin/reproducible_html_packages.py
=====================================
@@ -306,7 +306,7 @@ def gen_history_page(package, arch=None):
 
     context = {}
     try:
-        package.history[0]  # we don't care about the actual value, it jst need to exist
+        package.history[0]  # we don't care about the actual value, it just needs to exist
     except IndexError:
         context['arch'] = arch
     else:



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/compare/9138835ea0316dc47b6634706e305514253eacc6...c88e08dfd8b8e0251ebb81246dcc11b805a47cab

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/compare/9138835ea0316dc47b6634706e305514253eacc6...c88e08dfd8b8e0251ebb81246dcc11b805a47cab
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/20240422/a092473d/attachment-0001.htm>