/[rserv]/bin/MasterAddTable
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /bin/MasterAddTable

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.5 by dpavlin, Tue Oct 28 18:43:12 2003 UTC revision 1.6 by dpavlin, Wed Oct 29 18:00:18 2003 UTC
# Line 15  $| = 1; Line 15  $| = 1;
15  my ($debug,$verbose) = (0,0);  my ($debug,$verbose) = (0,0);
16  my ($help,$masterhost,$masterport,$masteruser,$masterpassword);  my ($help,$masterhost,$masterport,$masteruser,$masterpassword);
17    
18  my $server=0;  my $mserver=0;
19    
20  my $result = GetOptions(  my $result = GetOptions(
21          "debug!" => \$debug, "verbose!" => \$verbose, "help" => \$help,          "debug!" => \$debug, "verbose!" => \$verbose, "help" => \$help,
22          "masterhost=s" => \$masterhost, "masterport=i" => \$masterport,          "masterhost=s" => \$masterhost, "masterport=i" => \$masterport,
23          "masteruser=s" => \$masteruser, "masterpassword=s" => \$masterpassword,          "masteruser=s" => \$masteruser, "masterpassword=s" => \$masterpassword,
24          "server=i" => \$server,          "masterserver=i" => \$mserver,
25          );          );
26    
27  if (defined($help) || (scalar(@ARGV) < 3)) {  if (defined($help) || (scalar(@ARGV) < 3)) {
# Line 29  if (defined($help) || (scalar(@ARGV) < 3 Line 29  if (defined($help) || (scalar(@ARGV) < 3
29  Options:  Options:
30          --masterhost=hostname --masterport=port          --masterhost=hostname --masterport=port
31          --masteruser=username --masterpassword=string          --masteruser=username --masterpassword=string
32          [--server=slave_number]          [--masterserver=master_number]
33  ";  ";
34      exit ((scalar(@ARGV) < 3)? 1:0);      exit ((scalar(@ARGV) < 3)? 1:0);
35  }  }
# Line 44  $minfo = "$minfo port=$masterport" if (d Line 44  $minfo = "$minfo port=$masterport" if (d
44  $minfo = "$minfo user=$masteruser" if (defined($masteruser));  $minfo = "$minfo user=$masteruser" if (defined($masteruser));
45  $minfo = "$minfo password=$masterpassword" if (defined($masterpassword));  $minfo = "$minfo password=$masterpassword" if (defined($masterpassword));
46    
47    print STDERR "master server nr: $mserver\n" if ($debug);
48    
49  my $conn = Pg::connectdb($minfo);  my $conn = Pg::connectdb($minfo);
50  if ($conn->status != PGRES_CONNECTION_OK) {  if ($conn->status != PGRES_CONNECTION_OK) {
51      print STDERR "Failed opening $minfo\n";      print STDERR "Failed opening $minfo\n";
# Line 65  die "Can't find key '$keyname' for table Line 67  die "Can't find key '$keyname' for table
67  $result = $conn->exec("create trigger _RSERV_TRIGGER_T_ after" .  $result = $conn->exec("create trigger _RSERV_TRIGGER_T_ after" .
68                        " insert or update or delete on \"$table\"" .                        " insert or update or delete on \"$table\"" .
69                        " for each row execute procedure" .                        " for each row execute procedure" .
70                        " _rserv_log_('$row[1]',$server)");                        " _rserv_log_('$row[1]',$mserver)");
71  die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;  die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;
72    
73  $result = $conn->exec("insert into _RSERV_TABLES_ (tname, cname, reloid, key)" .  $result = $conn->exec("insert into _RSERV_TABLES_ (tname, cname, reloid, key)" .
Legend:
Removed from v.1.5  
changed lines
  Added in v.1.6
  ViewVC Help
Powered by ViewVC 1.1.26