#!/bin/bash

output_file="insert_data.sql"
table_name="test_db.test_tb"
batch_size=10000
total_records=500000

echo -n "INSERT INTO $table_name VALUES" > $output_file
# generate data and write to file
for ((batch=0; batch<total_records/batch_size; batch++)); do
    values=""
    for ((i=1; i<=batch_size; i++)); do
        id=$((batch * batch_size + i))
        partCode=$((RANDOM % 65536))
        shopId=$((RANDOM % 1000000000000))
        processDate=$(date -d "$((RANDOM % 365)) days ago" +"%Y-%m-%d")
        vTagType="type_$((RANDOM % 10))"
        shop_first_order_time=$(date -d "$((RANDOM % 365)) days ago" +"%Y-%m-%d")
        shop_latest_order_time=$(date -d "$((RANDOM % 365)) days ago" +"%Y-%m-%d")
        pct=$(awk -v min=0 -v max=100 'BEGIN{srand(); print min+rand()*(max-min)}')
        valid_ord_montary=$(awk -v min=0 -v max=1000 'BEGIN{srand(); print min+rand()*(max-min)}')

        values+="($id, $partCode, $shopId, '$processDate', '$vTagType', '$shop_first_order_time', '$shop_latest_order_time', $pct, $valid_ord_montary),"
    done

    # remove the last comma
    values=${values%,}
    # append to file
    if (( batch == (total_records/batch_size - 1) )); then
        echo -n "$values;" >> $output_file  # End the last batch with a semicolon
    else
        echo -n "$values," >> $output_file  # End other batches with a comma
    fi

    echo "Batch $((batch + 1)) of $((total_records / batch_size)) written to $output_file"
done

echo "All insert statements have been written to $output_file"