X-Git-Url: http://matita.cs.unibo.it/gitweb/?a=blobdiff_plain;f=helm%2Fsoftware%2Fmatita%2Fscripts%2Fcrontab.sh;h=06cb81654aaa69600992ee60a636ee291be370be;hb=5b584922369c076f9925a1598a7a9fe65708a44f;hp=f2a0283c084ce845e170c460eeb5c54e66805fa7;hpb=42a95fc3a4fc85d129cd23d3e77f14099d109b2d;p=helm.git diff --git a/helm/software/matita/scripts/crontab.sh b/helm/software/matita/scripts/crontab.sh index f2a0283c0..06cb81654 100644 --- a/helm/software/matita/scripts/crontab.sh +++ b/helm/software/matita/scripts/crontab.sh @@ -15,7 +15,7 @@ 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/~tassi/bench.php" +URL="http://mowgli.cs.unibo.it/~sacerdot/bench.php" #initialization OLD=$PWD @@ -84,21 +84,32 @@ 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 + cat <