test/cache/Bidirectional/test011.ksh

   1 #!/bin/sh
   2 # Test Case
   3
   4 # Bi-directional mutiple cache node test
   5 # Two Cache Node and t1 and t2 table to be cached
   6 # Delete opration in Target database
   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
  16 rm -f /tmp/csql.conf
  17 cp $REL_PATH/csql.conf /tmp
  18 export CSQL_CONFIG_FILE=/tmp/csql.conf
  19 echo DSN=$DSN >>$CSQL_CONFIG_FILE
  20
  21 isql $DSN < $REL_PATH/mysqlcreatelogtable.sql >/dev/null 2>&1
  22 if [ $? -ne 0 ]
  23 then
  24     echo "DSN is not set for target db"
  25     exit 1
  26 fi
  27
  28 echo table csql_log_int is created with records in target db
  29
  30 isql $DSN < $REL_PATH/create.sql >/dev/null 2>&1
  31 rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
  32 touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
  33 isql $DSN < $REL_PATH/trigger.sql >/dev/null
  34 isql $DSN < $REL_PATH/trigger1.sql  >/dev/null
  35
  36
  37 for (( a=1; a<3; a++ ))
  38 do
  39     echo "1:t$a NULL NULL NULL"
  40 done >> /tmp/csql/csqltable.conf
  41
  42 $CSQL_INSTALL_ROOT/bin/csqlserver -c >/dev/null 2>&1 &
  43 pid=$!
  44 sleep 5
  45 echo "server 1 started"
  46
  47 echo "cache node 2"
  48 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/select.sql
  49 if [ $? -ne 0 ]
  50 then
  51     echo "unable to locate cache 1"
  52     exit 3
  53 fi
  54 mkdir /tmp/csql1 >/dev/null 2>&1
  55 rm -f /tmp/csql1/csqltable.conf /tmp/csql1/csql.db
  56 touch /tmp/csql1/csqltable.conf /tmp/csql1/csql.db
  57
  58 rm /tmp/csql1.conf
  59 cp $REL_PATH/conf/csql.conf /tmp/csql1.conf
  60 export CSQL_CONFIG_FILE=/tmp/csql1.conf
  61 echo DSN=$DSN >>$CSQL_CONFIG_FILE
  62
  63 for (( a=1; a<3; a++ ))
  64 do
  65     echo "1:t$a NULL NULL NULL"
  66 done >> /tmp/csql1/csqltable.conf
  67
  68 $CSQL_INSTALL_ROOT/bin/csqlserver -c >/dev/null 2>&1 &
  69 pid1=$!
  70 sleep 5
  71 echo "server 2 started"
  72
  73 echo "cache node 1"
  74 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/select.sql
  75 if [ $? -ne 0 ]
  76 then
  77     kill -2 $pid
  78     ipcrm -M 4000 -M 4500
  79     echo "unable to locate cache 1"
  80     exit 4
  81 fi
  82 echo "Delete some record in target database"
  83 isql $DSN < ${REL_PATH}/delete.sql > /dev/null 2>&1
  84 sleep 15
  85 echo "cache node 1"
  86 $CSQL_INSTALL_ROOT/bin/csql  -s $REL_PATH/select.sql
  87
  88 export CSQL_CONFIG_FILE=/tmp/csql.conf
  89 echo "cache node 2"
  90 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/select.sql
  91
  92 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop.sql > /dev/null 2>&1
  93 isql $DSN < ${REL_PATH}/drop.sql >/dev/null 2>&1
  94 rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
  95 touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
  96 rm -f /tmp/csql1/csqltable.conf /tmp/csql1/csql.db
  97 touch /tmp/csql1/csqltable.conf /tmp/csql1/csql.db
  98 isql $DSN < $REL_PATH/mysqldeletelogtable.sql >/dev/null 2>&1
  99 kill -2 $pid
 100 ipcrm -M 4000 -M 4500
 101 kill -2 $pid1
 102 ipcrm -M 5000 -M 5500
 103 exit 0;
 104