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 # Insert 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 done >> $REL_PATH/create100table.sql
22 echo "table creation file created"
24 for((a
=1; a
<=100; a
++))
26 echo "insert into t$a values(10,20);"
27 echo "insert into t$a values(11,21);"
29 done >> $REL_PATH/insertinto100.sql
30 echo "insert record file creates"
32 for((a
=1; a
<=100; a
++))
34 echo "echo select * from t$a;"
35 echo "select * from t$a;"
36 done >>$REL_PATH/selectfrom100.sql
37 echo "select file created"
39 for((a
=1; a
<=100; a
++))
41 echo "drop table t$a;"
42 done >>$REL_PATH/drop100table.sql
44 echo "use test;">>$REL_PATH/inserttrigger100.sql
45 for((a
=1; a
<=100; a
++))
47 echo "drop trigger if exists triggerinsertt$a;"
48 echo "create trigger triggerinsertt$a AFTER INSERT on t$a FOR EACH ROW BEGIN Insert into csql_log_int (tablename, pkid, operation,cacheid) values ('t$a', NEW.f1, 1,1); End;"
49 done >> $REL_PATH/inserttrigger100.sql
50 echo "trigger file generated"
52 for((a
=1; a
<=100; a
++))
54 echo "drop trigger if exists triggerinsertt$a;"
55 done >>$REL_PATH/dropinserttrigger.sql
56 echo "drop trigger file generated"
59 isql
$DSN < $REL_PATH/mysqlcreatelogtable.sql
>/dev
/null
2>&1
60 echo Log table created
in target DB
61 isql
$DSN < $REL_PATH/create100table.sql
>/dev
/null
62 rm -f /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
63 touch /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
64 isql
$DSN <$REL_PATH/inserttrigger100.sql
>/dev
/null
66 export CSQL_CONFIG_FILE
=$REL_PATH/csql1.conf
68 for (( a
=1; a
<=100; a
++ ))
71 done >> /tmp
/csql
/csqltable.conf
73 $CSQL_INSTALL_ROOT/bin
/csqlserver
-c >/dev
/null
2>&1 &
78 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/selectfrom100.sql
81 echo "unable to locate cache 1"
82 isql
$DSN < ${REL_PATH}/drop100table.sql
>/dev
/null
2>&1
83 rm -f $REL_PATH/create100table.sql
84 rm -f $REL_PATH/insertinto100.sql
85 rm -f $REL_PATH/selectfrom100.sql
86 rm -f $REL_PATH/drop100table.sql
87 rm -f $REL_PATH/inserttrigger100.sql
88 rm -f $REL_PATH/dropinserttrigger.sql
92 echo "Insert some record in target database"
93 isql
$DSN < ${REL_PATH}/insertinto100.sql
>/dev
/null
2>&1
96 echo "Records in csql after insert in target DB"
97 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/selectfrom100.sql
99 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop100table.sql
> /dev
/null
2>&1
100 isql
$DSN < ${REL_PATH}/drop100table.sql
>/dev
/null
2>&1
101 rm -f /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
102 touch /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
103 isql
$DSN < $REL_PATH/dropinserttrigger.sql
>/dev
/null
2>&1
104 isql
$DSN < $REL_PATH/mysqldeletelogtable.sql
>/dev
/null
2>&1
106 ipcrm
-M 4000 -M 4500
108 rm -f $REL_PATH/create100table.sql
109 rm -f $REL_PATH/insertinto100.sql
110 rm -f $REL_PATH/selectfrom100.sql
111 rm -f $REL_PATH/drop100table.sql
112 rm -f $REL_PATH/inserttrigger100.sql
113 rm -f $REL_PATH/dropinserttrigger.sql