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"
58 isql
$DSN < $REL_PATH/mysqlcreatelogtable.sql
>/dev
/null
2>&1
59 echo Log table created
in target DB
60 isql
$DSN < $REL_PATH/create100table.sql
>/dev
/null
61 rm -f /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
62 touch /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
63 isql
$DSN <$REL_PATH/deletetrigger100.sql
>/dev
/null
65 export CSQL_CONFIG_FILE
=$REL_PATH/csql1.conf
67 for (( a
=1; a
<=100; a
++ ))
70 done >> /tmp
/csql
/csqltable.conf
72 $CSQL_INSTALL_ROOT/bin
/csqlserver
-c >/dev
/null
2>&1 &
77 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/selectfrom100.sql
80 echo "unable to locate cache 1"
81 isql
$DSN < ${REL_PATH}/drop100table.sql
>/dev
/null
2>&1
82 rm -f $REL_PATH/create100table.sql
83 rm -f $REL_PATH/deletefrom100table.sql
84 rm -f $REL_PATH/selectfrom100.sql
85 rm -f $REL_PATH/drop100table.sql
86 rm -f $REL_PATH/dropdeletetrigger.sql
87 rm -f $REL_PATH/deletetrigger100.sql
91 echo "Delete some record in target database"
92 isql
$DSN < ${REL_PATH}/deletefrom100table.sql
>/dev
/null
2>&1
94 echo "Records in csql after Delete some recode from target DB"
95 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/selectfrom100.sql
97 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop100table.sql
> /dev
/null
2>&1
98 isql
$DSN < ${REL_PATH}/drop100table.sql
>/dev
/null
2>&1
99 rm -f /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
100 touch /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
101 isql
$DSN < $REL_PATH/dropdeletetrigger.sql
>/dev
/null
2>&1
102 isql
$DSN < $REL_PATH/mysqldeletelogtable.sql
>/dev
/null
2>&1
104 ipcrm
-M 4000 -M 4500
106 rm -f $REL_PATH/create100table.sql
107 rm -f $REL_PATH/deletefrom100table.sql
108 rm -f $REL_PATH/selectfrom100.sql
109 rm -f $REL_PATH/drop100table.sql
110 rm -f $REL_PATH/deletetrigger100.sql
111 rm -f $REL_PATH/dropdeletetrigger.sql