Contents of /bin/MasterAddTable

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

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

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

$| = 1;

my ($debug,$verbose) = (0,0);
my ($help,$masterhost,$masterport,$masteruser,$masterpassword);

my $server=0;

my $result = GetOptions(
        "debug!" => \$debug, "verbose!" => \$verbose, "help" => \$help,
        "masterhost=s" => \$masterhost, "masterport=i" => \$masterport,
        "masteruser=s" => \$masteruser, "masterpassword=s" => \$masterpassword,
        "server=i" => \$server,
        );

if (defined($help) || (scalar(@ARGV) < 3)) {
    print "Usage: $0 [options] masterdb table column
Options:
        --masterhost=hostname --masterport=port
        --masteruser=username --masterpassword=string
        [--server=slave_number]
";
    exit ((scalar(@ARGV) < 3)? 1:0);
}

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

my $minfo = "dbname=$dbname";
$minfo = "$minfo host=$masterhost" if (defined($masterhost));
$minfo = "$minfo port=$masterport" if (defined($masterport));
$minfo = "$minfo user=$masteruser" if (defined($masteruser));
$minfo = "$minfo password=$masterpassword" if (defined($masterpassword));

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

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

$result = $conn->exec("select pgc.oid, pga.attnum from pg_class pgc" . 
                      ", pg_attribute pga where pgc.relname = '$table'" .
                      " and pgc.oid = pga.attrelid" . 
                      " and pga.attname = '$keyname'");
die $conn->errorMessage if $result->resultStatus ne PGRES_TUPLES_OK;

my @row = $result->fetchrow;
die "Can't find key '$keyname' for table '$table' in database '$dbname'\n" if ! defined $row[0] || ! defined $row[1];

$result = $conn->exec("create trigger _RSERV_TRIGGER_T_ after" . 
                      " insert or update or delete on \"$table\"" .
                      " for each row execute procedure" . 
                      " _rserv_log_('$row[1]',$server)");
die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;

$result = $conn->exec("insert into _RSERV_TABLES_ (tname, cname, reloid, key)" . 
                      " values ('$table', '$keyname', $row[0], $row[1])");
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	#!/usr/bin/perl -w
2	# MasterAddTable
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	use strict;
10	use Pg;
11	use Getopt::Long;
12
13	$\| = 1;
14
15	my ($debug,$verbose) = (0,0);
16	my ($help,$masterhost,$masterport,$masteruser,$masterpassword);
17
18	my $server=0;
19
20	my $result = GetOptions(
21	"debug!" => \$debug, "verbose!" => \$verbose, "help" => \$help,
22	"masterhost=s" => \$masterhost, "masterport=i" => \$masterport,
23	"masteruser=s" => \$masteruser, "masterpassword=s" => \$masterpassword,
24	"server=i" => \$server,
25	);
26
27	if (defined($help) \|\| (scalar(@ARGV) < 3)) {
28	print "Usage: $0 [options] masterdb table column
29	Options:
30	--masterhost=hostname --masterport=port
31	--masteruser=username --masterpassword=string
32	[--server=slave_number]
33	";
34	exit ((scalar(@ARGV) < 3)? 1:0);
35	}
36
37	my $dbname = $ARGV[0];
38	my $table = $ARGV[1];
39	my $keyname = $ARGV[2];
40
41	my $minfo = "dbname=$dbname";
42	$minfo = "$minfo host=$masterhost" if (defined($masterhost));
43	$minfo = "$minfo port=$masterport" if (defined($masterport));
44	$minfo = "$minfo user=$masteruser" if (defined($masteruser));
45	$minfo = "$minfo password=$masterpassword" if (defined($masterpassword));
46
47	my $conn = Pg::connectdb($minfo);
48	if ($conn->status != PGRES_CONNECTION_OK) {
49	print STDERR "Failed opening $minfo\n";
50	exit 1;
51	}
52
53	$result = $conn->exec("BEGIN");
54	die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;
55
56	$result = $conn->exec("select pgc.oid, pga.attnum from pg_class pgc" .
57	", pg_attribute pga where pgc.relname = '$table'" .
58	" and pgc.oid = pga.attrelid" .
59	" and pga.attname = '$keyname'");
60	die $conn->errorMessage if $result->resultStatus ne PGRES_TUPLES_OK;
61
62	my @row = $result->fetchrow;
63	die "Can't find key '$keyname' for table '$table' in database '$dbname'\n" if ! defined $row[0] \|\| ! defined $row[1];
64
65	$result = $conn->exec("create trigger _RSERV_TRIGGER_T_ after" .
66	" insert or update or delete on \"$table\"" .
67	" for each row execute procedure" .
68	" _rserv_log_('$row[1]',$server)");
69	die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;
70
71	$result = $conn->exec("insert into _RSERV_TABLES_ (tname, cname, reloid, key)" .
72	" values ('$table', '$keyname', $row[0], $row[1])");
73	die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;
74
75	$result = $conn->exec("COMMIT");
76	die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;
77
78	exit(0);