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