test/cache/CacheTable/test045.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # Create table t1 in Target DB and insert 1 records in TDB.
   4 # Set CACHE_TABLE=true in csql.conf
   5 # Create a table t1 with same schema as TDB at CSQL.
   6 # DML happen in CSQL, Should not propagate to target Database
   7 #
   8 CSQL_CONF=${PWD}/cache/CacheTable/csql.conf
   9 REL_PATH=.
  10 if [ -s "$CSQL_CONF" ]
  11 then
  12     REL_PATH=${PWD}/cache/CacheTable
  13 fi
  14
  15 rm -f /tmp/csql.conf
  16 cp $REL_PATH/csql.conf /tmp
  17 export CSQL_CONFIG_FILE=/tmp/csql.conf
  18
  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
  24 if [ $? -ne 0 ]
  25 then
  26    exit 1;
  27 fi
  28
  29 # Site1 Configuration
  30 mkdir -p /tmp/CSQL
  31 mkdir -p /tmp/CSQL/log
  32 mkdir -p /tmp/CSQL/log/csql
  33 mkdir -p /tmp/CSQL
  34 mkdir -p /tmp/CSQL/db
  35 cp /tmp/csql.conf /tmp/CSQL/
  36 echo SYS_DB_KEY=2288 >>/tmp/CSQL/csql.conf
  37 echo USER_DB_KEY=3377 >>/tmp/CSQL/csql.conf
  38 echo LOG_FILE=/tmp/CSQL/log/csql/log.out >>/tmp/CSQL/csql.conf
  39 echo DATABASE_FILE=/tmp/CSQL/db >>/tmp/CSQL/csql.conf
  40 echo CACHE_TABLE=true >>/tmp/CSQL/csql.conf
  41 echo SITE_ID=1 >>/tmp/CSQL/csql.conf
  42 echo TABLE_CONFIG_FILE=/tmp/CSQL/csqltable.conf >>/tmp/CSQL/csql.conf
  43 sleep 2
  44 echo CREATING TABLE t1 and INSERTING 1 RECORDS IN TARGET DB
  45 if [ "$DSN" = "sybase" ]
  46 then
  47     isql $DS < ${REL_PATH}/cre_ins_sybase.sql
  48 else
  49     isql $DS < ${REL_PATH}/cre_ins_tdb.sql
  50 fi
  51 if [ $? -ne 0 ]
  52  then
  53  isql $DS < ${REL_PATH}/drop_t1.sql
  54  exit 1;
  55 fi
  56
  57 # Setup Environment For CSQL
  58 export CSQL_CONFIG_FILE=/tmp/CSQL/csql.conf
  59 rm -f /tmp/CSQL/csqltable.conf
  60 touch /tmp/CSQL/csqltable.conf
  61
  62 # RUN CSQL SERVER at CSQL
  63 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  64 pid1=$!
  65 sleep 2
  66
  67 #Insertion at CSQL
  68 echo CREATING TABLE t1 and INSERTING 1 RECORDS AT CSQL
  69 $CSQL_INSTALL_ROOT/bin/csql -g -u root -p manager -s ${REL_PATH}/cre_ins_csql.sql
  70 if [ $? -ne 0 ]
  71  then
  72    kill -9 $pid1
  73    ipcrm -M 2288 -M 3377
  74    isql $DS < ${REL_PATH}/drop_t1.sql
  75  exit 2;
  76 fi
  77
  78 echo "AFTER INSERT AT CSQL DATA IN TDB"
  79 isql $DS < ${REL_PATH}/select_t1.sql
  80 if [ $? -ne 0 ]
  81  then
  82    kill -9 $pid1
  83    ipcrm -M 2288 -M 3377
  84    isql $DS < ${REL_PATH}/drop_t1.sql
  85  exit 3;
  86 fi
  87
  88 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop_t1.sql
  89 if [ $? -ne 0 ]
  90 then
  91    kill -9 $pid1
  92    ipcrm -M 2288 -M 3377
  93    exit 4;
  94 fi
  95
  96 isql $DS < ${REL_PATH}/drop_t1.sql
  97 if [ $? -ne 0 ]
  98  then
  99    kill -9 $pid1
 100    ipcrm -M 2288 -M 3377
 101  exit 5;
 102 fi
 103
 104 rm -rf /tmp/CSQL
 105 kill -9 $pid1
 106 ipcrm -M 2288 -M 3377
 107 exit 0;