various removals of unneeded m_wh and improved push speed

[migration-tools.git] / mig

diff --git a/mig b/mig
index 14b97e4..ea11e6f 100755 (executable)
--- a/mig
+++ b/mig
@@ -65,6 +65,8 @@ Using B<mig> 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,14 @@ Holds, Actors, Bibs, Assets & Money.
 
 Allows you to override the default evergreen_staged_report.xml in the mig-xml folder.
 
+=item B<gsheet> --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.  The spreadsheet is assumed to share the name as the mig schema. 
+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
@@ -296,6 +306,10 @@ switch($ARGV[0]) {
         Mig::die_if_no_env_migschema();
         standard_invocation(@ARGV);
     }
+    case "quick" {
+        Mig::die_if_no_env_migschema();
+        standard_invocation(@ARGV);
+    }
     case "add" {
         Mig::die_if_no_env_migschema();
         standard_invocation(@ARGV);
@@ -304,6 +318,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);