Skip to content
Snippets Groups Projects
Select Git revision
  • aaf7c677538f19fbbcee373b9703310f57901f43
  • master default protected
2 results

results_db_stats.sh

Blame
  • 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