rserv/misc/qa.sh

#!/bin/sh

# Quality Assurance script -- it should pass without errors

dir=".."
opt="-v -d"
if [ ! -z "$1" ] ; then
        slave_h="-h $1"
        slave_sh="--slavehost $1"
        echo "using slave host $1"
fi

dropdb master
dropdb $slave_h slave
createdb master
createdb $slave_h slave
psql master < rep-demo.sql
psql $slave_h slave < rep-demo.sql
$dir/bin/MasterInit $opt master
$dir/bin/SlaveInit $slave_sh $opt master slave
$dir/bin/MasterAddTable $opt master a id
$dir/bin/MasterAddTable $opt master b id
$dir/bin/MasterAddTable $opt master a_b a_id
$dir/bin/MasterAddTable $opt master c foo
$dir/bin/SlaveAddTable $slave_sh $opt slave a id
$dir/bin/SlaveAddTable $slave_sh $opt slave b id
$dir/bin/SlaveAddTable $slave_sh $opt slave a_b b_id
$dir/bin/SlaveAddTable $slave_sh $opt slave c bar
$dir/bin/Replicate $slave_sh $opt master slave

loop=5
nr=0
while [ $nr != $loop ] ; do
        nr=`expr $nr + 1`
        echo "Pass $nr"

        $dir/misc/rserv_test.pl master a foo
        $dir/bin/Replicate $slave_sh $opt master slave
done
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