test/cache/Bidirectional/test001.ksh

   1 #!/bin/ksh
   2 # Test Case
   3
   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
   7
   8 input=${PWD}/cache/Bidirectional/mysqlcreatelogtable.sql
   9
  10 REL_PATH=.
  11 if [ -s "$input" ]
  12 then
  13     REL_PATH=${PWD}/cache/Bidirectional
  14 fi
  15 rm -f /tmp/csql.conf
  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
  23 if [ $? -ne 0 ]
  24 then
  25    exit 1;
  26 fi
  27 if [ "$DSN" = "myodbc3" ]
  28 then
  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" ]
  33 then
  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" ]
  38 then
  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" ]
  43 then
  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" ]
  48 then
  49     LOG_FILE=$REL_PATH/db2createlogtable.sql
  50     TRI_FILE1=$REL_PATH/trigger.db2
  51     TRI_FILE2=$REL_PATH/trigger1.db2
  52 else
  53     LOG_FILE=
  54     TRI_FILE1=
  55     TRI_FILE2=
  56 fi
  57
  58 #echo $DS
  59 isql $DS < ${REL_PATH}/drop.sql >/dev/null 2>&1
  60 isql $DS < $REL_PATH/create.sql >/dev/null 2>&1
  61 if [ $? -ne 0 ]
  62 then
  63     echo "DSN is not set for target db"
  64     exit 1
  65 fi
  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
  74
  75
  76 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  77 pid=$!
  78 sleep 5
  79 for  a in 1 2
  80 do
  81    $CSQL_INSTALL_ROOT/bin/cachetable -t t$a -d $DSN
  82    if [ $? -ne 0 ]
  83    then
  84        kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
  85        kill -9 $pid
  86        isql $DS < ${REL_PATH}/drop.sql >/dev/null 2>&1
  87        ipcrm -M 4000 -M 4500
  88        exit 3;
  89    fi
  90 done
  91 echo "server  started"
  92 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/select.sql
  93 if [ $? -ne 0 ]
  94 then
  95     echo "unable to locate cache 1"
  96     kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
  97     kill -9 $pid
  98     isql $DS < ${REL_PATH}/drop.sql >/dev/null 2>&1
  99     ipcrm -M 4000 -M 4500
 100     exit 2
 101 fi
 102
 103 isql $DS < ${REL_PATH}/insert.sql >/dev/null 2>&1
 104 sleep 15
 105 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/select.sql
 106
 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
 111
 112 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
 113 kill -9 $pid
 114 ipcrm -M 4000 -M 4500
 115 exit 0;