[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] reproducible Archlinux: include number of recent builds in the recent_builds.html page
Holger Levsen
gitlab at salsa.debian.org
Thu Oct 11 20:25:43 BST 2018
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>
More information about the Qa-jenkins-scm
mailing list