3 # Testing All the operation in CSQl ((After Each Operation Kill the server and Restart the server again for Another Operation)
4 # Run this test only under csql/test or on this directory.
5 # Otherwise, it may fail
6 # set DURABILITY to true in csql.conf
7 # Start csqlserver. Then create a table in CSQL Client.Insert 5 Records.
8 # kill the currently running Server.
9 # Again Restart the Server by setting DURABILITY=true and Open CSQL Client.
10 # Continue The same For All Operations in CSQL.
11 # All should work Fine
14 CSQL_CONF
=${PWD}/tools
/Durability
/csql.conf
16 if [ -s "$CSQL_CONF" ]
18 REL_PATH
=${PWD}/tools
/Durability
24 cp -f $REL_PATH/csql.conf
/tmp
25 echo SYS_DB_KEY
=4444 >>/tmp
/csql.conf
26 echo USER_DB_KEY
=6666 >>/tmp
/csql.conf
27 echo "DURABILITY=true" >>/tmp
/csql.conf
28 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
30 echo "Durablity = TRUE"
32 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
36 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_10.sql
44 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
50 echo "Durablity = TRUE"
51 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
53 echo "Checking Durability"
56 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
57 diff before.sql after.sql
60 echo Durability Works Fine
63 echo "INSERTING INTO TABLE"
64 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/index_10.sql
67 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
73 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
79 echo "Durablity = TRUE"
80 echo "Checking Durability"
81 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
85 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
86 diff before.sql after.sql
89 echo Durability Works Fine
92 echo "INSERTING INTO TABLE"
93 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insert_10.sql
96 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
102 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
104 ipcrm
-M 4444 -M 6666
108 echo "Durablity = TRUE"
109 echo "Checking Durability"
110 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
112 echo "Server Started"
114 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
115 diff before.sql after.sql
118 echo Durability Works Fine
121 echo "UPDATING RECORDS IN TABLE"
122 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/update_10.sql
125 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
127 ipcrm
-M 4444 -M 6666
131 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
133 ipcrm
-M 4444 -M 6666
137 echo "Durablity = TRUE"
138 echo "Checking Durability"
139 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
141 echo "Server Started"
143 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
144 diff before.sql after.sql
147 echo Durability Works Fine
150 echo "DELETING RECORDS FROM TABLE"
151 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/delete_10.sql
154 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
156 ipcrm
-M 4444 -M 6666
160 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
162 ipcrm
-M 4444 -M 6666
166 echo "Durablity = TRUE"
167 echo "Checking Durability"
168 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
170 echo "Server Started"
172 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
173 diff before.sql after.sql
176 echo Durability Works Fine
179 echo "DROPPING TABLE"
180 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
184 ipcrm
-M 4444 -M 6666
188 rm -f before.sql after.sql
190 ipcrm
-M 4444 -M 6666