#!/bin/bash

for TYPE in int bigint text uuid; do
    echo "type: $TYPE"
    echo -e "\tamount\tHashAgg\t\tGroupAgg\tIndexAgg"
    for AMOUNT in 100 1000 10000 100000 1000000; do
        HASHTPS="$(cat "hashagg_${TYPE}${AMOUNT}" | grep "tps = " | awk '{print $3}')"
        GROUPTPS="$(cat "groupagg_${TYPE}${AMOUNT}" | grep "tps = " | awk '{print $3}')"
        INDEXTPS="$(cat "indexagg_${TYPE}${AMOUNT}" | grep "tps = " | awk '{print $3}')"
        echo -e "\t$AMOUNT\t$HASHTPS\t$GROUPTPS\t$INDEXTPS"
    done
    echo ""
done

echo "type: bigtext"
echo -e "\tHashAgg\t\tGroupAgg\tIndexAgg"
HASHTPS="$(cat "hashagg_bigtext" | grep "tps = " | awk '{print $3}')"
GROUPTPS="$(cat "groupagg_bigtext" | grep "tps = " | awk '{print $3}')"
INDEXTPS="$(cat "indexagg_bigtext" | grep "tps = " | awk '{print $3}')"
echo -e "\t$HASHTPS\t$GROUPTPS\t$INDEXTPS"