4 # Bi-directional cache test
5 # Cache t1 and t2 table
6 # Set bidirectional flag in csql.conf to true,delete log table from target db if exist
8 input
=${PWD}/cache
/Bidirectional
/mysqlcreatelogtable.sql
13 REL_PATH
=${PWD}/cache
/Bidirectional
16 cp $REL_PATH/csql.conf
/tmp
17 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
18 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
19 DS
="$DSN $DBUSER $PASSWORD"
20 rm -f /tmp
/csql
/csqlds.conf
21 touch /tmp
/csql
/csqlds.conf
22 $CSQL_INSTALL_ROOT/bin
/csqlds
-U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
27 if [ "$DSN" = "myodbc3" ]
29 LOG_FILE
=$REL_PATH/mysqlcreatelogtable.sql
30 TRI_FILE1
=$REL_PATH/trigger.sql
31 TRI_FILE2
=$REL_PATH/trigger1.sql
32 elif [ "$DSN" = "psql" ]
34 LOG_FILE
=$REL_PATH/psqlcreatelogtable.sql
35 TRI_FILE1
=$REL_PATH/trigger.psql
36 TRI_FILE2
=$REL_PATH/trigger1.psql
37 elif [ "$DSN" = "oracle" ]
39 LOG_FILE
=$REL_PATH/oraclecreatelogtable.sql
40 TRI_FILE1
=$REL_PATH/trigger.oracle
41 TRI_FILE2
=$REL_PATH/trigger1.oracle
42 elif [ "$DSN" = "sybase" ]
44 LOG_FILE
=$REL_PATH/sybasecreatelogtable.sql
45 TRI_FILE1
=$REL_PATH/trigger.sybase
46 TRI_FILE2
=$REL_PATH/trigger1.sybase
47 elif [ "$DSN" = "db2" ]
49 LOG_FILE
=$REL_PATH/db2createlogtable.sql
50 TRI_FILE1
=$REL_PATH/trigger.db2
51 TRI_FILE2
=$REL_PATH/trigger1.db2
59 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
60 isql
$DS < $REL_PATH/create.sql
>/dev
/null
2>&1
63 echo "DSN is not set for target db"
66 echo "drop table csql_log_int;">$REL_PATH/log.sql
67 echo No log table
in target DB
68 isql
$DS <$REL_PATH/log.sql
>/dev
/null
2>&1
69 rm -f $REL_PATH/log.sql
70 rm -f /tmp
/csql
/csqltable.conf
71 touch /tmp
/csql
/csqltable.conf
72 isql
$DS <$TRI_FILE1 >/dev
/null
73 isql
$DS <$TRI_FILE2 >/dev
/null
76 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
81 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t
$a -d $DSN
84 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
86 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
92 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/select.sql
95 echo "unable to locate cache 1"
96 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
98 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
103 isql
$DS < ${REL_PATH}/insert.sql
>/dev
/null
2>&1
105 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/select.sql
107 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop.sql
> /dev
/null
2>&1
108 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
109 rm -f /tmp
/csql
/csqltable.conf
110 touch /tmp
/csql
/csqltable.conf
112 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
114 ipcrm
-M 4000 -M 4500