Annotation of /bin/SlaveDelTable

#!/usr/bin/perl -w
# SlaveAddTable
# Vadim Mikheev, (c) 2000, PostgreSQL Inc.

eval '(exit $?0)' && eval 'exec perl -S $0 ${1+"$@"}'
    & eval 'exec perl -S $0 $argv:q'
    if 0;

BEGIN {
        my $basedir = $0; $basedir =~ s#/[^/]+$##;
        unshift(@INC, "$basedir/../share");
}

use strict;
use Pg;
use Getopt::Long;
use RServ;

$| = 1;

my ($debug,$verbose) = (0,0);
my ($help,$slavehost,$slaveport,$slaveuser,$slavepassword);

my $result = GetOptions(
        "debug!" => \$debug, "verbose!" => \$verbose, "help" => \$help,
        "slavehost=s" => \$slavehost, "slaveport=i" => \$slaveport,
        "slaveuser=s" => \$slaveuser, "slavepassword=s" => \$slavepassword,
        );

if (defined($help) || (scalar(@ARGV) < 2)) {
    print "Usage: $0 [options] slavedb table
Options:
        --slavehost=hostname --slaveport=port
        --slaveuser=username --slavepassword=string
";
    exit ((scalar(@ARGV) < 2)? 1:0);
}

my $dbname = $ARGV[0];
my $table = $ARGV[1];
#my $keyname = $ARGV[2];

my $sinfo = MkInfo($dbname,$slavehost,$slaveport,$slaveuser,$slavepassword);

my $conn = Pg::connectdb($sinfo);
if ($conn->status != PGRES_CONNECTION_OK) {
    print STDERR "Failed opening $sinfo\n";
    exit 1;
}

$result = $conn->exec("BEGIN");
die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;

$result = $conn->exec("DELETE FROM _RSERV_SLAVE_TABLES_ WHERE tname='$table'");
die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;

$result = $conn->exec("COMMIT");
die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;

exit(0);
1	dpavlin	1.2	#!/usr/bin/perl -w
2	dpavlin	1.1	# SlaveAddTable
3			# Vadim Mikheev, (c) 2000, PostgreSQL Inc.
4
5			eval '(exit $?0)' && eval 'exec perl -S $0 ${1+"$@"}'
6			& eval 'exec perl -S $0 $argv:q'
7			if 0;
8
9	dpavlin	1.4	BEGIN {
10			my $basedir = $0; $basedir =~ s#/[^/]+$##;
11			unshift(@INC, "$basedir/../share");
12			}
13
14	dpavlin	1.2	use strict;
15	dpavlin	1.1	use Pg;
16			use Getopt::Long;
17	dpavlin	1.4	use RServ;
18	dpavlin	1.1
19			$\| = 1;
20
21	dpavlin	1.2	my ($debug,$verbose) = (0,0);
22			my ($help,$slavehost,$slaveport,$slaveuser,$slavepassword);
23	dpavlin	1.1
24	dpavlin	1.2	my $result = GetOptions(
25			"debug!" => \$debug, "verbose!" => \$verbose, "help" => \$help,
26			"slavehost=s" => \$slavehost, "slaveport=i" => \$slaveport,
27			"slaveuser=s" => \$slaveuser, "slavepassword=s" => \$slavepassword,
28			);
29
30			if (defined($help) \|\| (scalar(@ARGV) < 2)) {
31			print "Usage: $0 [options] slavedb table
32			Options:
33			--slavehost=hostname --slaveport=port
34			--slaveuser=username --slavepassword=string
35			";
36			exit ((scalar(@ARGV) < 2)? 1:0);
37	dpavlin	1.1	}
38
39			my $dbname = $ARGV[0];
40			my $table = $ARGV[1];
41			#my $keyname = $ARGV[2];
42
43	dpavlin	1.3	my $sinfo = MkInfo($dbname,$slavehost,$slaveport,$slaveuser,$slavepassword);
44	dpavlin	1.1
45			my $conn = Pg::connectdb($sinfo);
46			if ($conn->status != PGRES_CONNECTION_OK) {
47			print STDERR "Failed opening $sinfo\n";
48			exit 1;
49			}
50
51	dpavlin	1.2	$result = $conn->exec("BEGIN");
52	dpavlin	1.1	die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;
53
54			$result = $conn->exec("DELETE FROM _RSERV_SLAVE_TABLES_ WHERE tname='$table'");
55			die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;
56
57			$result = $conn->exec("COMMIT");
58			die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;
59
60			exit(0);