From 51ff59228b2bbc3a92d9b3e867abb1144059034d Mon Sep 17 00:00:00 2001 From: Jesse Luehrs Date: Fri, 23 Aug 2019 00:50:15 -0400 Subject: add helpers for loading data into the db --- bin/load | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100755 bin/load (limited to 'bin/load') diff --git a/bin/load b/bin/load new file mode 100755 index 0000000..eda089f --- /dev/null +++ b/bin/load @@ -0,0 +1,7 @@ +#!/bin/sh + +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 -- cgit v1.2.3-54-g00ecf