From e0c288ae409d7b4f6ec493ba976a64294ce8a12c Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Fri, 9 Feb 2018 15:46:05 -0500 Subject: [PATCH] adding mig gsheet --- mig | 13 +++++++++++++ 1 files changed, 13 insertions(+), 0 deletions(-) diff --git a/mig b/mig index 14b97e4..b48a76e 100755 --- a/mig +++ b/mig @@ -65,6 +65,8 @@ Using B should go something like this: =item mig reporter --analyst "Foo Fooer" --report_title "Foo Load Analysis" #creates an asciidoc report +=item mig gsheet --pull foo_tab_name OR --push foo_pg_table_name + =back =head1 COMMANDS @@ -253,6 +255,13 @@ Holds, Actors, Bibs, Assets & Money. Allows you to override the default evergreen_staged_report.xml in the mig-xml folder. +=item B --pull spreadsheet_tab or --push postgres_table + +This uses the gsheet_tracked_table and gsheet_tracked column tables to map a Google Docs Spreadsheet tabs +with Postgres tables in the mig schema. Multiple spreadsheets can be used but tab names must be unique. +Each spreadsheet column needs a header that matches the column name in the matching table. An oauth +session key is also needed for your Google account and mig gsheet will look for it in the .mig directory. + =back =cut @@ -304,6 +313,10 @@ switch($ARGV[0]) { Mig::die_if_no_env_migschema(); standard_invocation(@ARGV); } + case "gsheet" { + Mig::die_if_no_env_migschema(); + standard_invocation(@ARGV); + } case "remove" { Mig::die_if_no_env_migschema(); standard_invocation(@ARGV); -- 1.7.2.5