#!/bin/bash
+#set -x
#configuration
TODAY=`date +%Y%m%d`
SHELLADDERPHP=scripts/shell_adder.php
COMMONPHP=scripts/public_html/common.php
MYSQL="mysql -u helm -h mowgli.cs.unibo.it matita"
-SQLQMARK="select distinct mark from bench where mark like '"
-SQLQORD="' order by mark;"
-SQLQTIME="select SUM(timeuser) from bench where mark = \""
-SQLQGRMARK="\" group by mark;"
-SQLQFAIL="select count(distinct test) from bench where mark = \""
-SQLQFAIL1="select distinct test from bench where mark = \""
-SQLQFAIL2="\" and result = 'fail';"
-URL="http://mowgli.cs.unibo.it/~tassi/bench.php"
+SQLQMARK="select distinct mark from bench where mark like '%s%%' order by mark;"
+SQLQTIME="select SUM(timeuser) from bench where mark = '%s' group by mark;"
+SQLQFAILCOUNT="select count(distinct test) from bench where mark = '%s' and result = 'fail';"
+SQLQFAIL="select distinct test from bench where mark = '%s' and result = 'fail';"
+URL="http://mowgli.cs.unibo.it/~sacerdot/bench.php"
#initialization
OLD=$PWD
#run tests
scripts/profile_svn.sh 2> LOG
-MARK=`echo $SQLQMARK$TODAY%$SQLQORD | $MYSQL | tail -n 1`
-LASTMARK=`echo $SQLQMARK$YESTERDAY%$SQLQORD | $MYSQL | tail -n 1`
+MARK=`printf "$SQLQMARK" "$TODAY" | $MYSQL | tail -n 1`
+LASTMARK=`printf "$SQLQMARK" "$YESTERDAY" | $MYSQL | tail -n 1`
if [ -z "$MARK" ]; then
echo "No benchmark records for $TODAY"
fi
#check for slowdown
-CUR_TIME=`echo $SQLQTIME$MARK$SQLQGRMARK | $MYSQL`
-OLD_TIME=`echo $SQLQTIME$LASTMARK$SQLQGRMARK | $MYSQL`
+CUR_TIME=`printf "$SQLQTIME" "$MARK" | $MYSQL | tail -n 1`
+OLD_TIME=`printf "$SQLQTIME" "$LASTMARK" | $MYSQL | tail -n 1`
-((DELTA=$CUR_CENTS-$OLD_CENTS))
-if [ $DELTA -lt 0 ]; then
+if [ -z "$CUR_TIME" -o -z "$OLD_TIME" ]; then
+ cat <<EOT
+
+ Unable to calculate total time amounts:
+
+ `printf "$SQLQTIME" "$MARK"`
+
+ or
+
+ `printf "$SQLQTIME" "$LASTMARK"`
+
+ gave an empty result
+
+EOT
+fi
+
+((DELTA= $CUR_TIME - $OLD_TIME))
+if [ "$DELTA" -lt 0 ]; then
PERC=0
else
- PREC=`scripts/functions.lua proportion $DELTA x $OLD_CENTS 100`
+ PERC=`lua5.1 scripts/functions.lua proportion $DELTA x $OLD_TIME 100`
fi
-if [ $PERC -ge 5 ]; then
+if [ "$PERC" -ge 5 ]; then
cat <<EOT
- PERFORMANCE LOSS DETECTED (MARK $MARK vs MARK $LASTMARK)
+ Performance loss detected (MARK $MARK vs MARK $LASTMARK)
- Is `scripts/functions.lua t2s $CUR_TIME`
-
- Was `scripts/functions.lua t2s $OLD_TIME`
+ Is: `lua5.1 scripts/functions.lua t2s $CUR_TIME`
+ Was: `lua5.1 scripts/functions.lua t2s $OLD_TIME`
For details: $URL
EOT
fi
#check for more broken tests
-CUR_FAIL=`echo $SQLQFAIL$MARK$SQLQFAIL2 | $MYSQL`
-OLD_FAIL=`echo $SQLQFAIL$LASTMARK$SQLQFAIL2 | $MYSQL`
+CUR_FAIL=`printf "$SQLQFAILCOUNT" "$MARK" | $MYSQL | tail -n 1`
+OLD_FAIL=`printf "$SQLQFAILCOUNT" "$LASTMARK" | $MYSQL | tail -n 1`
+
+if [ "$CUR_FAIL" -gt "$OLD_FAIL" ]; then
+ TMP1=`mktemp`
+ TMP2=`mktemp`
+ TMP3=`mktemp`
+ printf "$SQLQFAIL" "$MARK" | $MYSQL > $TMP1
+ printf "$SQLQFAIL" "$LASTMARK" | $MYSQL > $TMP2
+ combine $TMP1 not $TMP2 > $TMP3
-if [ $CUR_FAIL -gt $OLD_FAIL ]; then
cat <<EOT
- MORE BROKEN TESTS DETECTED (MARK $MARK vs MARK $LASTMARK)
-
- Now broken:
-`echo $SQLQFAIL1$MARK$SQLQFAIL2 | $MYSQL`
+ More broken tests detected (MARK $MARK vs MARK $LASTMARK)
+ Is: $CUR_FAIL
+ Was: $OLD_FAIL
+
+ Tests that are broken in $MARK but where not broken in $LASTMARK:
+`cat $TMP3`
+
+ List of broken tests in mark $MARK:
+`cat $TMP1`
- Were broken:
-`echo $SQLQFAIL1$LASTMARK$SQLQFAIL2 | $MYSQL`
+ List of broken tests in old mark $LASTMARK:
+`cat $TMP2`
For details: $URL
EOT
+ rm $TMP1 $TMP2 $TMP3
fi
cd $OLD