#!/bin/bash
## 操作方式: scriptname  名單檔案名 產生檔案名 物品ID 數量 mail_name
##EX:insert_itemreceivable.sql 0625list reward_0625 45123 10 event_0625

input="$1"
output="$2"
item_id="$3"
item_quantity="$4"
mail_name="$5"

echo "INSERT INTO item_receivable (account_name, item_id, item_quantity,mail_name) VALUES" > $output

first=1
while IFS= read -r line
do
  [[ -z "$line" ]] && continue

  if [ $first -eq 1 ]; then
    echo "('$line', $item_id , $item_quantity , '$mail_name')" >> $output
    first=0
  else
    echo ",('$line', $item_id, $item_quantity , '$mail_name' )" >> $output
  fi
done < "$input"

echo ";" >> $output
