test/cache/MultiDsn/Connection/test001.ksh

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