test/cache/MultiDsn/Connection/test005.ksh

   1 #!/bin/ksh
   2 #Test Case
   3
   4 # 5.csqlds.conf fiel has the entries for Postgres and not for MySQL.
   5 #
   6 # Create table t1 in MyQL and t10 in Postgres.
   7 # CACHE_TABLE=true in cql.conf file.
   8 # cache t1 and t10 from respective TDB,
   9 # The table 't1' will not be cached.
  10 #
  11 # Author : Jitendra
  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 rm -f /tmp/csql/csqlds.conf
  27 touch /tmp/csql/csqlds.conf
  28
  29 $CSQL_INSTALL_ROOT/bin/csqlds -U $POSTGRES_USER -P $POSTGRES_PASSWORD -D $POSTGRES_DSN -N $POSTGRES_TDB -a
  30 if [ $? -ne 0 ]
  31 then
  32    exit 1;
  33 fi
  34 echo "Entry made for $POSTGRES_DSN in csqlds.conf file"
  35
  36 isql $DS1 < ${REL_PATH}/mysqltable.sql >/dev/null 2>&1
  37 if [ $? -ne 0 ]
  38 then
  39    exit 3;
  40 fi
  41 echo "Table t1 is created in $MYSQL_TDB ."
  42
  43 isql $DS2 < ${REL_PATH}/psqltable.sql >/dev/null 2>&1
  44 if [ $? -ne 0 ]
  45 then
  46    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  47    exit 4;
  48 fi
  49 echo "Table t10 is created in $POSTGRES_TDB"
  50
  51 rm -f /tmp/csql/csqltable.conf
  52 touch /tmp/csql/csqltable.conf
  53
  54 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  55 pid=$!
  56 sleep 5
  57 echo "CSQL Server is started."
  58
  59 $CSQL_INSTALL_ROOT/bin/cachetable -U root -P manager -t t1  >/dev/null 2>&1
  60 if [ $? -eq 0 ]
  61 then
  62    kill -9 $pid
  63    ipcrm -M 1199 -M 2277
  64    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  65    isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  66    exit 5;
  67 fi
  68 echo "Table 't1' is not cached from $MYSQL_DSN"
  69
  70 $CSQL_INSTALL_ROOT/bin/cachetable -t t10 -d $POSTGRES_DSN > /dev/null 2>&1
  71 if [ $? -ne 0 ]
  72 then
  73    kill -9 $pid
  74    ipcrm -M 1199 -M 2277
  75    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  76    isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  77    exit 6;
  78 fi
  79 echo "Table 't10' is cached from $POSTGRES_DSN"
  80
  81 rm -f /tmp/csql/csqltable.conf
  82 touch /tmp/csql/csqltable.conf
  83
  84 isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  85 isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  86 echo "Table t1 and t10 is dropped in TDB."
  87
  88 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop.sql > /dev/null 2>&1
  89 echo "Table is dropped in CSQL."
  90 kill -9 $pid
  91 ipcrm -M 1199 -M 2277
  92 exit 0;
  93