From fb95172b4e97117bf1ee9697592eabf029bbc3a1 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Fri, 10 Apr 2020 12:18:53 -0400 Subject: [PATCH] first cut of kmig-remove --- kmig.d/bin/kmig-remove | 29 +++++++++++++---------------- 1 files changed, 13 insertions(+), 16 deletions(-) diff --git a/kmig.d/bin/kmig-remove b/kmig.d/bin/kmig-remove index cf70eda..0ea81d8 100755 --- a/kmig.d/bin/kmig-remove +++ b/kmig.d/bin/kmig-remove @@ -4,16 +4,13 @@ =head1 NAME -mig-remove - This will remove the specified files from the mig tracking table -for the schema pointed to by the MIGSCHEMA environment variable in the -PostgreSQL database specified by various PG environment variables. +kmig-remove - This will remove the specified files from the mig tracking table -You'll need to invoke B prior to using commands like B +You'll need to invoke B prior to using commands like B =head1 SYNOPSIS -B [file] [...] +B [file] [...] =cut @@ -22,8 +19,8 @@ B [file] [...] use strict; use Switch; use Env qw( - HOME PGHOST PGPORT PGUSER PGDATABASE MIGSCHEMA - MIGBASEWORKDIR MIGBASEGITDIR MIGGITDIR MIGWORKDIR + HOME MYSQL_HOST MYSQL_TCP_PORT MYSQL_USER MYSQL_DATABASE MYSQL_PW + MIGSCHEMA MIGBASEWORKDIR MIGBASEGITDIR MIGGITDIR MIGWORKDIR ); use Pod::Usage; use DBI; @@ -31,12 +28,12 @@ use Cwd 'abs_path'; use FindBin; my $mig_bin = "$FindBin::Bin/"; use lib "$FindBin::Bin/"; -use Mig; +use KMig; pod2usage(-verbose => 2) if ! $ARGV[0] || $ARGV[0] eq '--help'; -Mig::die_if_no_env_migschema(); -Mig::die_if_mig_tracking_table_does_not_exist(); +KMig::die_if_no_env_migschema(); +KMig::die_if_mig_tracking_table_does_not_exist(); foreach my $arg (@ARGV) { my $file = abs_path($arg); @@ -53,14 +50,14 @@ exit 0; sub remove_this_file { my $file = shift; - my $tracked_file_id = Mig::check_for_tracked_file($file,{'allow_missing'=>1}); + my $tracked_file_id = KMig::check_for_tracked_file($file,{'allow_missing'=>1}); if ($tracked_file_id) { print "removing tracked file: $file\n"; - my $dbh = Mig::db_connect(); + my $dbh = KMig::db_connect(); my $rv = $dbh->do(" - DELETE FROM $MIGSCHEMA.tracked_file WHERE id = $tracked_file_id; - ") || die "Error deleting from table $MIGSCHEMA.tracked_file (id = $tracked_file_id): $!\n"; - Mig::db_disconnect($dbh); + DELETE FROM m_tracked_file WHERE id = $tracked_file_id; + ") || die "Error deleting from table m_tracked_file (id = $tracked_file_id): $!\n"; + KMig::db_disconnect($dbh); } else { print "File not currently tracked: $file\n"; } -- 1.7.2.5