4 # Bi-directional cache test
5 # Create table t1 and t2 in target database with field f1 int ,f2 char primary key(f1). Make sure log table is in target database. Run trigger in integer primary key field.
6 # Set bidirectional flag to true. Insert some record with null values.Test the values in cache tool is null or not.
7 input
=${PWD}/cache
/Bidirectional
/mysqlcreatelogtable.sql
12 REL_PATH
=${PWD}/cache
/Bidirectional
15 cp $REL_PATH/csql.conf
/tmp
16 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
17 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
18 DS
="$DSN $DBUSER $PASSWORD"
19 rm -f /tmp
/csql
/csqlds.conf
20 touch /tmp
/csql
/csqlds.conf
21 $CSQL_INSTALL_ROOT/bin
/csqlds
-U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
26 if [ "$DSN" = "myodbc3" ]
28 LOG_FILE
=$REL_PATH/mysqlcreatelogtable.sql
29 TRI_FILE1
=$REL_PATH/trigger.sql
30 TRI_FILE2
=$REL_PATH/trigger1.sql
31 elif [ "$DSN" = "psql" ]
33 LOG_FILE
=$REL_PATH/psqlcreatelogtable.sql
34 TRI_FILE1
=$REL_PATH/trigger.psql
35 TRI_FILE2
=$REL_PATH/trigger1.psql
36 elif [ "$DSN" = "oracle" ]
38 LOG_FILE
=$REL_PATH/oraclecreatelogtable.sql
39 TRI_FILE1
=$REL_PATH/trigger.oracle
40 TRI_FILE2
=$REL_PATH/trigger1.oracle
41 elif [ "$DSN" = "sybase" ]
43 LOG_FILE
=$REL_PATH/sybasecreatelogtable.sql
44 TRI_FILE1
=$REL_PATH/trigger.sybase
45 TRI_FILE2
=$REL_PATH/trigger1.sybase
46 elif [ "$DSN" = "db2" ]
48 LOG_FILE
=$REL_PATH/db2createlogtable.sql
49 TRI_FILE1
=$REL_PATH/trigger.db2
50 TRI_FILE2
=$REL_PATH/trigger1.db2
58 isql
$DS < $LOG_FILE >/dev
/null
2>&1
61 echo "DSN is not set for target db"
65 echo Log table created
in target DB
66 if [ "$DSN" = "sybase" ]
68 isql
$DS < $REL_PATH/sybasecreate.sql
>/dev
/null
2>&1
70 isql
$DS < $REL_PATH/create.sql
>/dev
/null
2>&1
72 rm -f /tmp
/csql
/csqltable.conf
73 touch /tmp
/csql
/csqltable.conf
74 isql
$DS <$TRI_FILE1 >/dev
/null
75 isql
$DS <$TRI_FILE2 >/dev
/null
78 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
84 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t
$a -d $DSN
87 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
90 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
96 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/select.sql
99 echo "unable to locate cache 1"
100 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
102 ipcrm
-M 4000 -M 4500
107 echo "insert into t$a values(11,NULL);"
108 echo "insert into t$a values(12,NULL);"
109 done >> $REL_PATH/insert1.sql
110 isql
$DS < ${REL_PATH}/insert1.sql
>/dev
/null
2>&1
112 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/select.sql
114 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop.sql
> /dev
/null
2>&1
115 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
116 rm -f /tmp
/csql
/csqltable.conf
117 touch /tmp
/csql
/csqltable.conf
118 rm -f ${REL_PATH}/insert1.sql
119 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
121 ipcrm
-M 4000 -M 4500