Annotation 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;

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,$masterhost,$masterport,$masteruser,$masterpassword);

my $mserver=0;

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

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

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

my $minfo = MkInfo($dbname,$masterhost,$masterport,$masteruser,$masterpassword);

print STDERR "master server nr: $mserver\n" if ($debug);

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

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

$result = $mconn->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 $mconn->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 = $mconn->exec("create trigger _RSERV_TRIGGER_T_ after" . 
                      " insert or update or delete on \"$table\"" .
                      " for each row execute procedure" . 
                      " _rserv_log_('$row[1]',$mserver)");
die $mconn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;

$result = $mconn->exec("insert into _RSERV_TABLES_ (tname, cname, reloid, key)" . 
                      " values ('$table', '$keyname', $row[0], $row[1])");
die $mconn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;

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

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