[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] reproducible Archlinux: include number of recent builds in the recent_builds.html page

[Holger Levsen]

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


Commits:
c30aaa7e by Holger Levsen at 2018-10-11T19:25:31Z
reproducible Archlinux: include number of recent builds in the recent_builds.html page

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

- - - - -


2 changed files:

- TODO
- bin/reproducible_html_archlinux.sh


Changes:

=====================================
TODO
=====================================
@@ -327,10 +327,10 @@ See link:https://jenkins.debian.net/userContent/about.html["about jenkins.debian
 ** misc:
 *** write into all the stats_ tables
 *** make build.sh respect pacman exit code, see FIXME in _html_.sh
-*** comparing versions (in scheduler) is probably needed: if its not empty it must be higher (due to repo constraints), but it can be even higher than in the repo, because we build trunk
+*** comparing versions (in scheduler) is probably needed (though it wuld be better if not): if its not empty it must be higher (due to repo constraints), but it can be even higher than in the repo, because we build trunk
 *** debian uses a table removed_packages, should this be used here too?
 *** debian uses a table manual_scheduler to limit the amount of packages someone can schedule per day...
-*** should breakages job look for archlinux breakages? for which case
+*** should breakages job look for archlinux breakages? for which cases?
 ** using notes.git could be next
 
 * rebuilding against the archlinux repos


=====================================
bin/reproducible_html_archlinux.sh
=====================================
@@ -353,9 +353,14 @@ recent_builds_page(){
 	TITLE="Reproducible archlinux, builds in the last 24h"
 	archlinux_page_header
 	archlinux_repostats_table
-	write_page "<h2>Recent builds of Archlinux packages in the last 24h</h2>"
-	include_pkg_table_header_in_page
 	MAXDATE="$(date -u +'%Y-%m-%d %H:%M' -d '24 hours ago')"
+	RECENT=$(query_db "SELECT count(s.name) FROM sources AS s
+				JOIN results AS r
+				ON s.id=r.package_id
+				WHERE s.architecture='x86_64'
+				AND r.build_date > '$MAXDATE'")
+	write_page "<h2>$RECENT builds of Archlinux packages in the last 24h</h2>"
+	include_pkg_table_header_in_page
 	STATE_PKGS=$(query_db "SELECT s.name FROM sources AS s
 				JOIN results AS r
 				ON s.id=r.package_id



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

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/c30aaa7e1bfe1181d2db6cbefe5210a55daf7158
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/20181011/8109f84f/attachment-0001.html>