adding test scripts
[csql.git] / test / cache / CacheTable / test039.ksh
blobac5719e5bb442566f232ac3a714eff9dacff6b97
1 #!/bin/ksh
2 # Test Case
4 # Bi-directional cache test
5 # Create table t1 with field f1 int ,f2 char,f3 smallint , f4 bigint primary key(f1) . Make bidirectional flag and cache flag true. Cache the table with cachetable -t t1 -f f2,f3 it should fail
7 # Author:=bijaya
10 input=${PWD}/cache/CacheTable/csql1.conf
12 REL_PATH=.
13 if [ -s "$input" ]
14 then
15 REL_PATH=${PWD}/cache/CacheTable
17 rm -f /tmp/csql1.conf
18 cp $REL_PATH/csql1.conf /tmp
19 export CSQL_CONFIG_FILE=/tmp/csql1.conf
20 echo DSN=$DSN >>$CSQL_CONFIG_FILE
21 DS="$DSN $DBUSER $PASSWORD"
22 rm -f /tmp/csql/csqlds.conf
23 touch /tmp/csql/csqlds.conf
24 $CSQL_INSTALL_ROOT/bin/csqlds -U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
25 if [ $? -ne 0 ]
26 then
27 exit 1;
30 echo "create table t1(f1 int ,f2 char(12),f3 smallint , f4 bigint,primary key(f1));">$REL_PATH/t1.sql
31 for a in 1 2 3 4 5 6 7 8 9
33 echo "insert into t1 values($a,'papu',12,$a+123124);"
34 done>>t1.sql
35 isql $DS < $REL_PATH/t1.sql >/dev/null 2>&1
36 if [ $? -ne 0 ]
37 then
38 echo "unable to creste in target db"
39 kill `ps -e | grep csqlcacheserver | gawk -F" " '{ print $1 }'`
40 rm -f $REL_PATH/t1.sql
41 exit 1
44 echo "drop table t1;">${REL_PATH}/dt1.sql
45 rm -f /tmp/csql/csqltable.conf
46 touch /tmp/csql/csqltable.conf
48 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
49 pid=$!
50 sleep 5
51 echo "server started"
52 $CSQL_INSTALL_ROOT/bin/cachetable -t t1 -f f2,f3,f4
53 if [ $? -eq 0 ]
54 then
55 echo "Table is cached test case failed"
56 isql $DS <${REL_PATH}/dt1.sql >/dev/null 2>&1
57 rm -f $REL_PATH/t1.sql ${REL_PATH}/dt1.sql
58 kill -9 $pid
59 ipcrm -M 4000 -M 4500
60 kill `ps -e | grep csqlcacheserver | gawk -F" " '{ print $1 }'`
61 exit 2
63 isql $DS <${REL_PATH}/dt1.sql >/dev/null 2>&1
64 rm -f /tmp/csql/csqltable.conf
65 touch /tmp/csql/csqltable.conf
66 rm -f $REL_PATH/t1.sql ${REL_PATH}/dt1.sql
67 kill -9 $pid
68 ipcrm -M 4000 -M 4500
69 kill `ps -e | grep csqlcacheserver | gawk -F" " '{ print $1 }'`
70 exit 0;