2 # Composite Primary Key test
3 # Testing All the operation in CSQl ((After Each Operation Kill the server and Restart the server again for Another Operation)
4 # set DURABILITY to true in csql.conf
5 # Start csqlserver. Then create a table (Composite Primary Key on 3 fields) in CSQL Client.Insert 5 Records.
6 # kill the currently running Server.
7 # Again Restart the Server by setting DURABILITY=true and Open CSQL Client.
8 # Continue The same For All Operations in CSQL.
12 CSQL_CONF
=${PWD}/durability
/recovery
/csql.conf
14 if [ -s "$CSQL_CONF" ]
16 REL_PATH
=${PWD}/durability
/recovery
22 cp -f $REL_PATH/csql.conf
/tmp
23 echo SYS_DB_KEY
=4444 >>/tmp
/csql.conf
24 echo USER_DB_KEY
=6666 >>/tmp
/csql.conf
25 echo "DURABILITY=true" >>/tmp
/csql.conf
26 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
28 echo "Durablity = TRUE"
30 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
34 if [ "$VALGRIND" = "true" ]
36 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_pri_10.sql
2> $0.valgr
38 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_pri_10.sql
47 if [ "$VALGRIND" = "true" ]
49 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/show_t1.sql
2>> $0.valgr
51 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/show_t1.sql
54 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
65 echo "Durablity = TRUE"
66 echo "Checking Durability"
67 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
71 echo "INSERTING INTO TABLE"
72 if [ "$VALGRIND" = "true" ]
74 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insert_10.sql
2>> $0.valgr
76 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insert_10.sql
79 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
86 if [ "$VALGRIND" = "true" ]
88 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/select_10.sql
2>> $0.valgr
90 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/select_10.sql
93 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
101 ipcrm
-M 4444 -M 6666
104 echo "Durablity = TRUE"
105 echo "Checking Durability"
106 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
108 echo "Server Started"
110 echo "UPDATING RECORDS IN TABLE"
111 if [ "$VALGRIND" = "true" ]
113 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/update_10.sql
2>> $0.valgr
115 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/update_10.sql
118 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
120 ipcrm
-M 4444 -M 6666
125 if [ "$VALGRIND" = "true" ]
127 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/select_10.sql
2>> $0.valgr
129 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/select_10.sql
132 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
134 ipcrm
-M 4444 -M 6666
140 ipcrm
-M 4444 -M 6666
142 echo "Durablity = TRUE"
143 echo "Checking Durability"
144 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
146 echo "Server Started"
148 echo "DELETING RECORDS FROM TABLE"
149 if [ "$VALGRIND" = "true" ]
151 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/delete_10.sql
2>> $0.valgr
153 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/delete_10.sql
156 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
158 ipcrm
-M 4444 -M 6666
163 if [ "$VALGRIND" = "true" ]
165 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/select_10.sql
2>> $0.valgr
167 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/select_10.sql
170 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
172 ipcrm
-M 4444 -M 6666
178 ipcrm
-M 4444 -M 6666
181 echo "Durablity = TRUE"
182 echo "Checking Durability"
183 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
185 echo "Server Started"
187 echo "DROPPING TABLE"
188 if [ "$VALGRIND" = "true" ]
190 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
2>> $0.valgr
192 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
196 ipcrm
-M 4444 -M 6666
202 ipcrm
-M 4444 -M 6666