blob: 208c011330ea199247f9e46f8fb169743351e31c (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
#!/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"
|
