3 # Create table t1 in Target DB and insert 1 records in TDB.
4 # Set CACHE_TABLE=true in csql.conf
5 # Create a table t1 with same schema as TDB at CSQL.
6 # DML happen in CSQL, Should not propagate to target Database
8 CSQL_CONF
=${PWD}/cache
/CacheTable
/csql.conf
10 if [ -s "$CSQL_CONF" ]
12 REL_PATH
=${PWD}/cache
/CacheTable
16 cp $REL_PATH/csql.conf
/tmp
17 export CSQL_CONFIG_FILE
=/tmp
/csql.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
31 mkdir
-p /tmp
/CSQL
/log
32 mkdir
-p /tmp
/CSQL
/log
/csql
35 cp /tmp
/csql.conf
/tmp
/CSQL
/
36 echo SYS_DB_KEY
=2288 >>/tmp
/CSQL
/csql.conf
37 echo USER_DB_KEY
=3377 >>/tmp
/CSQL
/csql.conf
38 echo LOG_FILE
=/tmp
/CSQL
/log
/csql
/log.out
>>/tmp
/CSQL
/csql.conf
39 echo DATABASE_FILE
=/tmp
/CSQL
/db
>>/tmp
/CSQL
/csql.conf
40 echo CACHE_TABLE
=true
>>/tmp
/CSQL
/csql.conf
41 echo SITE_ID
=1 >>/tmp
/CSQL
/csql.conf
42 echo TABLE_CONFIG_FILE
=/tmp
/CSQL
/csqltable.conf
>>/tmp
/CSQL
/csql.conf
44 echo CREATING TABLE t1 and INSERTING
1 RECORDS IN TARGET DB
45 if [ "$DSN" = "sybase" ]
47 isql
$DS < ${REL_PATH}/cre_ins_sybase.sql
49 isql
$DS < ${REL_PATH}/cre_ins_tdb.sql
53 isql
$DS < ${REL_PATH}/drop_t1.sql
57 # Setup Environment For CSQL
58 export CSQL_CONFIG_FILE
=/tmp
/CSQL
/csql.conf
59 rm -f /tmp
/CSQL
/csqltable.conf
60 touch /tmp
/CSQL
/csqltable.conf
62 # RUN CSQL SERVER at CSQL
63 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
68 echo CREATING TABLE t1 and INSERTING
1 RECORDS AT CSQL
69 $CSQL_INSTALL_ROOT/bin
/csql
-g -u root
-p manager
-s ${REL_PATH}/cre_ins_csql.sql
74 isql
$DS < ${REL_PATH}/drop_t1.sql
78 echo "AFTER INSERT AT CSQL DATA IN TDB"
79 isql
$DS < ${REL_PATH}/select_t1.sql
84 isql
$DS < ${REL_PATH}/drop_t1.sql
88 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drop_t1.sql
96 isql
$DS < ${REL_PATH}/drop_t1.sql
100 ipcrm
-M 2288 -M 3377
106 ipcrm
-M 2288 -M 3377