1 |
dpavlin |
1.1 |
#!/bin/sh |
2 |
|
|
|
3 |
|
|
# Quality Assurance script -- it should pass without errors |
4 |
|
|
|
5 |
|
|
dir=".." |
6 |
|
|
opt="-v -d" |
7 |
|
|
if [ ! -z "$1" ] ; then |
8 |
|
|
slave_h="-h $1" |
9 |
|
|
slave_sh="--slavehost $1" |
10 |
|
|
echo "using slave host $1" |
11 |
|
|
fi |
12 |
|
|
|
13 |
|
|
dropdb master |
14 |
|
|
dropdb $slave_h slave |
15 |
|
|
createdb master |
16 |
|
|
createdb $slave_h slave |
17 |
|
|
psql master < rep-demo.sql |
18 |
|
|
psql $slave_h slave < rep-demo.sql |
19 |
|
|
$dir/bin/MasterInit $opt master |
20 |
|
|
$dir/bin/SlaveInit $slave_sh $opt master slave |
21 |
|
|
$dir/bin/MasterAddTable $opt master a id |
22 |
|
|
$dir/bin/MasterAddTable $opt master b id |
23 |
|
|
$dir/bin/MasterAddTable $opt master a_b a_id |
24 |
|
|
$dir/bin/MasterAddTable $opt master c foo |
25 |
|
|
$dir/bin/SlaveAddTable $slave_sh $opt slave a id |
26 |
|
|
$dir/bin/SlaveAddTable $slave_sh $opt slave b id |
27 |
|
|
$dir/bin/SlaveAddTable $slave_sh $opt slave a_b b_id |
28 |
|
|
$dir/bin/SlaveAddTable $slave_sh $opt slave c bar |
29 |
|
|
$dir/bin/Replicate $slave_sh $opt master slave |
30 |
|
|
|
31 |
|
|
loop=5 |
32 |
|
|
nr=0 |
33 |
|
|
while [ $nr != $loop ] ; do |
34 |
|
|
nr=`expr $nr + 1` |
35 |
|
|
echo "Pass $nr" |
36 |
|
|
|
37 |
|
|
$dir/misc/rserv_test.pl master a foo |
38 |
|
|
$dir/bin/Replicate $slave_sh $opt master slave |
39 |
|
|
done |