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	#!/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