3 CSQL_CONF
=${PWD}/sqlgw
/Select
/csql.conf
7 REL_PATH
=${PWD}/sqlgw
/Select
10 cp $REL_PATH/csql.conf
/tmp
/csql.conf
12 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
13 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
14 DS
="$DSN $DBUSER $PASSWORD"
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
22 $CSQL_INSTALL_ROOT/bin
/csqlds
-U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
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" ]
33 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
34 elif [ $DSN = "oracle" ]
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
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
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
44 isql
$DS < create.sql
>/dev
/null
2>&1
46 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
50 echo "drop table t1;" > drop.sql
52 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t1
55 isql
$DS < drop.sql
>/dev
/null
2>&1
57 ipcrm
-M 4567 -M 5678 -M 1950
58 rm -f create.sql drop.sql
62 if [ $VALGRIND = "true" ]
64 valgrind
--tool=memcheck
--leak-check=full
${REL_PATH}/selecttest2
2> $0.valgr
66 ${REL_PATH}/selecttest2
69 isql
$DS < drop.sql
>/dev
/null
2>&1
70 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t1
-u
72 ipcrm
-M 4567 -M 5678 -M 1950
73 rm -f create.sql drop.sql
78 isql
$DS < drop.sql
>/dev
/null
2>&1
79 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t1
-u
81 ipcrm
-M 4567 -M 5678 -M 1950
83 rm -f create.sql drop.sql