Annotation of /bin/GetSyncID

#!/usr/bin/perl -w
# GetSyncID
# 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,1);
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) < 1)) {
    print "Usage: $0 [options] slavedb table column
Options:
        --slavehost=hostname --slaveport=port
        --slaveuser=username --slavepassword=string
";
    exit ((scalar(@ARGV) < 1)? 1:0);
}

$RServ::quiet = !$verbose;
if ($debug) {
        $RServ::quiet = 0;
        no warnings 'vars';
        $RServ::debug = $debug;
}

my $dbname = $ARGV[0];

my $sinfo = "dbname=$dbname";
$sinfo = "$sinfo host=$slavehost" if (defined($slavehost));
$sinfo = "$sinfo port=$slaveport" if (defined($slaveport));
$sinfo = "$sinfo user=$slaveuser" if (defined($slaveuser));
$sinfo = "$sinfo password=$slavepassword" if (defined($slavepassword));

print("Connecting to '$sinfo'\n") if ($debug || $verbose);
my $conn = Pg::connectdb($sinfo);

my $res = GetSyncID($conn);

die "ERROR\n" if $res < 0;

if (! defined $res)
{
    printf STDERR "No SyncID found\n";
}
else
{
    print("Last SyncID applied: ") if ($verbose);
    printf "%d", $res;
    print("\n") if ($verbose);
}

exit(0);
1	dpavlin	1.4	#!/usr/bin/perl -w
2	dpavlin	1.1	# GetSyncID
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	dpavlin	1.1
14	dpavlin	1.4	use strict;
15	dpavlin	1.1	use Pg;
16			use Getopt::Long;
17			use RServ;
18
19			$\| = 1;
20
21	dpavlin	1.4	my ($debug,$verbose) = (0,1);
22			my ($help,$slavehost,$slaveport,$slaveuser,$slavepassword);
23	dpavlin	1.1
24	dpavlin	1.4	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) < 1)) {
31			print "Usage: $0 [options] slavedb table column
32			Options:
33			--slavehost=hostname --slaveport=port
34			--slaveuser=username --slavepassword=string
35			";
36			exit ((scalar(@ARGV) < 1)? 1:0);
37	dpavlin	1.1	}
38
39	dpavlin	1.5	$RServ::quiet = !$verbose;
40			if ($debug) {
41			$RServ::quiet = 0;
42			no warnings 'vars';
43			$RServ::debug = $debug;
44			}
45
46	dpavlin	1.1	my $dbname = $ARGV[0];
47
48			my $sinfo = "dbname=$dbname";
49	dpavlin	1.4	$sinfo = "$sinfo host=$slavehost" if (defined($slavehost));
50			$sinfo = "$sinfo port=$slaveport" if (defined($slaveport));
51			$sinfo = "$sinfo user=$slaveuser" if (defined($slaveuser));
52			$sinfo = "$sinfo password=$slavepassword" if (defined($slavepassword));
53	dpavlin	1.1
54			print("Connecting to '$sinfo'\n") if ($debug \|\| $verbose);
55			my $conn = Pg::connectdb($sinfo);
56
57	dpavlin	1.4	my $res = GetSyncID($conn);
58	dpavlin	1.1
59			die "ERROR\n" if $res < 0;
60
61			if (! defined $res)
62			{
63			printf STDERR "No SyncID found\n";
64			}
65			else
66			{
67			print("Last SyncID applied: ") if ($verbose);
68			printf "%d", $res;
69			print("\n") if ($verbose);
70			}
71
72			exit(0);