test/cache/Gateway/test002.ksh

   1 #!/bin/ksh
   2
   3 #  2. Create table t1 in MySQL with all supported data types in it. and insert 10 records in it.
   4 #  Note that in this test case the table is not cached in csql and it is present only in MySQL.
   5 #  insert 10 more records using csql tool.
   6 #  select records with WHERE clause containing parameters for all the fields with different data types.
   7 #  update all fields with WHERE clause on primary key
   8 #  delete records with WHERE clause on all fields
   9
  10 #Run this test only under csql/test or on this directory.
  11 #Otherwise, it may fail
  12 input=${PWD}/cache/Gateway/mysqlinputtest1.sql
  13 REL_PATH=.
  14 if [ -s "$input" ]
  15 then
  16     REL_PATH=${PWD}/cache/Gateway
  17 fi
  18 rm -f /tmp/csql.conf
  19
  20 cp $REL_PATH/csql.conf /tmp/csql.conf
  21 export CSQL_CONFIG_FILE=/tmp/csql.conf
  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
  33 if [ $DSN = "oracle" ]
  34 then
  35    isql $DS < $REL_PATH/orainputt1.oracle >/dev/null 2>&1
  36 elif [ $DSN = "sybase" ]
  37 then
  38    isql $DS < $REL_PATH/sybaseinputtest1.sql >/dev/null 2>&1
  39 elif [ $DSN = "db2" ]
  40 then
  41    isql $DS < $REL_PATH/db2inputtest1.sql >/dev/null 2>&1
  42 else
  43    isql $DS < $REL_PATH/mysqlinputtest1.sql >/dev/null 2>&1
  44 fi
  45
  46 if [ $? -ne 0 ]
  47 then
  48     echo "DSN is not set for target db"
  49     exit 2
  50 fi
  51
  52 # edit /tmp/csql/csqltable.conf
  53 rm -f /tmp/csql/csqltable.conf
  54 touch /tmp/csql/csqltable.conf
  55 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  56 pid=$!
  57 sleep 5
  58
  59 if [ $DSN = "oracle" ]
  60 then
  61    for a in 51 52 53 54 55
  62    do
  63       echo "insert into t1 values($a,'KKK');"
  64    done >> $REL_PATH/oracsqlinputt1.sql
  65    $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/oracsqlinputt1.sql >/dev/null 2>&1
  66 else
  67    if [ $DSN = "db2" ]
  68    then
  69        $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/csqldb2inputtest1.sql  >/dev/null 2>&1
  70    else
  71        $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/csqlinputtest1.sql  >/dev/null 2>&1
  72    fi
  73 fi
  74
  75 if [ $? -ne 0 ]
  76 then
  77     echo "Server not opened"
  78     exit 4
  79 fi
  80
  81 $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/selectstar.sql >/dev/null 2>&1
  82 isql $DS < $REL_PATH/selectstar.sql
  83
  84 if [ $DSN = "oracle" ]
  85 then
  86    echo "select * from t1 where f1 in(10,30,50,54);" >> $REL_PATH/oraselect.sql
  87    echo "select * from t1 where f1 between 20 and 54;" >> $REL_PATH/oraselect.sql
  88    echo "update t1 set f2='LLL' where f1=20;" >> $REL_PATH/oraupdate.sql
  89    echo "delete from t1 where f2='BBB';" >> $REL_PATH/oradelete.sql
  90    $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/oraselect.sql >/dev/null 2>&1
  91    $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/oraupdate.sql >/dev/null 2>&1
  92    $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/oradelete.sql >/dev/null 2>&1
  93    $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/selectstar.sql >/dev/null 2>&1
  94 else
  95    $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/select.sql >/dev/null 2>&1
  96    if [ $DSN = "db2" ]
  97    then
  98        $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/db2update.sql >/dev/null 2>&1
  99    else
 100        $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/update.sql >/dev/null 2>&1
 101    fi
 102    $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/delete.sql >/dev/null 2>&1
 103    $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/selectstar.sql >/dev/null 2>&1
 104 fi
 105
 106 isql $DS < $REL_PATH/selectstar.sql
 107 isql $DS < $REL_PATH/dropt1t2t3.sql > /dev/null 2>&1
 108 rm -f /tmp/csql/csqltable.conf
 109 rm -f $REL_PATH/ora*.sql
 110 touch /tmp/csql/csqltable.conf
 111 kill -9 $pid
 112 ipcrm -M 1199 -M 2277
 113 exit 0;