#!/bin/bash

SERVER="http://localhost"
APIKEY="balhblahblah"

CSV_FILE="pvwatts_hourly.csv"

BATCH_SIZE=100

END=0
RESPONSE="ok"
FILE_SIZE=$(grep -c ^ $CSV_FILE)

while [ $END -lt $FILE_SIZE ]; do
        if [[ $RESPONSE == "ok" ]]; then
                BEGIN=${END}
                END=$(( BEGIN + BATCH_SIZE ))
                if [[ $END -gt $FILE_SIZE ]]; then
                        END=$FILE_SIZE
                fi
                BATCH=""
                RESPONSE=""
        fi
        for (( i=${BEGIN}; i < ${END}; i++ )); do
                LINE=$(sed "$((i+1))q;d" $CSV_FILE)
                FRAME="[$LINE]"
                if [[ $((i+1)) != ${END} ]]; then
                        FRAME="$FRAME,"
                fi
                BATCH="$BATCH$FRAME"
        done
        REQUEST="$SERVER/input/bulk.json?data=[$BATCH]&sentat=$(date +%s)&apikey=$APIKEY"
        RESPONSE=$(curl -g $REQUEST)
        printf "$REQUEST\n$RESPONSE\n\n"
        sleep 5
done