test/cache/MultiDsn/Connection/test006.ksh

   1 #!/bin/ksh
   2 #Test Case
   3
   4 # 6.csqlds.conf file has the entries for MySQL and Postgres
   5 #   Default DSN is "psql" set in csql.conf file
   6
   7 # Create table t1 in MyQL and t10 in Postgres.
   8 # select t1 and t10 from their respecrtive TDB.
   9 # CACHE_TABLE=true in csql.conf file.
  10 # cache t1 and t10 from respective TDB.
  11 # select t1 and t10 from CSQL.
  12 #
  13 # Author: Jitendra
  14
  15 input=${PWD}/cache/MultiDsn/Connection/mysqltable.sql
  16 REL_PATH=.
  17 if [ -s "$input" ]
  18 then
  19    REL_PATH=${PWD}/cache/MultiDsn/Connection
  20 fi
  21
  22 rm -f /tmp/csql.conf
  23 cp $REL_PATH/csql.conf /tmp
  24 export CSQL_CONFIG_FILE=/tmp/csql.conf
  25
  26 echo DSN=$POSTGRES_DSN >>$CSQL_CONFIG_FILE
  27
  28 rm -f /tmp/csql/csqlds.conf
  29 touch /tmp/csql/csqlds.conf
  30
  31
  32 $CSQL_INSTALL_ROOT/bin/csqlds -U $MYSQL_USER -P $MYSQL_PASSWORD -D $MYSQL_DSN -N $MYSQL_TDB -a
  33 if [ $? -ne 0 ]
  34 then
  35    exit 1;
  36 fi
  37 echo "Entries made for $MYSQL_DSN in csqlds.conf file."
  38
  39 $CSQL_INSTALL_ROOT/bin/csqlds -U $POSTGRES_USER -P $POSTGRES_PASSWORD -D $POSTGRES_DSN -N $POSTGRES_TDB -a
  40 if [ $? -ne 0 ]
  41 then
  42    exit 2;
  43 fi
  44 echo "Entries made for $POSTGRES_DSN in csqlds.conf file."
  45
  46
  47 isql $DS1 < ${REL_PATH}/mysqltable.sql >/dev/null 2>&1
  48 if [ $? -ne 0 ]
  49 then
  50    exit 3;
  51 fi
  52 echo "Table 't1' is created in $MYSQL_DSN"
  53
  54 isql $DS1 < ${REL_PATH}/selectt1.sql
  55 if [ $? -ne 0 ]
  56 then
  57    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  58    exit 4;
  59 fi
  60
  61 isql $DS2 < ${REL_PATH}/psqltable.sql >/dev/null 2>&1
  62 if [ $? -ne 0 ]
  63 then
  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 ""
  69 echo "Table 't10' is created in $POSTGRES_DSN"
  70
  71 isql $DS2 < ${REL_PATH}/selectt10.sql
  72 if [ $? -ne 0 ]
  73 then
  74    isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  75    exit 6;
  76 fi
  77
  78 rm -f /tmp/csql/csqltable.conf
  79 touch /tmp/csql/csqltable.conf
  80
  81 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  82 pid=$!
  83 sleep 5
  84
  85 $CSQL_INSTALL_ROOT/bin/cachetable -t t1 -d $MYSQL_DSN >/dev/null 2>&1
  86 if [ $? -ne 0 ]
  87 then
  88    kill -9 $pid
  89    ipcrm -M 1199 -M 2277
  90    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  91    isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  92    exit 7;
  93 fi
  94 echo ""
  95 echo "Table t1 is cached from $MYSQL_DSN."
  96
  97 echo "select * from t1"
  98 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/selectt1.sql
  99 if [ $? -ne 0 ]
 100 then
 101    kill -9 $pid
 102    ipcrm -M 1199 -M 2277
 103    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 104    isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 105    exit 8;
 106 fi
 107
 108
 109 $CSQL_INSTALL_ROOT/bin/cachetable -t t10  > /dev/null 2>&1
 110 if [ $? -ne 0 ]
 111 then
 112    kill -9 $pid
 113    ipcrm -M 1199 -M 2277
 114    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 115    isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 116    exit 9;
 117 fi
 118 echo ""
 119 echo "Table 't10' is cached from $POSTGRES_DSN."
 120
 121 echo "select * from t10."
 122 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/selectt10.sql
 123 if [ $? -ne 0 ]
 124 then
 125    kill -9 $pid
 126    ipcrm -M 1199 -M 2277
 127    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 128    isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 129    exit 10;
 130 fi
 131
 132
 133 rm -f /tmp/csql/csqltable.conf
 134 touch /tmp/csql/csqltable.conf
 135
 136 isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 137 isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 138
 139
 140 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop.sql > /dev/null 2>&1
 141 kill -9 $pid
 142 ipcrm -M 1199 -M 2277
 143 exit 0;
 144