3 # Create 100 table in target database with a integer primary key.
4 # Run trigger for all table. Make sure Log table is in target database
5 # Run cache server with bi-directional and cache flag true. Cache all tables.
6 # Delete some record in each table in target database. Check in csql node records are inserted or not.
9 input
=${PWD}/cache
/Bidirectional
/mysqlcreatelogtable.sql
14 REL_PATH
=${PWD}/cache
/Bidirectional
17 for((a
=1; a
<=100; a
++))
19 echo "create table t$a(f1 int,f2 int,primary key(f1));"
20 echo "insert into t$a values(1,2);"
21 echo "insert into t$a values(10,20);"
22 echo "insert into t$a values(11,21);"
23 done >>$REL_PATH/create100table.sql
24 echo "table creation file created"
26 for((a
=1; a
<=100; a
++))
28 echo "echo select * from t$a;"
29 echo "select * from t$a;"
30 done >>$REL_PATH/selectfrom100.sql
31 echo "select file created"
33 for((a
=1; a
<=100; a
++))
35 echo "drop table t$a;"
36 done >>$REL_PATH/drop100table.sql
38 echo "use test;">>$REL_PATH/deletetrigger100.sql
39 for((a
=1; a
<=100; a
++))
41 echo "drop trigger if exists triggerdeletet$a;"
42 echo "create trigger triggerdeletet$a AFTER DELETE on t$a FOR EACH ROW BEGIN Insert into csql_log_int (tablename, pkid, operation,cacheid) values ('t$a', OLD.f1, 2,1); End;"
43 done >> $REL_PATH/deletetrigger100.sql
44 echo "Trigger file generated"
46 for((a
=1; a
<=100; a
++))
48 echo "drop trigger if exists triggerdeletet$a;"
49 done >>$REL_PATH/dropdeletetrigger.sql
50 echo "Drop trigger file generated"
52 for((a
=1; a
<=100; a
++))
54 echo "delete from t$a where f2 >19;"
55 done >> $REL_PATH/deletefrom100table.sql
56 echo "Update file created"
59 cp $REL_PATH/csql1.conf
/tmp
60 export CSQL_CONFIG_FILE
=/tmp
/csql1.conf
61 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
63 isql
$DSN < $REL_PATH/mysqlcreatelogtable.sql
>/dev
/null
2>&1
66 echo "DSN is not set for target db"
67 rm -f $REL_PATH/create100table.sql
68 rm -f $REL_PATH/deletefrom100table.sql
69 rm -f $REL_PATH/selectfrom100.sql
70 rm -f $REL_PATH/drop100table.sql
71 rm -f $REL_PATH/dropdeletetrigger.sql
72 rm -f $REL_PATH/deletetrigger100.sql
75 echo Log table created
in target DB
76 isql
$DSN < $REL_PATH/create100table.sql
>/dev
/null
77 rm -f /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
78 touch /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
79 isql
$DSN <$REL_PATH/deletetrigger100.sql
>/dev
/null
81 for (( a
=1; a
<=100; a
++ ))
83 echo "1:t$a NULL NULL NULL"
84 done >> /tmp
/csql
/csqltable.conf
86 $CSQL_INSTALL_ROOT/bin
/csqlserver
-c >/dev
/null
2>&1 &
91 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/selectfrom100.sql
94 echo "unable to locate cache 1"
95 isql
$DSN < ${REL_PATH}/drop100table.sql
>/dev
/null
2>&1
96 rm -f $REL_PATH/create100table.sql
97 rm -f $REL_PATH/deletefrom100table.sql
98 rm -f $REL_PATH/selectfrom100.sql
99 rm -f $REL_PATH/drop100table.sql
100 rm -f $REL_PATH/dropdeletetrigger.sql
101 rm -f $REL_PATH/deletetrigger100.sql
105 echo "Delete some record in target database"
106 isql
$DSN < ${REL_PATH}/deletefrom100table.sql
>/dev
/null
2>&1
108 echo "Records in csql after Delete some recode from target DB"
109 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/selectfrom100.sql
111 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop100table.sql
> /dev
/null
2>&1
112 isql
$DSN < ${REL_PATH}/drop100table.sql
>/dev
/null
2>&1
113 rm -f /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
114 touch /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
115 isql
$DSN < $REL_PATH/dropdeletetrigger.sql
>/dev
/null
2>&1
116 isql
$DSN < $REL_PATH/mysqldeletelogtable.sql
>/dev
/null
2>&1
118 ipcrm
-M 4000 -M 4500
120 rm -f $REL_PATH/create100table.sql
121 rm -f $REL_PATH/deletefrom100table.sql
122 rm -f $REL_PATH/selectfrom100.sql
123 rm -f $REL_PATH/drop100table.sql
124 rm -f $REL_PATH/deletetrigger100.sql
125 rm -f $REL_PATH/dropdeletetrigger.sql