X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-bin%2Fmig-status;fp=mig-bin%2Fmig-status;h=0000000000000000000000000000000000000000;hp=0d78b1869a7a58ede3443f0937df0592359c276f;hb=155eb9eac077ca803f75d1295e584e7012e1b883;hpb=69588457ab8f70fbb77af29cc0653933d24ed2ac diff --git a/mig-bin/mig-status b/mig-bin/mig-status deleted file mode 100755 index 0d78b18..0000000 --- a/mig-bin/mig-status +++ /dev/null @@ -1,87 +0,0 @@ -#!/usr/bin/perl -w -############################################################################### -=pod - -=head1 NAME - -mig-status - This will show tracking information for either the specified files -or all tracked files if no argument is given. - -You'll need to invoke B prior to using commands like B - -=head1 SYNOPSIS - -B [file] [...] - -=cut - -############################################################################### - -use strict; -use Switch; -use Env qw( - HOME PGHOST PGPORT PGUSER PGDATABASE MIGSCHEMA - MIGBASEWORKDIR MIGBASEGITDIR MIGGITDIR MIGWORKDIR -); -use Pod::Usage; -use DBI; -use Cwd 'abs_path'; -use FindBin; -my $mig_bin = "$FindBin::Bin/"; -use lib "$FindBin::Bin/"; -use Mig; - -pod2usage(-verbose => 2) if scalar(@ARGV) > 0 && $ARGV[0] eq '--help'; - -Mig::die_if_no_env_migschema(); -Mig::die_if_mig_tracking_table_does_not_exist(); - -my @files = @ARGV; -if (scalar(@files) == 0) { - @files = (); - my $dbh = Mig::db_connect(); - my $sth = $dbh->prepare(" - SELECT base_filename - FROM $MIGSCHEMA.tracked_file - ORDER BY 1;" - ); - my $rv = $sth->execute() - || die "Error retrieving data from table (tracked_file): $!"; - my $rows = $sth->fetchall_arrayref; - for my $row ( @$rows ) { - push @files, $row->[0] - } - $sth->finish; - Mig::db_disconnect($dbh); -} - -foreach my $arg (sort @files) { - my $file = abs_path($arg); - my $data = Mig::status_this_file($file); - print "=-=-=\n"; - foreach my $key ( - 'base_filename' - ,'has_headers' - ,'headers_file' - ,'utf8_filename' - ,'clean_filename' - ,'parent_table' - ,'stage_sql_filename' - ,'staged_table' - ,'map_sql_filename' - ,'prod_sql_filename' - ) { - printf "%-20s:\t", $key; - print $data->{$key} ? $data->{$key} : ""; - if ($key =~ /filename$/ && $data->{$key} && ! -e $data->{$key}) { - print " (FILE MISSING)"; - } - print "\n"; - } -} - -exit 0; - -############################################################################### - -