test/cache/MultiDsn/Connection/test002.ksh

   1 #!/bin/ksh
   2 #Test Case
   3
   4 # 2.csqlds.conf fiel has no entries for MySQL and Postgres
   5 #
   6 # Create table t1 in MySQL and t10 in Postgres.
   7 # CACHE_TABLE=true in cql.conf file.
   8 # cache t1 and t10 from respective TDB.
   9 # It should fail.
  10 #
  11 # Author : Jitendra Lenka
  12
  13 input=${PWD}/cache/MultiDsn/Connection/mysqltable.sql
  14 REL_PATH=.
  15 if [ -s "$input" ]
  16 then
  17    REL_PATH=${PWD}/cache/MultiDsn/Connection
  18 fi
  19
  20 rm -f /tmp/csql.conf
  21 cp $REL_PATH/csql.conf /tmp
  22 export CSQL_CONFIG_FILE=/tmp/csql.conf
  23
  24 echo DSN=$MYSQL_DSN >>$CSQL_CONFIG_FILE
  25
  26
  27 rm -f /tmp/csql/csqlds.conf
  28 touch /tmp/csql/csqlds.conf
  29
  30
  31 isql $DS1 < ${REL_PATH}/mysqltable.sql >/dev/null 2>&1
  32 if [ $? -ne 0 ]
  33 then
  34    exit 3;
  35 fi
  36 echo "Table 't1' is created in MySQL."
  37
  38 isql $DS2 < ${REL_PATH}/psqltable.sql >/dev/null 2>&1
  39 if [ $? -ne 0 ]
  40 then
  41    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  42    exit 4;
  43 fi
  44 echo "Table 't10' is created in Postgres"
  45
  46 rm -f /tmp/csql/csqltable.conf
  47 touch /tmp/csql/csqltable.conf
  48
  49 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  50 pid=$!
  51 sleep 5
  52 #echo $CSQL_INSTALL_ROOT
  53 $CSQL_INSTALL_ROOT/bin/cachetable -U root -P manager -t t1  >/dev/null 2>&1
  54 if [ $? -eq 0 ]
  55 then
  56    kill -9 $pid
  57    ipcrm -M 1199 -M 2277
  58    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  59    isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  60    exit 5;
  61 fi
  62 echo "Table 't1' is not cached."
  63
  64 $CSQL_INSTALL_ROOT/bin/cachetable -t t10 -d $POSTGRES_DSN >/dev/null 2>&1
  65 if [ $? -eq 0 ]
  66 then
  67    kill -9 $pid
  68    ipcrm -M 1199 -M 2277
  69    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  70    isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  71
  72    exit 6;
  73 fi
  74 echo "Table 't10' is not cached."
  75
  76 rm -f /tmp/csql/csqltable.conf
  77 touch /tmp/csql/csqltable.conf
  78
  79 isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  80 isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  81 echo "Table 't1' and 't10' is dropped from their respective TDB."
  82
  83 kill -9 $pid
  84 ipcrm -M 1199 -M 2277
  85 exit 0;
  86