#!/bin/sh

if [ $# -ne 1 ]; then
    echo "usage: $(basename $0) <kyua report DB file>" >&2
    exit 1
fi

DB=$1
if [ ! -f "$DB" ]; then
    echo "$(basename $0): expected file parameter" >&2
    exit 1
fi

QUERY="select ltrim(test_programs.absolute_path, \"/\"), test_cases.name, test_results.end_time - test_results.start_time \
       from test_results \
       join test_cases on test_results.test_case_id=test_cases.test_case_id \
       join test_programs on test_cases.test_program_id=test_programs.test_program_id \
       where test_results.result_type == \"passed\""

echo "$QUERY" | sqlite3 "$DB" | awk -F'|' '{gsub("/", ";", $1); print($1";"$2" "$3);}'