From 043777c8c9ad12cdab22d726a4c6496a5057d087 Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Mon, 8 Feb 2016 20:04:36 +0100 Subject: reproducible debian: also show 24h node performance --- bin/reproducible_nodes_info.sh | 18 ++++++++++++------ 1 file 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 -- cgit v1.2.3-54-g00ecf