test/cache/CacheTable/test025.ksh

   1 #!/bin/ksh
   2 #Test case 25.
   3 #       Create table t1 in target database.
   4 #       load t1 table with condition and field mode option.
   5 #       unload the t1 table with -u option.
   6
   7 #AUTHOR : Jitendra Lenka
   8
   9 input=${PWD}/cache/CacheTable/inputtest4.sql
  10 REL_PATH=.
  11
  12 if [ -s "$input" ]
  13 then
  14      REL_PATH=${PWD}/cache/CacheTable
  15 fi
  16 rm -f /tmp/csql.conf
  17 cp $CSQL_CONFIG_FILE /tmp
  18 export CSQL_CONFIG_FILE=/tmp/csql.conf
  19
  20 # create table t1 in target DB.
  21 echo CACHE_TABLE=true >>$CSQL_CONFIG_FILE
  22 echo DSN=$DSN >>$CSQL_CONFIG_FILE
  23 DS="$DSN $DBUSER $PASSWORD"
  24 rm -f /tmp/csql/csqlds.conf
  25 touch /tmp/csql/csqlds.conf
  26 $CSQL_INSTALL_ROOT/bin/csqlds -U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
  27 if [ $? -ne 0 ]
  28 then
  29    exit 1;
  30 fi
  31
  32 isql $DS < ${REL_PATH}/fmodeinsert.sql >/dev/null 2>&1
  33 if [ $? -ne 0 ]
  34 then
  35     exit 1;
  36 fi
  37
  38 echo Table t1 created in target DB.
  39
  40 rm -f /tmp/csql/csqltable.conf
  41 touch /tmp/csql/csqltable.conf
  42
  43 echo "cachetable -t t1 -c \"f1<3\" -f \"f1,f3,f5\""
  44 $CSQL_INSTALL_ROOT/bin/cachetable -t t1 -c "f1<3" -f "f1,f3,f5" >/dev/null 2>&1
  45 if [ $? -ne 0 ]
  46 then
  47    isql $DS < ${REL_PATH}/drop.sql >/dev/null 2>&1
  48    rm -f /tmp/csql/csqltable.conf
  49
  50    exit 2;
  51 fi
  52
  53 echo "select from t1 table"
  54
  55 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/selectt1.sql
  56  if [ $? -ne 0 ]
  57    then
  58      rm -f /tmp/csql/csqltable.conf
  59      touch /tmp/csql/csqltable.conf
  60
  61      $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop.sql >/dev/null 2>&1
  62      isql $DS < ${REL_PATH}/drop.sql >/dev/null 2>&1
  63
  64      exit 4;
  65 fi
  66
  67
  68 $CSQL_INSTALL_ROOT/bin/cachetable -t t1 -u >/dev/null 2>&1
  69  if [ $? -ne 0 ]
  70  then
  71      rm -f /tmp/csql/csqltable.conf
  72      touch /tmp/csql/csqltable.conf
  73
  74      $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop.sql >/dev/null 2>&1
  75      isql $DS < ${REL_PATH}/drop.sql >/dev/null 2>&1
  76
  77      exit 4;
  78 fi
  79
  80 echo "Table t1 unloaded from CSQL"
  81
  82
  83 rm -f /tmp/csql/csqltable.conf
  84 touch /tmp/csql/csqltable.conf
  85
  86 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop.sql > /dev/null 2>&1
  87 isql $DS <${REL_PATH}/drop.sql >/dev/null 2>&1
  88  exit 0;
  89
  90
  91
  92