X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig;h=b48a76ebf948737fbd23c2e615c989a424144090;hp=3fa227ff80c6dd0c218194cbe8993e9733d06183;hb=10de3f4ac4bda540279413d818b15740ade85788;hpb=51093424e0af8cb967e2252213f7a45f54d61e60 diff --git a/mig b/mig index 3fa227f..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 @@ -242,7 +244,7 @@ Optional parameters are : --added_page_title and --added_page_file If one is used both must be. The added page file can be plain text or asciidoc. This -adds an extra arbitrary page of notes to the report. +adds an extra arbitrary page of notes to the report. Mig assumes the page file is in the mig git directory. --tags @@ -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);