convert pagecount stats to Json messages to be sent to Kafka/MemSQL

wikistats2json

#!/bin/bash

for f in *.top; do
    f_notop=${f/.top/}
    IFS='-' read -r -a array <<< "$f_notop"
    date=${array[1]}
    hour=${array[2]}
    first=0
    while read p; do
        IFS=' ' read -r -a tokens <<< "$p"
        title=${tokens[1]}
        count=${tokens[2]}
        if [ $first = "1" ]; then
            echo {\""title\"":\""$title\"", \""count\"":$count, \""time\"":\""${date:0:4}-${date:4:2}-${date:6:2} ${hour:0:2}:${hour:2:2}:${hour:4:2}\""}
        fi
        first=1
    done < $f > $f.json
done