Annotation of /bin/MasterAddTable

#!/usr/bin/perl
# 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 Pg;
use Getopt::Long;

$| = 1;

$result = GetOptions("debug!", "verbose!", "help",
                     "host=s", "user=s", "password=s");

my $debug = $opt_debug || 0;
my $verbose = $opt_verbose || 0;

if (defined($opt_help) || (scalar(@ARGV) < 3)) {
    print "Usage: $0 --host=name --user=name --password=string masterdb table column\n";
    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=$opt_host" if (defined($opt_host));
$minfo = "$minfo user=$opt_user" if (defined($opt_user));
$minfo = "$minfo password=$opt_password" if (defined($opt_password));

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

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