[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] 2 commits: reproducible: update status

[Holger Levsen]

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


Commits:
4f7f5029 by Holger Levsen at 2019-01-25T20:25:17Z
reproducible: update status

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

- - - - -
ca89fba0 by Holger Levsen at 2019-01-25T20:25:44Z
reproducible Arch Linux: also include 3h mini-stat in irc message

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

- - - - -


2 changed files:

- TODO
- bin/reproducible_archlinux_scheduler.sh


Changes:

=====================================
TODO
=====================================
@@ -61,18 +61,16 @@ See link:https://jenkins.debian.net/userContent/about.html["about jenkins.debian
 
 === new nodes at OSUOSL
 
-* use those nodes, preliminary plan:
+* use those nodes,current plan:
 ** done: osuosl167: squid (only, atm)
 ** done: osuosl168: fdroid
 *** underused. the old system had 2 cores and 8gb ram
 *** shutdown pb7
-*** more cpu and ram for jenkins
 *** inform hans, also about better specs
-*** inform #osuosl
 ** done: osuosl169: archlinux
 ** done: osuosl170: archlinux (future)
-** osuosl171: openwrt, coreboot, netbsd, FIXME: opensuse/redhat
-** osuosl172: openwrt, coreboot, netbsd, FIXME: opensuse/redhat (future)
+** done: osuosl171: openwrt, coreboot, netbsd, FIXME: opensuse/redhat
+** done: osuosl172: openwrt, coreboot, netbsd, FIXME: opensuse/redhat (future)
 ** osuosl173: debian
 ** osuosl174: debian (future)
 * add to README 


=====================================
bin/reproducible_archlinux_scheduler.sh
=====================================
@@ -257,6 +257,16 @@ update_archlinux_repositories() {
 			msg_depwait404=""
 		fi
 		MESSAGE="${message}${msg_old}${msg_depwait404}, for $total scheduled out of $TOTAL."
+		# the next 3 lines could maybe do some refactoring. but then, all of this should be rewritten in python using templates...
+		DISTROID=$(query_db "SELECT id FROM distributions WHERE name='archlinux'")
+		MAXDATE="$(date -u +'%Y-%m-%d %H:%M' -d '3 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.distribution=$DISTROID
+				AND s.architecture='x86_64'
+				AND r.build_date > '$MAXDATE'")
+		MESSAGE="$MESSAGE ($RECENT builds in the last 3h)"
 		echo -n "$(date -u ) - "
 		irc_message archlinux-reproducible "$MESSAGE"
 	else



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/compare/847b0ffb111b2697a022f6514784df0b7197dc29...ca89fba050535fc879efebe8980bd6ad7ccbd607

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/compare/847b0ffb111b2697a022f6514784df0b7197dc29...ca89fba050535fc879efebe8980bd6ad7ccbd607
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/20190125/2e0aaef3/attachment-0001.html>