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 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/insertinto100.sql
69 rm -f $REL_PATH/selectfrom100.sql
70 rm -f $REL_PATH/drop100table.sql
71 rm -f $REL_PATH/inserttrigger100.sql
72 rm -f $REL_PATH/dropinserttrigger.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/inserttrigger100.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/insertinto100.sql
98 rm -f $REL_PATH/selectfrom100.sql
99 rm -f $REL_PATH/drop100table.sql
100 rm -f $REL_PATH/inserttrigger100.sql
101 rm -f $REL_PATH/dropinserttrigger.sql
105 echo "Insert some record in target database"
106 isql
$DSN < ${REL_PATH}/insertinto100.sql
>/dev
/null
2>&1
109 echo "Records in csql after insert in target DB"
110 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/selectfrom100.sql
112 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop100table.sql
> /dev
/null
2>&1
113 isql
$DSN < ${REL_PATH}/drop100table.sql
>/dev
/null
2>&1
114 rm -f /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
115 touch /tmp
/csql
/csqltable.conf
/tmp
/csql
/csql.db
116 isql
$DSN < $REL_PATH/dropinserttrigger.sql
>/dev
/null
2>&1
117 isql
$DSN < $REL_PATH/mysqldeletelogtable.sql
>/dev
/null
2>&1
119 ipcrm
-M 4000 -M 4500
121 rm -f $REL_PATH/create100table.sql
122 rm -f $REL_PATH/insertinto100.sql
123 rm -f $REL_PATH/selectfrom100.sql
124 rm -f $REL_PATH/drop100table.sql
125 rm -f $REL_PATH/inserttrigger100.sql
126 rm -f $REL_PATH/dropinserttrigger.sql