test/sqlgw/Select/test008.ksh

   1 #!/bin/ksh
   2
   3 CSQL_CONF=${PWD}/sqlgw/Select/csql.conf
   4 REL_PATH=.
   5 if [ -s "$CSQL_CONF" ]
   6 then
   7     REL_PATH=${PWD}/sqlgw/Select
   8 fi
   9 rm -f /tmp/csql.conf
  10 cp $REL_PATH/csql.conf /tmp/csql.conf
  11
  12 export CSQL_CONFIG_FILE=/tmp/csql.conf
  13 echo DSN=$DSN >>$CSQL_CONFIG_FILE
  14 DS="$DSN $DBUSER $PASSWORD"
  15
  16 rm -f /tmp/csql/csqlds.conf
  17 touch /tmp/csql/csqlds.conf
  18 rm -f /tmp/csql/csqltable.conf
  19 touch /tmp/csql/csqltable.conf
  20
  21
  22 $CSQL_INSTALL_ROOT/bin/csqlds -U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
  23 if [ $? -ne 0 ]
  24 then
  25    exit 1;
  26 fi
  27
  28 if [ $DSN = "psql" ]
  29 then
  30     echo "CREATE TABLE t1(f1 INT,f2 SMALLINT,f3 CHAR(30),f4 FLOAT4,f5 FLOAT4,f6 DATE,f7 TIME,f8 TIMESTAMP,f9 INT,f10 BIGINT);" > create.sql
  31 elif [ $DSN = "sybase" ]
  32 then
  33     echo "CREATE TABLE t1(f1 INT,f2 SMALLINT,f3 CHAR(30) NULL,f4 REAL,f5 REAL,f6 DATE,f7 TIME,f8 DATETIME,f9 INT,f10 BIGINT);" > create.sql
  34 elif [ $DSN = "oracle" ]
  35 then
  36    echo "CREATE TABLE t1(f1 number(9),f2 number(4),f3 CHAR(30),f4 FLOAT,f5 FLOAT,f6 DATE,f8 TIMESTAMP,f9 number(9),f10 number(18));" > create.sql
  37 elif [ $DSN = "db2" ]
  38 then
  39     echo "CREATE TABLE t1(f1 INT,f2 SMALLINT,f3 CHAR(30), f4 REAL,f5 REAL,f6 DATE,f7 TIME,f8 TIMESTAMP,f9 INT,f10 BIGINT)" > create.sql
  40 else
  41     echo "CREATE TABLE t1(f1 INT,f2 SMALLINT,f3 CHAR(30),f4 FLOAT,f5 FLOAT,f6 DATE,f7 TIME,f8 TIMESTAMP,f9 INT,f10 BIGINT);" > create.sql
  42 fi
  43
  44 isql $DS < create.sql >/dev/null 2>&1
  45
  46 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  47 pid=$!
  48 sleep 5
  49
  50 echo "drop table t1;" > drop.sql
  51
  52 $CSQL_INSTALL_ROOT/bin/cachetable -t t1
  53 if [ $? -ne 0 ]
  54 then
  55     isql $DS < drop.sql >/dev/null 2>&1
  56     kill -9 $pid
  57     ipcrm -M 4567 -M 5678 -M 1950
  58     rm -f create.sql drop.sql
  59     exit 1;
  60 fi
  61
  62 if [ "$VALGRIND" = "true" ]
  63 then
  64     valgrind --tool=memcheck --leak-check=full ${REL_PATH}/selecttest8 2> $0.valgr
  65 else
  66     ${REL_PATH}/selecttest8
  67     if [ $? -ne 0 ]
  68     then
  69        isql $DS < drop.sql >/dev/null 2>&1
  70        $CSQL_INSTALL_ROOT/bin/cachetable -t t1 -u
  71        kill -9 $pid
  72        ipcrm -M 4567 -M 5678 -M 1950
  73        rm -f create.sql drop.sql
  74        exit 2;
  75     fi
  76 fi
  77
  78 isql $DS < drop.sql >/dev/null 2>&1
  79 $CSQL_INSTALL_ROOT/bin/cachetable -t t1 -u
  80 kill -9 $pid
  81 ipcrm -M 4567 -M 5678 -M 1950
  82 rm -f /tmp/csql.conf
  83 rm -f create.sql drop.sql
  84 exit 0;