test/cache/CacheTable/test038.ksh

   1 #!/bin/ksh
   2 # Test Case
   3
   4 # Bi-directional cache  test
   5 # Create table t1 with field f1 int ,f2 char,f3 smallint , f4 bigint . Make bidirectional flag and cache flag true. Cache the table with cachetable -t t1 -f f2,f3 -p f1 it should fail
   6
   7 # Author:=bijaya
   8
   9
  10 input=${PWD}/cache/CacheTable/csql1.conf
  11
  12 REL_PATH=.
  13 if [ -s "$input" ]
  14 then
  15     REL_PATH=${PWD}/cache/CacheTable
  16 fi
  17 rm -f /tmp/csql1.conf
  18 cp $REL_PATH/csql1.conf /tmp
  19 export CSQL_CONFIG_FILE=/tmp/csql1.conf
  20 echo DSN=$DSN >>$CSQL_CONFIG_FILE
  21 DS="$DSN $DBUSER $PASSWORD"
  22 rm -f /tmp/csql/csqlds.conf
  23 touch /tmp/csql/csqlds.conf
  24 $CSQL_INSTALL_ROOT/bin/csqlds -U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
  25 if [ $? -ne 0 ]
  26 then
  27    exit 1;
  28 fi
  29
  30 echo "create table t1(f1 int ,f2 char(12),f3 smallint , f4 bigint);">$REL_PATH/t1.sql
  31 for a in 1 2 3 4 5 6 7 8 9
  32 do
  33 echo "insert into t1 values($a,'papu',12,$a+123124);"
  34 done>>t1.sql
  35 isql $DS < $REL_PATH/t1.sql >/dev/null 2>&1
  36 if [ $? -ne 0 ]
  37 then
  38     echo "unable to creste in target db"
  39     rm -f $REL_PATH/t1.sql
  40     exit 1
  41 fi
  42
  43 echo "drop table t1;">${REL_PATH}/dt1.sql
  44 rm -f /tmp/csql/csqltable.conf
  45 touch /tmp/csql/csqltable.conf
  46
  47 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  48 pid=$!
  49 sleep 5
  50 echo "server  started"
  51 $CSQL_INSTALL_ROOT/bin/cachetable -t t1 -f f2,f3 -p f1
  52 if [ $? -eq 0 ]
  53 then
  54     echo "Unable to cache"
  55     isql $DS <${REL_PATH}/dt1.sql  >/dev/null 2>&1
  56     rm -f $REL_PATH/t1.sql ${REL_PATH}/dt1.sql
  57     kill -9 $pid
  58     ipcrm -M 4000 -M 4500
  59     exit 2
  60 fi
  61 isql $DS <${REL_PATH}/dt1.sql >/dev/null 2>&1
  62 rm -f /tmp/csql/csqltable.conf
  63 touch /tmp/csql/csqltable.conf
  64 rm -f $REL_PATH/t1.sql ${REL_PATH}/dt1.sql
  65 kill -9 $pid
  66 ipcrm -M 4000 -M 4500
  67 exit 0;
  68