test/cache/MultiDsn/Gateway/test020.ksh

   1 #!/bin/ksh
   2
   3 # 1.Make sure Default DSN is psql(CACHE_TABLE=psql)
   4 #   DSN entries in csqlds.conf file for MySQL and Postgres.
   5 #   Create table 't1'and 't2' in MySQL with all supported
   6 #   data types in it with 5 records.
   7 #   Create table 'tt1' and 'tt2' in Postgres with all supported
   8 #   data type with 5 records.
   9 #   cache 't1' from MySQL and 'tt1' from Postgres.
  10 #   Select records from 't1' and 'tt1' table using Gateway,
  11 #   it should fetch the records from csql.
  12 #   Select records from 't2' and 'tt2' using gateway,
  13 #   it should fetch the records from their respective TDB.
  14
  15 # Run thsi test only under csql/test or on this directory,
  16 # Otherwise it may fail.
  17
  18 input=${PWD}/cache/MultiDsn/Gateway/mysqltable.sql
  19 REL_PATH=.
  20 if [ -s "$input" ]
  21 then
  22   REL_PATH=${PWD}/cache/MultiDsn/Gateway
  23 fi
  24
  25 rm -f /tmp/csql.conf
  26 cp $REL_PATH/csql.conf /tmp
  27 export CSQL_CONFIG_FILE=/tmp/csql.conf
  28
  29 echo DSN=$POSTGRES_DSN  >>$CSQL_CONFIG_FILE
  30
  31 rm -f /tmp/csql/csqlds.conf
  32 touch /tmp/csql/csqlds.conf
  33
  34         ##########  csqlds.conf entries  #########
  35
  36 $CSQL_INSTALL_ROOT/bin/csqlds -U $MYSQL_USER -P $MYSQL_PASSWORD -D $MYSQL_DSN -N $MYSQL_TDB -a
  37 if [ $? -ne 0 ]
  38 then
  39    exit 1;
  40 fi
  41 echo "Entries made for $MYSQL_DSN  in csqlds.conf file."
  42
  43 $CSQL_INSTALL_ROOT/bin/csqlds -U $POSTGRES_USER -P $POSTGRES_PASSWORD -D $POSTGRES_DSN -N $POSTGRES_TDB -a
  44 if [ $? -ne 0 ]
  45 then
  46    exit 2;
  47 fi
  48 echo "Entries made for $POSTGRES_DSN in csqlds.conf file."
  49
  50                  ##########  END  #########
  51
  52
  53      ########## Table in MYSQL and POSTGRES #######
  54
  55 isql $DS1 < ${REL_PATH}/mysqltable.sql >/dev/null 2>&1
  56 if [ $? -ne 0 ]
  57 then
  58    exit 3;
  59 fi
  60 echo "Table 't1 and t2' is created in $MYSQL_DSN"
  61
  62 echo "SELECT records from $MYSQL_DSN"
  63 isql $DS1 < ${REL_PATH}/mysqlselect.sql
  64 if [ $? -ne 0 ]
  65 then
  66    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  67    exit 4;
  68 fi
  69
  70 isql $DS2 < ${REL_PATH}/psqltable.sql >/dev/null 2>&1
  71 if [ $? -ne 0 ]
  72 then
  73    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  74    isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  75    exit 5;
  76 fi
  77 echo "Table 'tt1 and tt2' is created in $POSTGRES_DSN"
  78
  79 echo "SELECT records from $POSTGRES_DSN"
  80 isql $DS2 < ${REL_PATH}/psqlselect.sql
  81 if [ $? -ne 0 ]
  82 then
  83    isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
  84    exit 6;
  85 fi
  86
  87                  ######### END #########
  88
  89
  90 rm -f /tmp/csql/csqltable.conf
  91 touch /tmp/csql/csqltable.conf
  92
  93 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  94 pid=$!
  95 sleep 5
  96
  97             ######### Cache t1 and tt1 table ##########
  98
  99
 100 $CSQL_INSTALL_ROOT/bin/cachetable -t t1 -d $MYSQL_DSN >/dev/null 2>&1
 101 if [ $? -ne 0 ]
 102 then
 103    kill -9 $pid
 104    ipcrm -M 1199 -M 2277
 105    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 106    isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 107    exit 7;
 108 fi
 109 echo "Table t1 is cached from $MYSQL_DSN."
 110
 111 $CSQL_INSTALL_ROOT/bin/cachetable -t tt1 -d >/dev/null 2>&1
 112 if [ $? -ne 0 ]
 113 then
 114    kill -9 $pid
 115    ipcrm -M 1199 -M 2277
 116    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 117    isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 118    exit 8;
 119 fi
 120 echo "Table 'tt1' is cached from $POSTGRES_DSN."
 121
 122                  ######## END ########
 123
 124
 125         ####### Fetch cached tables and non-cache table ######
 126
 127 echo ""
 128 echo "Select records using Gateway(csql -g)"
 129 echo "select records from t1 and t2"
 130 $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/mysqlselect.sql
 131 if [ $? -ne 0 ]
 132 then
 133    kill -9 $pid
 134    ipcrm -M 1199 -M 2277
 135    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 136    isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 137    exit 9;
 138 fi
 139
 140 echo "select records from tt1 and tt2."
 141 $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/psqlselect.sql
 142 if [ $? -ne 0 ]
 143 then
 144    kill -9 $pid
 145    ipcrm -M 1199 -M 2277
 146    isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 147    isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 148    exit 10;
 149 fi
 150
 151 rm -f /tmp/csql/csqltable.conf
 152 touch /tmp/csql/csqltable.conf
 153
 154 isql $DS1 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 155 isql $DS2 < ${REL_PATH}/drop.sql >/dev/null 2>&1
 156
 157
 158 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop.sql > /dev/null 2>&1
 159 kill -9 $pid
 160 ipcrm -M 1199 -M 2277
 161 exit 0;
 162
 163                      ######### END #########