4 # Bi-directional cache test
5 # Create table t1 with field f1 int unique,f2 char,f3 smallint , f4 bigint ,primary key(f2). Make bidirectional flag and cache flag true. run trigger ,create log table in target db.Cache the table.
6 # Insert some record chack it should updateed in cache node.
9 input
=${PWD}/cache
/Bidirectional
/mysqlcreatelogtable.sql
14 REL_PATH
=${PWD}/cache
/Bidirectional
17 cp $REL_PATH/csql.conf
/tmp
18 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
19 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
20 DS
="$DSN $DBUSER $PASSWORD"
21 rm -f /tmp
/csql
/csqlds.conf
22 touch /tmp
/csql
/csqlds.conf
23 $CSQL_INSTALL_ROOT/bin
/csqlds
-U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
28 if [ "$DSN" = "myodbc3" ]
30 LOG_FILE
=$REL_PATH/mysqlcreatelogtable.sql
31 TRI_FILE1
=$REL_PATH/trigger.sql
32 TRI_FILE2
=$REL_PATH/trigger1.sql
33 elif [ "$DSN" = "psql" ]
35 LOG_FILE
=$REL_PATH/psqlcreatelogtable.sql
36 TRI_FILE1
=$REL_PATH/trigger.psql
37 TRI_FILE2
=$REL_PATH/trigger1.psql
38 elif [ "$DSN" = "oracle" ]
40 LOG_FILE
=$REL_PATH/oraclecreatelogtable.sql
41 TRI_FILE1
=$REL_PATH/trigger.oracle
42 TRI_FILE2
=$REL_PATH/trigger1.oracle
43 elif [ "$DSN" = "sybase" ]
45 LOG_FILE
=$REL_PATH/sybasecreatelogtable.sql
46 TRI_FILE1
=$REL_PATH/trigger.sybase
47 TRI_FILE2
=$REL_PATH/trigger1.sybase
48 elif [ "$DSN" = "db2" ]
60 isql
$DS < $LOG_FILE >/dev
/null
2>&1
63 echo "DSN is not set for target db"
67 echo Log table created
in target DB
69 rm -f /tmp
/csql
/csqltable.conf
70 touch /tmp
/csql
/csqltable.conf
72 echo "create table t1(f1 int ,f2 char(12),f3 int, f4 int,primary key(f2));">$REL_PATH/t1.sql
73 echo "create unique index ind on t1(f1) ;">>$REL_PATH/t1.sql
76 echo "insert into t1 values($a,'papu$a',12,$a+123124);"
77 done>>$REL_PATH/t1.sql
79 isql
$DS < $REL_PATH/t1.sql
>/dev
/null
2>&1
82 echo "unable to creste in target db"
83 rm -f $REL_PATH/t1.sql
86 isql
$DS <$TRI_FILE1 >/dev
/null
88 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
92 echo "drop table t1;">${REL_PATH}/dt1.sql
93 if [ $DSN = "oracle" -o $DSN = "sybase" ]
96 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t1
-f f1
,f2
,f4
-p f1
-F
99 echo "Unable to cache"
100 isql
$DS <${REL_PATH}/dt1.sql
>/dev
/null
2>&1
101 rm -f $REL_PATH/t1.sql
${REL_PATH}/dt1.sql
102 isql
$DS <${REL_PATH}/mysqldeletelogtable.sql
>/dev
/null
2>&1
103 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
105 ipcrm
-M 4000 -M 4500
111 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t1
-f f1
,f2
,f4
-p f1
114 echo "Unable to cache"
115 isql
$DS <${REL_PATH}/dt1.sql
>/dev
/null
2>&1
116 rm -f $REL_PATH/t1.sql
${REL_PATH}/dt1.sql
117 isql
$DS <${REL_PATH}/mysqldeletelogtable.sql
>/dev
/null
2>&1
118 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
120 ipcrm
-M 4000 -M 4500
125 echo "select * from t1;">$REL_PATH/sel.sql
126 $CSQL_INSTALL_ROOT/bin
/csql
-g -s $REL_PATH/sel.sql
130 isql
$DS <${REL_PATH}/dt1.sql
>/dev
/null
2>&1
131 rm -f $REL_PATH/t1.sql
${REL_PATH}/dt1.sql
$REL_PATH/sel.sql
132 isql
$DS <${REL_PATH}/mysqldeletelogtable.sql
>/dev
/null
2>&1
133 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
135 ipcrm
-M 4000 -M 4500
139 echo "insert into t1 values(17,'papu',12,123124);">$REL_PATH/insert1.sql
140 echo "insert into t1 values(7,'biju',12,123125);">>$REL_PATH/insert1.sql
141 echo "insert into t1 values(10,'tapu',12,1231266);">>$REL_PATH/insert1.sql
142 isql
$DS < ${REL_PATH}/insert1.sql
>/dev
/null
2>&1
144 $CSQL_INSTALL_ROOT/bin
/csql
-g -s $REL_PATH/sel.sql
148 isql
$DS <${REL_PATH}/dt1.sql
>/dev
/null
2>&1
149 rm -f $REL_PATH/t1.sql
${REL_PATH}/dt1.sql
$REL_PATH/sel.sql
$REL_PATH/insert1.sql
150 isql
$DS <${REL_PATH}/mysqldeletelogtable.sql
>/dev
/null
2>&1
151 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
153 ipcrm
-M 4000 -M 4500
157 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t1
-u
158 isql
$DS <${REL_PATH}/dt1.sql
>/dev
/null
2>&1
159 isql
$DS <${REL_PATH}/mysqldeletelogtable.sql
>/dev
/null
2>&1
161 rm -f $REL_PATH/t1.sql
${REL_PATH}/dt1.sql
$REL_PATH/sel.sql
$REL_PATH/insert1.sql
162 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
164 ipcrm
-M 4000 -M 4500