aboutsummaryrefslogtreecommitdiffstats
path: root/bin/load
blob: 6095d8682b5a1f0e002bbc8a08b434fe3a6549ba (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
#!/bin/sh

cd "$(dirname "$0")/.." || exit 1

cargo build
cd data || exit 1

rm -f ./*.tsv
../target/debug/ynab-export

psql -U metabase metabase < schema.sql
psql -U metabase metabase -c 'COPY accounts FROM STDIN' < accounts.tsv
psql -U metabase metabase -c 'COPY category_groups FROM STDIN' < category_groups.tsv
psql -U metabase metabase -c 'COPY categories FROM STDIN' < categories.tsv
psql -U metabase metabase -c 'COPY payees FROM STDIN' < payees.tsv
psql -U metabase metabase -c 'COPY transactions FROM STDIN' < transactions.tsv
psql -U metabase metabase -c 'COPY subtransactions FROM STDIN' < subtransactions.tsv