test/tools/UserStmt/test009.ksh

   1 #!/bin/ksh
   2 #Test Case : DDL and DML operations in users other than root user
   3 # Connect root user as:
   4 # # csql -u root -p manager
   5 # Create a user lakshya as:
   6 # CSQL> create user lakshya password 'lakshya123';
   7 # Connect csql through lakshya as
   8 # # csql -u lakshya -p lakshya123
   9 # Do DDL and DML operations. All should work properly.
  10
  11 QUITFILE=${PWD}/tools/UserStmt/csql.conf
  12 REL_PATH=.
  13 if [ -s "$QUITFILE" ]
  14 then
  15     REL_PATH=`pwd`/tools/UserStmt
  16 fi
  17
  18 exitStatus()
  19 {
  20     rm -f ${REL_PATH}/usr.sql ${REL_PATH}/usrlakshya.sql ${REL_PATH}/usrroot.sql
  21     echo "Test $1"
  22     exit $2;
  23 }
  24
  25 echo "echo create table t1(f1 int,f2 char(10));" >${REL_PATH}/usr.sql
  26 echo "create table t1(f1 int,f2 char(10));" >>${REL_PATH}/usr.sql
  27 echo "echo insert into t1 values(1,'root1');" >>${REL_PATH}/usr.sql
  28 echo "insert into t1 values(1,'root1');" >>${REL_PATH}/usr.sql
  29 echo "echo select * from t1;" >>${REL_PATH}/usr.sql
  30 echo "select * from t1;" >>${REL_PATH}/usr.sql
  31 echo "echo create user lakshya password 'lakshya123';" >>${REL_PATH}/usr.sql
  32 echo "create user lakshya password 'lakshya123';" >>${REL_PATH}/usr.sql
  33 echo "echo show users;" >>${REL_PATH}/usr.sql
  34 echo "show users;" >>${REL_PATH}/usr.sql
  35 echo "echo Disconnecting User root" >>${REL_PATH}/usr.sql
  36 echo "quit;" >>${REL_PATH}/usr.sql
  37
  38 echo "echo create table t2(f1 int,f2 char(10));" >${REL_PATH}/usrlakshya.sql
  39 echo "create table t2(f1 int,f2 char(10));" >>${REL_PATH}/usrlakshya.sql
  40 echo "echo insert into t1 values(2,'root2');" >>${REL_PATH}/usrlakshya.sql
  41 echo "insert into t1 values(2,'root2');" >>${REL_PATH}/usrlakshya.sql
  42 echo "echo insert into t2 values(10,'lakshya');" >>${REL_PATH}/usrlakshya.sql
  43 echo "insert into t2 values(10,'lakshya');" >>${REL_PATH}/usrlakshya.sql
  44 echo "echo select * from t1;" >>${REL_PATH}/usrlakshya.sql
  45 echo "select * from t1;" >>${REL_PATH}/usrlakshya.sql
  46 echo "echo select * from t2;" >>${REL_PATH}/usrlakshya.sql
  47 echo "select * from t2;" >>${REL_PATH}/usrlakshya.sql
  48 echo "echo Disconnecting user lakshya" >>${REL_PATH}/usrlakshya.sql
  49 echo "quit;" >>${REL_PATH}/usrlakshya.sql
  50
  51 echo "echo drop user lakshya;" >${REL_PATH}/usrroot.sql
  52 echo "drop user lakshya;" >>${REL_PATH}/usrroot.sql
  53 echo "drop table t1;" >>${REL_PATH}/usrroot.sql
  54 echo "drop table t2;" >>${REL_PATH}/usrroot.sql
  55 echo "quit;" >>${REL_PATH}/usrroot.sql
  56
  57 echo "Connecting User root"
  58 if [ "$VALGRIND" = "true" ]
  59 then
  60    valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usr.sql
  61 else
  62    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usr.sql
  63    if [ $? -ne 0 ]
  64    then
  65       exitStatus Failed 1;
  66    fi
  67 fi
  68
  69 echo "Connecting User lakshya"
  70 if [ "$VALGRIND" = "true" ]
  71 then
  72    valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u lakshya -p lakshya123 -s ${REL_PATH}/usrlakshya.sql
  73 else
  74    $CSQL_INSTALL_ROOT/bin/csql -u lakshya -p lakshya123 -s ${REL_PATH}/usrlakshya.sql
  75    if [ $? -ne 0 ]
  76    then
  77       exitStatus Failed 2;
  78    fi
  79 fi
  80
  81 echo "Connecting User root"
  82 if [ "$VALGRIND" = "true" ]
  83 then
  84    valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usrroot.sql
  85 else
  86    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usrroot.sql
  87    if [ $? -ne 0 ]
  88    then
  89       exitStatus Failed 3;
  90    fi
  91 fi
  92
  93 exitStatus Passed 0;