summaryrefslogtreecommitdiffstats
path: root/bin/load
blob: ab01ca9d3a8b07ac3f2a653f85b2d195b5a1d9b1 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
#!/bin/sh
set -eu

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

cargo build
cd data || exit 1

rm -f ./*.tsv || true
../target/debug/investments-sheet-export

psql -U metabase investments < schema.sql
psql -U metabase investments -c 'COPY categories FROM STDIN' < categories.tsv
psql -U metabase investments -c 'COPY holdings FROM STDIN' < holdings.tsv