#!/bin/sh
set -eu

export PGOPTIONS="-c client_min_messages=warning"

/home/doy/.cargo/bin/ynab-export
psql -U metabase money -c 'DROP VIEW IF EXISTS spending'
/home/doy/.cargo/bin/ynab-export schema | psql -U metabase money

seq 1000000 | psql -U metabase money -c 'COPY ints FROM STDIN'

psql -U metabase money -c 'COPY accounts FROM STDIN' < accounts.tsv
psql -U metabase money -c 'COPY category_groups FROM STDIN' < category_groups.tsv
psql -U metabase money -c 'COPY categories FROM STDIN' < categories.tsv
psql -U metabase money -c 'COPY months FROM STDIN' < months.tsv
psql -U metabase money -c 'COPY categories_by_month FROM STDIN' < categories_by_month.tsv
psql -U metabase money -c 'COPY payees FROM STDIN' < payees.tsv
psql -U metabase money -c 'COPY transactions FROM STDIN' < transactions.tsv
psql -U metabase money -c 'COPY subtransactions FROM STDIN' < subtransactions.tsv
psql -U metabase money -c 'COPY scheduled_transactions FROM STDIN' < scheduled_transactions.tsv
psql -U metabase money -c 'COPY scheduled_subtransactions FROM STDIN' < scheduled_subtransactions.tsv

cargo run -q --manifest-path "$(dirname "$0")/../Cargo.toml" --bin investments-sheet-export "$@"
psql -U metabase money < "$(dirname "$0")/../data/investments-sheet-schema.sql"

psql -U metabase money -c 'COPY investment_categories FROM STDIN' < investment_categories.tsv
psql -U metabase money -c 'COPY holdings FROM STDIN' < holdings.tsv

psql -U metabase money < "$(dirname "$0")/../data/tax_returns.sql"

psql -U metabase money -c 'COPY tax_returns FROM STDIN' < /media/persistent/metabase/extra_data/tax_returns.tsv
psql -U metabase money < "$(dirname "$0")/../data/tins.sql"
psql -U metabase money -c 'COPY tins FROM STDIN' < /media/persistent/metabase/extra_data/tins.tsv
psql -U metabase money < "$(dirname "$0")/../data/denorm.sql"