[Git][qa/jenkins.debian.net][master] reproducible debian: add stats on how many packages have been built today so far

[Mattia Rizzolo (@mattia)]

Mattia Rizzolo pushed to branch master at Debian QA / jenkins.debian.net


Commits:
f8be3507 by Mattia Rizzolo at 2024-03-11T16:35:24+01:00
reproducible debian: add stats on how many packages have been built today so far

also slightly reorder the rows

Signed-off-by: Mattia Rizzolo <mattia at debian.org>

- - - - -


1 changed file:

- bin/reproducible_html_dashboard.sh


Changes:

=====================================
bin/reproducible_html_dashboard.sh
=====================================
@@ -417,14 +417,19 @@ write_build_performance_stats() {
 		write_page "<td>$MIN min., $SEC sec.</td>"
 	done
 
-	write_page "</tr><tr><td class=\"left\">packages tested on $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><tr><td class=\"left\">packages tested in the last 24h</td>"
+	write_page "</tr><tr><td class=\"left\">packages tested today ($(date -u +%Y-%m-%d))</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(*) 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>"
+	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'")
 		write_page "<td>$RESULT</td>"
 	done
 	write_page "</tr>"



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

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