Select Git revision
RWTHVRCluster.cpp
results_db_stats.sh 1021 B
res_file="$1"
if [ ! -f "$res_file" ]; then
echo "results file not found" >&2
exit 1
fi
echo -n "Total ids: "
sqlite3 "$res_file" "SELECT count(*) from jobs;"
#echo -n "Total without error: "
#sqlite3 "$res_file" "SELECT count(*) from jobs where error=0;"
echo
for i in {1..11}; do
name=$(sqlite3 "$res_file" "SELECT * FROM rules WHERE rowid=$i;")
num=$(sqlite3 "$res_file" "SELECT count(*) FROM jobs where rule_${i}_match=1;")
echo "Rule $i: $name :: $num"
done
echo
echo "Number of jobs with at least one matching rule:"
s=""
for i in {1..11}; do
s="${s} rule_${i}_match=1 or "
done
s="${s:0:-3}"
#sqlite3 "$res_file" 'SELECT count(*) FROM jobs where rule_1_match=1 or rule_2_match=1 or rule_3_match=1 or rule_4_match=1 or rule_5_match=1 or rule_6_match=1 or rule_7_match=1 or rule_8_match=1 or rule_9_match=1 or rule_10_match=1 or rule_11_match=1;'
sqlite3 "$res_file" "SELECT count(*) FROM jobs where $s;"
echo
sqlite3 "$res_file" "SELECT eval_duration FROM jobs where $s;" > eval_time.csv