test/cache/CacheTable/test016.ksh

   1 #!/bin/ksh
   2 #Test case
   3 #16. create table t1,t2 in target DB with 10 records.
   4 #    load t1 table with condition option
   5 #    load t2 table with condition .
   6
   7 #    unload the two tables t1,t2 with -u option.
   8
   9 #  AUTHOR : Jitendra Lenka
  10
  11 input=${PWD}/cache/CacheTable/inputtest4.sql
  12 REL_PATH=.
  13 if [ -s "$input" ]
  14 then
  15     REL_PATH=${PWD}/cache/CacheTable
  16 fi
  17
  18 cp $CSQL_CONFIG_FILE /tmp/csql.conf
  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 echo CACHE_TABLE=true >>$CSQL_CONFIG_FILE
  30 # create table t1,t2 in target DB.
  31 isql $DS < ${REL_PATH}/create.sql >/dev/null 2>&1
  32 if [ $? -ne 0 ]
  33 then
  34     cp /tmp/csql.conf $CSQL_CONFIG_FILE
  35    exit 1;
  36 fi
  37
  38 echo Table t1 and t2 created in target DB.
  39
  40 rm -f /tmp/csql/csqltable.conf
  41 touch /tmp/csql/csqltable.conf
  42
  43 echo "cachetable -t t1"
  44 echo "cachetable -t t2 -c \"t2f1<5\" "
  45
  46 $CSQL_INSTALL_ROOT/bin/cachetable -t t1 >/dev/null 2>&1
  47 if [ $? -ne 0 ]
  48 then
  49     isql $DS < ${REL_PATH}/dropt1t2.sql >/dev/null 2>&1
  50     rm -f /tmp/csql/csqltable.conf
  51
  52     cp /tmp/csql.conf $CSQL_CONFIG_FILE
  53     exit 2;
  54 fi
  55
  56 echo "Table t1 unloaded from CSQL"
  57
  58 $CSQL_INSTALL_ROOT/bin/cachetable -t t2 -c "t2f1<5" >/dev/null 2>&1
  59 if [ $? -ne 0 ]
  60 then
  61      rm -f /tmp/csql/csqltable.conf
  62      touch /tmp/csql/csqltable.conf
  63
  64     $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1t2.sql >/dev/null 2>&1
  65     isql $DS < ${REL_PATH}/dropt1t2.sql >/dev/null 2>&1
  66     cp /tmp/csql.conf $CSQL_CONFIG_FILE
  67     exit 3;
  68 fi
  69
  70 # unload the two tables from csql and remove entry from csqltable.conf
  71
  72 echo "Table t2 unloaded from CSQl"
  73 $CSQL_INSTALL_ROOT/bin/cachetable -t t1 -u >/dev/null 2>&1
  74 if [ $? -ne 0 ]
  75 then
  76      rm -f /tmp/csql/csqltable.conf
  77      touch /tmp/csql/csqltable.conf
  78
  79      $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1t2.sql >/dev/null 2>&1
  80      isql $DS < ${REL_PATH}/dropt1t2.sql >/dev/null 2>&1
  81
  82     cp /tmp/csql.conf $CSQL_CONFIG_FILE
  83      exit 4;
  84 fi
  85
  86 $CSQL_INSTALL_ROOT/bin/cachetable -t t2 -u >/dev/null 2>&1
  87 if [ $? -ne 0 ]
  88 then
  89      $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1t2.sql >/dev/null 2>&1
  90      isql $DS < ${REL_PATH}/dropt1t2.sql >/dev/null 2>&1
  91      rm -f /tmp/csql/csqltable.conf
  92
  93     cp /tmp/csql.conf $CSQL_CONFIG_FILE
  94      exit 5;
  95 fi
  96
  97 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1t2.sql > /dev/null 2>&1
  98 isql $DS <${REL_PATH}/dropt1t2.sql >/dev/null 2>&1
  99 rm -f /tmp/csql/csqltable.conf
 100 touch /tmp/csql/csqltable.conf
 101     cp /tmp/csql.conf $CSQL_CONFIG_FILE
 102 exit 0;
 103
 104