#!/bin/bash

# 載入 gamerc
source ~/.gamerc

# 台版任務ID與名稱對應
#cat ${WORKING_DIRECTORY}/common-${SOURCE_OF_SYNC_TO_LIVE}/Data/db/S_Card.ini | awk -F"|" '$1 ~ /^[0-9]+$/ {print $1","$2}' > /tmp/card2db_tw.csv
cp -arf ${WORKING_DIRECTORY}/common-${SOURCE_OF_SYNC_TO_LIVE}/Data/db/S_Card.ini /tmp/S_Card.ini.orig
dos2unix /tmp/S_Card.ini.orig
awk '/^[0-9]+\|/ {if (NR>1) printf "\r\n"; printf "%s", $0; next} {printf "%s", $0} END {printf "\r\n"}' /tmp/S_Card.ini.orig > /tmp/S_Card.ini
awk -F"|" '$1 ~ /^[0-9]+$/ {print $1","$2","$7}' /tmp/S_Card.ini > /tmp/card2db_tw.csv

# 台版任務對應 CSV 同步到 Ctrl 機, 並更新到 card2db
scp /tmp/card2db_tw.csv ctrl:/tmp

ssh ctrl "psql -U postgres WebTool -c \"CREATE TABLE IF NOT EXISTS card2db (card_id integer primary key, card_name text, card_quality integer)\""
ssh ctrl "psql -U postgres WebTool -c \"TRUNCATE card2db\""
ssh ctrl "psql -U postgres WebTool -c \"COPY card2db (card_id,card_name,card_quality) FROM '/tmp/card2db_tw.csv' csv\""
