summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorHolger Levsen <holger@layer-acht.org>2016-02-08 20:04:36 +0100
committerHolger Levsen <holger@layer-acht.org>2016-02-08 20:04:36 +0100
commit043777c8c9ad12cdab22d726a4c6496a5057d087 (patch)
tree7faeea0b46203da60c4a7066608cd4a54f16f734
parent410d20bd3db3436244da2468b2388102f7778aba (diff)
downloadjenkins.debian.net-043777c8c9ad12cdab22d726a4c6496a5057d087.tar.xz
reproducible debian: also show 24h node performance
-rwxr-xr-xbin/reproducible_nodes_info.sh18
1 files changed, 12 insertions, 6 deletions
diff --git a/bin/reproducible_nodes_info.sh b/bin/reproducible_nodes_info.sh
index 1c6b1f9b..132267cd 100755
--- a/bin/reproducible_nodes_info.sh
+++ b/bin/reproducible_nodes_info.sh
@@ -48,16 +48,22 @@ echo
echo "$(date -u) - Showing node performance:"
TMPFILE1=$(mktemp)
TMPFILE2=$(mktemp)
+TMPFILE3=$(mktemp)
+NOW=$(date -u '+%Y-%m-%d %H:%m')
for i in $BUILD_NODES ; do
sqlite3 -init $INIT ${PACKAGES_DB} \
- "SELECT build_date FROM stats_build AS r WHERE r.node1=\"$i\" or r.node2=\"$i\"" > $TMPFILE1 2>/dev/null
- j=$(wc -l $TMPFILE1|cut -d " " -f1)
- k=$(cat $TMPFILE1|cut -d " " -f1|sort -u|wc -l)
- l=$(echo "scale=1 ; ($j/$k)" | bc)
- echo "$l builds/day ($j/$k) on $i" >> $TMPFILE2
+ "SELECT build_date FROM stats_build AS r WHERE ( r.node1=\"$i\" OR r.node2=\"$i\" )" > $TMPFILE1 2>/dev/null
+ j=$(wc -l $TMPFILE1|cut -d " " -f1)
+ k=$(cat $TMPFILE1|cut -d " " -f1|sort -u|wc -l)
+ l=$(echo "scale=1 ; ($j/$k)" | bc)
+ echo "$l builds/day ($j/$k) on $i" >> $TMPFILE2
+ m=$(sqlite3 -init $INIT ${PACKAGES_DB} "SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1=\"$i\" OR r.node2=\"$i\" ) AND r.build_date > datetime('$NOW', '-24 hours') " 2>/dev/null)
+ echo "$m builds in the last 24h on $i" >> $TMPFILE3
done
rm $TMPFILE1 >/dev/null
sort -g -r $TMPFILE2
-rm $TMPFILE2 >/dev/null
+echo
+sort -g -r $TMPFILE3
+rm $TMPFILE2 $TMPFILE3 >/dev/null
echo