summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJesse Luehrs <doy@tozt.net>2019-08-27 01:21:47 -0400
committerJesse Luehrs <doy@tozt.net>2019-08-27 01:21:47 -0400
commit60a8f5da5e4ea0523800c973258bc0f80ccae7de (patch)
tree24074917b467c7492ca270932d954ef07d773ffe
parentc8035ba97f5ff80a1f844e0c4574b3f2a3e497ee (diff)
downloadpuppet-tozt-60a8f5da5e4ea0523800c973258bc0f80ccae7de.tar.gz
puppet-tozt-60a8f5da5e4ea0523800c973258bc0f80ccae7de.zip
use schema command
-rw-r--r--modules/tozt/files/metabase3
1 files changed, 2 insertions, 1 deletions
diff --git a/modules/tozt/files/metabase b/modules/tozt/files/metabase
index d99377a..96dee54 100644
--- a/modules/tozt/files/metabase
+++ b/modules/tozt/files/metabase
@@ -14,7 +14,8 @@ chown doy:doy "$tmp"
cd "$tmp"
su doy -c /home/doy/.cargo/bin/ynab-export
-psql -U metabase ynab < schema.sql
+ynab-export schema | psql -U metabase ynab
+
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