diff options
| author | Jesse Luehrs <doy@tozt.net> | 2019-08-27 01:37:46 -0400 |
|---|---|---|
| committer | Jesse Luehrs <doy@tozt.net> | 2019-08-27 01:37:46 -0400 |
| commit | df9742a26b653b8df87600fff20eafa8a4067033 (patch) | |
| tree | 649295f831399eaa7b7e89d12f7093b1b1104090 | |
| parent | bcd6593c6e9c7815510f50b4c3611b4ada00afee (diff) | |
| download | puppet-tozt-df9742a26b653b8df87600fff20eafa8a4067033.tar.gz puppet-tozt-df9742a26b653b8df87600fff20eafa8a4067033.zip | |
quieter
| -rw-r--r-- | modules/tozt/files/metabase | 26 |
1 files changed, 13 insertions, 13 deletions
diff --git a/modules/tozt/files/metabase b/modules/tozt/files/metabase index 96dee54..08903cb 100644 --- a/modules/tozt/files/metabase +++ b/modules/tozt/files/metabase @@ -12,22 +12,22 @@ trap cleanup EXIT chown doy:doy "$tmp" cd "$tmp" -su doy -c /home/doy/.cargo/bin/ynab-export +su doy -c /home/doy/.cargo/bin/ynab-export > /dev/null -ynab-export schema | psql -U metabase ynab +ynab-export schema | psql -U metabase ynab > /dev/null -psql -U metabase ynab -c 'COPY accounts FROM STDIN' < accounts.tsv -psql -U metabase ynab -c 'COPY category_groups FROM STDIN' < category_groups.tsv -psql -U metabase ynab -c 'COPY categories FROM STDIN' < categories.tsv -psql -U metabase ynab -c 'COPY months FROM STDIN' < months.tsv -psql -U metabase ynab -c 'COPY categories_by_month FROM STDIN' < categories_by_month.tsv -psql -U metabase ynab -c 'COPY payees FROM STDIN' < payees.tsv -psql -U metabase ynab -c 'COPY transactions FROM STDIN' < transactions.tsv -psql -U metabase ynab -c 'COPY subtransactions FROM STDIN' < subtransactions.tsv -psql -U metabase ynab -c 'COPY scheduled_transactions FROM STDIN' < scheduled_transactions.tsv -psql -U metabase ynab -c 'COPY scheduled_subtransactions FROM STDIN' < scheduled_subtransactions.tsv +psql -U metabase ynab -c 'COPY accounts FROM STDIN' < accounts.tsv > /dev/null +psql -U metabase ynab -c 'COPY category_groups FROM STDIN' < category_groups.tsv > /dev/null +psql -U metabase ynab -c 'COPY categories FROM STDIN' < categories.tsv > /dev/null +psql -U metabase ynab -c 'COPY months FROM STDIN' < months.tsv > /dev/null +psql -U metabase ynab -c 'COPY categories_by_month FROM STDIN' < categories_by_month.tsv > /dev/null +psql -U metabase ynab -c 'COPY payees FROM STDIN' < payees.tsv > /dev/null +psql -U metabase ynab -c 'COPY transactions FROM STDIN' < transactions.tsv > /dev/null +psql -U metabase ynab -c 'COPY subtransactions FROM STDIN' < subtransactions.tsv > /dev/null +psql -U metabase ynab -c 'COPY scheduled_transactions FROM STDIN' < scheduled_transactions.tsv > /dev/null +psql -U metabase ynab -c 'COPY scheduled_subtransactions FROM STDIN' < scheduled_subtransactions.tsv > /dev/null -seq 1000000 | psql -U metabase ynab -c 'COPY ints FROM STDIN' +seq 1000000 | psql -U metabase ynab -c 'COPY ints FROM STDIN' > /dev/null # shellcheck disable=SC2046 su doy /home/doy/coding/investments-sheet-export/bin/load $(cat /home/doy/.config/google/investments-sheet) > /dev/null |