diff options
author | Jesse Luehrs <doy@tozt.net> | 2019-08-23 00:50:15 -0400 |
---|---|---|
committer | Jesse Luehrs <doy@tozt.net> | 2019-08-23 00:50:15 -0400 |
commit | 51ff59228b2bbc3a92d9b3e867abb1144059034d (patch) | |
tree | f4374878df6a04ce83883539467a626700641a5b /bin/load | |
parent | c0a0be3ecf2ddf0842173cb68002738b033895ff (diff) | |
download | ynab-export-51ff59228b2bbc3a92d9b3e867abb1144059034d.tar.gz ynab-export-51ff59228b2bbc3a92d9b3e867abb1144059034d.zip |
add helpers for loading data into the db
Diffstat (limited to 'bin/load')
-rwxr-xr-x | bin/load | 7 |
1 files changed, 7 insertions, 0 deletions
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 |