From 574ac134c28cde99ab108c09f449805e5681a331 Mon Sep 17 00:00:00 2001 From: Jesse Luehrs Date: Sun, 25 Aug 2019 04:32:45 -0400 Subject: add load script --- bin/load | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100755 bin/load diff --git a/bin/load b/bin/load new file mode 100755 index 0000000..ab01ca9 --- /dev/null +++ b/bin/load @@ -0,0 +1,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 -- cgit v1.2.3