test/sqlgw/Parameter/test006.ksh

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