From 699abca7cdf11b00a49bc96ef8ba24f17ef66feb Mon Sep 17 00:00:00 2001
From: Jason Etheridge <jason@equinoxinitiative.org>
Date: Thu, 9 Apr 2020 22:04:17 -0400
Subject: [PATCH] seed kmig-sql from mig-sql

---
 kmig.d/bin/kmig-sql |   48 ++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 48 insertions(+), 0 deletions(-)
 create mode 100755 kmig.d/bin/kmig-sql

diff --git a/kmig.d/bin/kmig-sql b/kmig.d/bin/kmig-sql
new file mode 100755
index 0000000..3909ab3
--- /dev/null
+++ b/kmig.d/bin/kmig-sql
@@ -0,0 +1,48 @@
+#!/usr/bin/perl -w
+###############################################################################
+=pod
+
+=head1 NAME
+
+mig-sql 
+
+A wrapper around the psql command.  At some point the plan is to shove mig-tracked variables into psql sessions.
+
+=head1 SYNOPSIS
+
+B<mig-sql> [arguments...]
+
+=cut
+
+###############################################################################
+
+use strict;
+use Switch;
+use Env qw(
+    HOME PGHOST PGPORT PGUSER PGDATABASE MIGSCHEMA
+    MIGBASEWORKDIR MIGBASEGITDIR MIGGITDIR MIGWORKDIR
+    BIBSTART
+);
+use Pod::Usage;
+use DBI;
+use Cwd 'abs_path';
+use FindBin;
+my $mig_bin = "$FindBin::Bin/";
+use lib "$FindBin::Bin/";
+use Mig;
+
+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;
+
-- 
1.7.2.5