3 # Create table t1 in Target DB and insert 5 records in TDB.
4 # Cache t1 table using cachetable -t option.
5 # Create table t2 at CSQL and insert 5 records.
6 # Do all DML Operations in both cached as well as non-cached tables.
7 # Both Cached and Non-Cached tables should be durable, and The data Should be Consistent
9 CSQL_CONF
=${PWD}/cache
/Durability
/csql.conf
11 if [ -s "$CSQL_CONF" ]
13 REL_PATH
=${PWD}/cache
/Durability
17 cp $CSQL_CONFIG_FILE /tmp
/csql.conf
18 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
19 echo CACHE_TABLE
=true
>>$CSQL_CONFIG_FILE
20 echo DURABILITY
=true
>>$CSQL_CONFIG_FILE
21 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
22 echo SYS_DB_KEY
=2288 >>$CSQL_CONFIG_FILE
23 echo USER_DB_KEY
=3377 >>$CSQL_CONFIG_FILE
24 DS
="$DSN $DBUSER $PASSWORD"
25 rm -f /tmp
/csql
/csqlds.conf
/tmp
/csql
/csqltable.conf
26 touch /tmp
/csql
/csqlds.conf
/tmp
/csql
/csqltable.conf
31 $CSQL_INSTALL_ROOT/bin
/csqlds
-U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
38 echo INSERTING
5 RECORDS IN TARGET DB
39 isql
$DS < ${REL_PATH}/create_insert_attdb.sql
>/dev
/null
2>&1
42 isql
$DS < ${REL_PATH}/drop_t1.sql
46 isql
$DS < ${REL_PATH}/select_t1.sql
49 isql
$DS < ${REL_PATH}/drop_t1.sql
53 # RUN CSQL SERVER at site
54 $CSQL_INSTALL_ROOT/bin
/csqlserver
> /dev
/null
2>&1 &
58 echo "CACHING THROUGH SITE1"
59 echo "cachetable -U root -P manager -t t1"
60 $CSQL_INSTALL_ROOT/bin
/cachetable
-U root
-P manager
-t t1
64 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
65 isql
$DS < ${REL_PATH}/drop_t1.sql
69 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_insert_at_csql.sql
73 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
74 isql
$DS < ${REL_PATH}/drop_t1.sql
75 $CSQL_INSTALL_ROOT/bin
/cachetable
-U root
-P manager
-t t1
-u
79 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
82 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
86 echo "Durablity = TRUE"
88 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
91 echo "Checking Durability"
92 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
93 diff before.sql after.sql
96 echo Durability Works Fine
98 echo Durability Does Not work fine
100 #Insertion in cached table at csql
101 echo INSERTING
5 RECORDS IN CACHED TABLE t1 AT CSQL
102 $CSQL_INSTALL_ROOT/bin
/csql
-g -u root
-p manager
-s ${REL_PATH}/insert5_atsite1.sql
106 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
107 isql
$DS < ${REL_PATH}/drop_t1.sql
108 $CSQL_INSTALL_ROOT/bin
/cachetable
-U root
-P manager
-t t1
-u
112 echo INSERTING
5 RECORDS AT NON CACHED TABLE t2 AT CSQL
113 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/noncached_insert_t2.sql
117 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
118 isql
$DS < ${REL_PATH}/drop_t1.sql
119 $CSQL_INSTALL_ROOT/bin
/cachetable
-U root
-P manager
-t t1
-u
123 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
126 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
129 echo "Durablity = TRUE"
130 echo "Server Started"
131 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
134 echo "Checking Durability"
135 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
136 diff before.sql after.sql
139 echo Durability Works Fine
141 echo Durability Does Not work fine
144 #Updation in cached table at csql
145 echo UPDATING
5 RECORDS IN CACHED TABLE t1 AT CSQL
146 $CSQL_INSTALL_ROOT/bin
/csql
-g -u root
-p manager
-s ${REL_PATH}/update5_atsite1.sql
150 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
151 isql
$DS < ${REL_PATH}/drop_t1.sql
152 $CSQL_INSTALL_ROOT/bin
/cachetable
-U root
-P manager
-t t1
-u
156 echo UPDATING
5 RECORDS AT NON CACHED TABLE t2 AT CSQL
157 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/noncached_update_t2.sql
161 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
162 isql
$DS < ${REL_PATH}/drop_t1.sql
163 $CSQL_INSTALL_ROOT/bin
/cachetable
-U root
-P manager
-t t1
-u
167 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
170 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
174 echo "Durablity = TRUE"
175 echo "Server Started"
176 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
179 echo "Checking Durability"
180 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
181 diff before.sql after.sql
184 echo Durability Works Fine
186 echo Durability Does Not work fine
189 #Deletion in cached table at csql
190 echo DELETING
7 RECORDS IN CACHED TABLE t1 AT CSQL
191 $CSQL_INSTALL_ROOT/bin
/csql
-g -u root
-p manager
-s ${REL_PATH}/delete7_atsite1.sql
195 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
196 isql
$DS < ${REL_PATH}/drop_t1.sql
197 $CSQL_INSTALL_ROOT/bin
/cachetable
-U root
-P manager
-t t1
-u
201 echo DELETING
7 RECORDS AT NON CACHED TABLE t2 AT CSQL
202 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/noncached_delete_t2.sql
206 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
207 isql
$DS < ${REL_PATH}/drop_t1.sql
208 $CSQL_INSTALL_ROOT/bin
/cachetable
-U root
-P manager
-t t1
-u
212 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
215 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
219 echo "Durablity = TRUE"
220 echo "Server Started"
221 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
224 echo "Checking Durability"
225 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
226 diff before.sql after.sql
229 echo Durability Works Fine
231 echo Durability Does Not work fine
234 #export CSQL_CONFIG_FILE=/tmp/site/csql.conf
235 $CSQL_INSTALL_ROOT/bin
/cachetable
-U root
-P manager
-t t1
-u
239 rm -f before.sql after.sql
240 rm -M 2288 -M 3377 -M 1947 -Q 2525
244 isql
$DS < ${REL_PATH}/drop_t1.sql
248 rm -f before.sql after.sql
249 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525
253 echo "drop table t2;" >${REL_PATH}/drop_t2.sql
254 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_t2.sql
256 rm -f ${REL_PATH}/drop_t2.sql
257 rm -f before.sql after.sql
260 ipcrm
-M 2288 -M 3377 -M 1947 -Q 2525