generate.sh

#!/bin/bash

logfile=big-log.txt

keyStr=""
valStr=""
awk -F{ '{print $2}' $logfile | awk -F, '{
for (i=1;i<=5;i++){
    print $i;
}
}' | awk -F: '{print $1,$2,NR}' | while read key val n;do
            #echo "$n : $key => $val"
            if [ `expr $n % 5` == 1 ];then
                keyStr=$key
                valStr=$val
            else
                keyStr="$keyStr,$key"
                valStr="$valStr,$val"
                echo $keyStr
                echo $valStr
            fi

            if [ `expr $n % 5` -eq 0 ] && [ $n > 0 ];then
                printf "insert into game_answer_history (%s) values (%s)\n" $keyStr $valStr >> /tmp/test.sql
                keyStr=""
                valStr=""
            fi
        done