additional escaping and multiple table options for add_sf9 function

[migration-tools.git] / mig-bin / mig-sql

diff --git a/mig-bin/mig-sql b/mig-bin/mig-sql
index 7c0c2ed..3909ab3 100755 (executable)
--- a/mig-bin/mig-sql
+++ b/mig-bin/mig-sql
@@ -21,6 +21,7 @@ use Switch;
 use Env qw(
     HOME PGHOST PGPORT PGUSER PGDATABASE MIGSCHEMA
     MIGBASEWORKDIR MIGBASEGITDIR MIGGITDIR MIGWORKDIR
+    BIBSTART
 );
 use Pod::Usage;
 use DBI;
@@ -30,13 +31,18 @@ my $mig_bin = "$FindBin::Bin/";
 use lib "$FindBin::Bin/";
 use Mig;
 
-pod2usage(-verbose => 2) if defined $ARGV[0] && $ARGV[0] eq '--help';
-
-system(
-    'psql', 
-    # TODO inject mig-tracked variables here
-    @ARGV
+my @MYARGV = (
+     'psql'
+    ,'-vmigschema=' . $MIGSCHEMA
+    ,'-vmigschema_text=\'' . $MIGSCHEMA . '\''
+    ,'-F ' . "\t"
 );
+if (defined $BIBSTART) {
+    push @MYARGV, '-vbibstart=' . $BIBSTART;
+}
+# TODO inject more mig-tracked variables here
+
+system(@MYARGV, @ARGV);
 
 exit 0;