4 # Bi-directional cache test
5 # Create table t1 with field f1 int ,f2 char,f3 smallint, f4 bigint . Make bidirectional flag and cache flag true. Cache the table with -p fieldname it should fail
9 input
=${PWD}/cache
/CacheTable
/csql1.conf
14 REL_PATH
=${PWD}/cache
/CacheTable
17 cp $REL_PATH/csql1.conf
/tmp
18 export CSQL_CONFIG_FILE
=/tmp
/csql1.conf
19 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
20 DS
="$DSN $DBUSER $PASSWORD"
21 rm -f /tmp
/csql
/csqlds.conf
22 touch /tmp
/csql
/csqlds.conf
23 $CSQL_INSTALL_ROOT/bin
/csqlds
-U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
29 echo "create table t1(f1 int ,f2 char(12),f3 smallint , f4 bigint);">$REL_PATH/t1.sql
30 for a
in 1 2 3 4 5 6 7 8 9
32 echo "insert into t1 values($a,'papu',12,$a+123124);"
34 isql
$DS < $REL_PATH/t1.sql
>/dev
/null
2>&1
37 echo "unable to creste in target db"
38 rm -f $REL_PATH/t1.sql
42 echo "drop table t1;">${REL_PATH}/dt1.sql
43 rm -f /tmp
/csql
/csqltable.conf
44 touch /tmp
/csql
/csqltable.conf
46 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
50 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t1
-p f1
53 echo "Unable to cache"
54 isql
$DS <${REL_PATH}/dt1.sql
>/dev
/null
2>&1
55 rm -f $REL_PATH/t1.sql
${REL_PATH}/dt1.sql
60 isql
$DS <${REL_PATH}/dt1.sql
>/dev
/null
2>&1
61 rm -f /tmp
/csql
/csqltable.conf
62 touch /tmp
/csql
/csqltable.conf
63 rm -f $REL_PATH/t1.sql
${REL_PATH}/dt1.sql