← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to tests/randgen/unit/TestReplServer.pm

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2012-06-19 10:46:49 UTC
  • mfrom: (1.1.6)
  • mto: This revision was merged to the branch mainline in revision 29.
  • Revision ID: package-import@ubuntu.com-20120619104649-e2l0ggd4oz3um0f4
Tags: upstream-7.1.36-stable
Import upstream version 7.1.36-stable

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/randgen/unit/TestReplServer.pm
 
1
# Copyright (C) 2010 Sun Microsystems, Inc. All rights reserved.  Use
 
2
# is subject to license terms.
 
3
#
 
4
# This program is free software; you can redistribute it and/or modify
 
5
# it under the terms of the GNU General Public License as published by
 
6
# the Free Software Foundation; version 2 of the License.
 
7
#
 
8
# This program is distributed in the hope that it will be useful, but
 
9
# WITHOUT ANY WARRANTY; without even the implied warranty of
 
10
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 
11
# General Public License for more details.
 
12
#
 
13
# You should have received a copy of the GNU General Public License
 
14
# along with this program; if not, write to the Free Software
 
15
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301
 
16
# USA
 
17
 
 
18
package TestReplServer;
 
19
 
 
20
use base qw(Test::Unit::TestCase);
 
21
use lib 'lib','lib/DBServer';
 
22
use Cwd;
 
23
use DBServer::DBServer;
 
24
use DBServer::MySQL::ReplMySQLd;
 
25
use GenTest::Executor;
 
26
 
 
27
use Data::Dumper;
 
28
 
 
29
sub new {
 
30
    my $self = shift()->SUPER::new(@_);
 
31
    # your state for fixture here
 
32
    return $self;
 
33
}
 
34
 
 
35
sub set_up {
 
36
}
 
37
 
 
38
@pids;
 
39
 
 
40
sub tear_down {
 
41
    if (osWindows) {
 
42
        ## Need to ,kill leftover processes if there are some
 
43
        foreach my $p (@pids) {
 
44
            Win32::Process::KillProcess($p,-1);
 
45
        }
 
46
        system("rmdir /s /q unit\\tmp1");
 
47
        system("rmdir /s /q unit\\tmp2");
 
48
    } else {
 
49
        ## Need to ,kill leftover processes if there are some
 
50
        kill 9 => @pids;
 
51
        system("rm -rf unit/tmp1");
 
52
        system("rm -rf unit/tmp2");
 
53
    }
 
54
}
 
55
 
 
56
sub test_create_server {
 
57
    my $self = shift;
 
58
    
 
59
    my $portbase = 30 + ($ENV{TEST_PORTBASE}?int($ENV{TEST_PORTBASE}):22120);
 
60
 
 
61
    my $master_vardir= cwd()."/unit/tmp1/";
 
62
    my $slave_vardir= cwd()."/unit/tmp1_slave";
 
63
    
 
64
    $self->assert(defined $ENV{RQG_MYSQL_BASE},"RQG_MYSQL_BASE not defined");
 
65
    
 
66
    my $server = DBServer::MySQL::ReplMySQLd->new(basedir => $ENV{RQG_MYSQL_BASE},
 
67
                                                  master_vardir => $master_vardir,
 
68
                                                  mode => 'statement',
 
69
                                                  master_port => $portbase);
 
70
    $self->assert_not_null($server);
 
71
    
 
72
    $self->assert(-f $master_vardir."/data/mysql/db.MYD","No ".$master_vardir."/data/mysql/db.MYD");
 
73
    $self->assert(-f $slave_vardir."/data/mysql/db.MYD","No ".$slave_vardir."/data/mysql/db.MYD");
 
74
    
 
75
    $server->startServer;
 
76
    push @pids,$server->master->serverpid;
 
77
    push @pids,$server->slave->serverpid;
 
78
 
 
79
 
 
80
    $server->master->dbh->do("CREATE TABLE test.t (i integer)");
 
81
    $server->master->dbh->do("INSERT INTO test.t VALUES(42)");
 
82
 
 
83
    $server->waitForSlaveSync();
 
84
    
 
85
    my $result = $server->slave->dbh->selectrow_array("SELECT * FROM test.t");
 
86
    
 
87
    $self->assert_num_equals(42, $result);
 
88
    
 
89
    $server->stopServer;
 
90
    
 
91
    sayFile($server->master->logfile);
 
92
    sayFile($server->slave->logfile);
 
93
}
 
94
 
 
95
sub test_create_repl {
 
96
    my $self = shift;
 
97
    
 
98
    my $portbase = 30 + ($ENV{TEST_PORTBASE}?int($ENV{TEST_PORTBASE}):22120);
 
99
 
 
100
    my $master_vardir= cwd()."/unit/tmp1/";
 
101
    my $slave_vardir= cwd()."/unit/tmp1_slave";
 
102
    
 
103
    $self->assert(defined $ENV{RQG_MYSQL_BASE},"RQG_MYSQL_BASE not defined");
 
104
    
 
105
    my $master = DBServer::MySQL::MySQLd->new(basedir => $ENV{RQG_MYSQL_BASE},
 
106
                                              vardir => $master_vardir,
 
107
                                              port => $portbase);
 
108
    my $slave = DBServer::MySQL::MySQLd->new(basedir => $ENV{RQG_MYSQL_BASE},
 
109
                                             vardir => $slave_vardir,
 
110
                                             port => $portbase+2);
 
111
    
 
112
    my $server = DBServer::MySQL::ReplMySQLd->new(slave => $slave,
 
113
                                                  master => $master,
 
114
                                                  mode => 'mixed');
 
115
                                             
 
116
    $self->assert_not_null($server);
 
117
    
 
118
    $self->assert(-f $master_vardir."/data/mysql/db.MYD","No ".$master_vardir."/data/mysql/db.MYD");
 
119
    $self->assert(-f $slave_vardir."/data/mysql/db.MYD","No ".$slave_vardir."/data/mysql/db.MYD");
 
120
    
 
121
    $server->startServer;
 
122
    push @pids,$server->master->serverpid;
 
123
    push @pids,$server->slave->serverpid;
 
124
 
 
125
 
 
126
    $server->master->dbh->do("CREATE TABLE test.t (i integer)");
 
127
    $server->master->dbh->do("INSERT INTO test.t VALUES(42)");
 
128
 
 
129
    $server->waitForSlaveSync();
 
130
    
 
131
    my $result = $server->slave->dbh->selectrow_array("SELECT * FROM test.t");
 
132
    
 
133
    $self->assert_num_equals(42, $result);
 
134
    
 
135
    $server->stopServer;
 
136
    
 
137
    sayFile($server->master->logfile);
 
138
    sayFile($server->slave->logfile);
 
139
}
 
140
 
 
141
1;