[Git][qa/jenkins.debian.net][master] reproducible performance stats: slightly change order of rows again

[Holger Levsen (@holger)]

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


Commits:
205dd86b by Holger Levsen at 2024-03-11T16:54:54+01:00
reproducible performance stats: slightly change order of rows again

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

- - - - -


1 changed file:

- bin/reproducible_html_dashboard.sh


Changes:

=====================================
bin/reproducible_html_dashboard.sh
=====================================
@@ -1,8 +1,8 @@
 #!/bin/bash
 # vim: set noexpandtab:
 
-# Copyright 2014-2023 Holger Levsen <holger at layer-acht.org>
-#         © 2015-2023 Mattia Rizzolo <mattia at mapreri.org>
+# Copyright 2014-2024 Holger Levsen <holger at layer-acht.org>
+#         © 2015-2024 Mattia Rizzolo <mattia at mapreri.org>
 # released under the GPLv2
 
 DEBUG=false
@@ -417,9 +417,9 @@ write_build_performance_stats() {
 		write_page "<td>$MIN min., $SEC sec.</td>"
 	done
 
-	write_page "</tr><tr><td class=\"left\">packages tested in the last 24h</td>"
+	write_page "</tr><tr><td class=\"left\">packages tested yesterday ($DATE)</td>"
 	for ARCH in ${ARCHS} ; do
-		RESULT=$(query_db "SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '$(date '+%Y-%m-%d %H:%M' -d '-1 days')' AND r.architecture='$ARCH'")
+		RESULT=$(query_db "SELECT COUNT(r.build_date) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE r.build_date::date = '$DATE' AND s.architecture='$ARCH'")
 		write_page "<td>$RESULT</td>"
 	done
 	write_page "</tr><tr><td class=\"left\">packages tested today ($(date -u +%Y-%m-%d))</td>"
@@ -427,9 +427,9 @@ write_build_performance_stats() {
 		RESULT=$(query_db "SELECT COUNT(*) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE r.build_date::date = '$(date -u +%Y-%m-%d)' AND s.architecture='$ARCH'")
 		write_page "<td>$RESULT</td>"
 	done
-	write_page "</tr><tr><td class=\"left\">packages tested yesterday ($DATE)</td>"
+	write_page "</tr><tr><td class=\"left\">packages tested in the last 24h</td>"
 	for ARCH in ${ARCHS} ; do
-		RESULT=$(query_db "SELECT COUNT(r.build_date) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE r.build_date::date = '$DATE' AND s.architecture='$ARCH'")
+		RESULT=$(query_db "SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '$(date '+%Y-%m-%d %H:%M' -d '-1 days')' AND r.architecture='$ARCH'")
 		write_page "<td>$RESULT</td>"
 	done
 	write_page "</tr>"



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

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/205dd86bd070037c104a1a0ffa8c9636cf965242
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/20240311/0f2f5e68/attachment-0001.htm>