[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] 2 commits: reproducible Debian: move oldest stretch results to oldsuites page

[Holger Levsen]

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


Commits:
2545eba2 by Holger Levsen at 2020-01-27T15:58:55+01:00
reproducible Debian: move oldest stretch results to oldsuites page

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

- - - - -
d495b88f by Holger Levsen at 2020-01-27T15:59:35+01:00
reproducible Debian: refactor, sort properly

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

- - - - -


1 changed file:

- bin/reproducible_html_dashboard.sh


Changes:

=====================================
bin/reproducible_html_dashboard.sh
=====================================
@@ -337,14 +337,13 @@ write_build_performance_stats() {
 	for ARCH in ${ARCHS} ; do
 		write_page " <th>$ARCH</th>"
 	done
-	write_page "</tr><tr><td class=\"left\">oldest build result in stretch / buster / bullseye / unstable / experimental</td>"
+	write_page "</tr><tr><td class=\"left\">oldest build result in buster / bullseye / unstable / experimental</td>"
 	for ARCH in ${ARCHS} ; do
-		AGE_UNSTABLE=$(query_db "SELECT CAST(greatest(max(oldest_reproducible), max(oldest_FTBR), max(oldest_FTBFS)) AS INTEGER) FROM ${TABLE[2]} WHERE suite='unstable' AND architecture='$ARCH' AND datum='$DATE'")
-		AGE_EXPERIMENTAL=$(query_db "SELECT CAST(greatest(max(oldest_reproducible), max(oldest_FTBR), max(oldest_FTBFS)) AS INTEGER) FROM ${TABLE[2]} WHERE suite='experimental' AND architecture='$ARCH' AND datum='$DATE'")
-		AGE_STRETCH=$(query_db "SELECT CAST(greatest(max(oldest_reproducible), max(oldest_FTBR), max(oldest_FTBFS)) AS INTEGER) FROM ${TABLE[2]} WHERE suite='stretch' AND architecture='$ARCH' AND datum='$DATE'")
 		AGE_BUSTER=$(query_db "SELECT CAST(greatest(max(oldest_reproducible), max(oldest_FTBR), max(oldest_FTBFS)) AS INTEGER) FROM ${TABLE[2]} WHERE suite='buster' AND architecture='$ARCH' AND datum='$DATE'")
 		AGE_BULLSEYE=$(query_db "SELECT CAST(greatest(max(oldest_reproducible), max(oldest_FTBR), max(oldest_FTBFS)) AS INTEGER) FROM ${TABLE[2]} WHERE suite='bullseye' AND architecture='$ARCH' AND datum='$DATE'")
-		write_page "<td>$AGE_STRETCH / $AGE_BUSTER / $AGE_BULLSEYE / $AGE_UNSTABLE / $AGE_EXPERIMENTAL days</td>"
+		AGE_UNSTABLE=$(query_db "SELECT CAST(greatest(max(oldest_reproducible), max(oldest_FTBR), max(oldest_FTBFS)) AS INTEGER) FROM ${TABLE[2]} WHERE suite='unstable' AND architecture='$ARCH' AND datum='$DATE'")
+		AGE_EXPERIMENTAL=$(query_db "SELECT CAST(greatest(max(oldest_reproducible), max(oldest_FTBR), max(oldest_FTBFS)) AS INTEGER) FROM ${TABLE[2]} WHERE suite='experimental' AND architecture='$ARCH' AND datum='$DATE'")
+		write_page "<td>$AGE_BUSTER / $AGE_BULLSEYE / $AGE_UNSTABLE / $AGE_EXPERIMENTAL days</td>"
 	done
 	write_page "</tr><tr><td class=\"left\">Build jobs configured</td>"
 	for ARCH in ${ARCHS} ; do
@@ -662,6 +661,12 @@ create_oldsuites_page() {
 	ARCH="amd64"
 	write_meta_pkg_graphs_links
 	write_page "</p><p style=\"clear:both;\">"
+	write_page "</tr><tr><td class=\"left\">oldest build result in stretch</td>"
+	for ARCH in ${ARCHS} ; do
+		AGE_STRETCH=$(query_db "SELECT CAST(greatest(max(oldest_reproducible), max(oldest_FTBR), max(oldest_FTBFS)) AS INTEGER) FROM ${TABLE[2]} WHERE suite='stretch' AND architecture='$ARCH' AND datum='$DATE'")
+		write_page "<td>$AGE_STRETCH days</td>"
+	done
+	write_page "</tr></table>"
 	for ARCH in ${ARCHS} ; do
 		write_page " <a href=\"/debian/$SUITE/$ARCH/${TABLE[2]}.png\"><img src=\"/debian/$SUITE/$ARCH/${TABLE[2]}.png\" class=\"overview\" alt=\"age of oldest reproducible build result in $SUITE/$ARCH\"></a>"
 	done



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/compare/e5ebb1fa077c0e51616a64c5c4e053c3147150b2...d495b88fed951ff7db991275833a19de5044b812

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/compare/e5ebb1fa077c0e51616a64c5c4e053c3147150b2...d495b88fed951ff7db991275833a19de5044b812
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/20200127/6d78d2e2/attachment-0001.html>