2 # Testing Durability in MMAP architecture
3 # Composite Primary Key test
4 # Testing All the operation in CSQl ((After Each Operation Kill the server and Restart the server again for Another Operation)
5 # set DURABILITY=true MMAP=true in csql.conf
6 # Start csqlserver. Then create a table (Composite Primary Key on 3 fields) in CSQL Client.Insert 5 Records.
7 # kill the currently running Server.
8 # Again Restart the Server by setting DURABILITY=true and Open CSQL Client.
9 # Continue The same For All Operations in CSQL.
10 # All should work Fine
13 CSQL_CONF
=${PWD}/durability
/recovery
/csql.conf
15 if [ -s "$CSQL_CONF" ]
17 REL_PATH
=${PWD}/durability
/recovery
23 cp -f $REL_PATH/csql.conf
/tmp
24 echo SYS_DB_KEY
=4444 >>/tmp
/csql.conf
25 echo "DURABILITY=true" >>/tmp
/csql.conf
26 echo "MMAP=true" >>/tmp
/csql.conf
27 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
29 echo "Durablity = TRUE"
31 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
35 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_pri_10.sql
43 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/show_t1.sql
46 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
56 echo "Durablity = TRUE"
57 echo "Checking Durability"
58 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
62 echo "INSERTING INTO TABLE"
63 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insert_10.sql
66 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
72 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/select_10.sql
75 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
85 echo "Durablity = TRUE"
86 echo "Checking Durability"
87 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
91 echo "UPDATING RECORDS IN TABLE"
92 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/update_10.sql
95 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
101 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/select_10.sql
104 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
113 echo "Durablity = TRUE"
114 echo "Checking Durability"
115 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
117 echo "Server Started"
119 echo "DELETING RECORDS FROM TABLE"
120 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/delete_10.sql
123 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
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
142 echo "Durablity = TRUE"
143 echo "Checking Durability"
144 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
146 echo "Server Started"
148 echo "DROPPING TABLE"
149 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql