test/tools/UserStmt/test001.ksh

   1 #!/bin/ksh
   2 #Test Case : Working with a user other than root user
   3 # Connect root user as:
   4 # # csql -u root -p manager
   5 # create a user other than root
   6 # connect to that user as
   7 # #csql -u <new_username> password <Password>
   8 # It should be passed.
   9
  10 QUITFILE=${PWD}/tools/UserStmt/csql.conf
  11 REL_PATH=.
  12 if [ -s "$QUITFILE" ]
  13 then
  14     REL_PATH=`pwd`/tools/UserStmt
  15 fi
  16
  17 exitStatus()
  18 {
  19     rm -f ${REL_PATH}/usr.sql ${REL_PATH}/qut.sql ${REL_PATH}/drusr.sql
  20     echo "Test $1"
  21     exit $2;
  22 }
  23
  24 echo "echo create user lakshya password 'lakshya123';" >${REL_PATH}/usr.sql
  25 echo "create user lakshya password 'lakshya123';" >>${REL_PATH}/usr.sql
  26 echo "quit;" >>${REL_PATH}/usr.sql
  27
  28 echo "echo quit;" >${REL_PATH}/qut.sql
  29 echo "quit;" >>${REL_PATH}/qut.sql
  30
  31 echo "echo drop user lakshya;" >${REL_PATH}/drusr.sql
  32 echo "drop user lakshya;" >>${REL_PATH}/drusr.sql
  33
  34 if [ "$VALGRIND" = "true" ]
  35 then
  36    valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usr.sql
  37 else
  38    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/usr.sql
  39    if [ $? -ne 0 ]
  40    then
  41       exitStatus Failed 1;
  42    fi
  43 fi
  44 echo "User Created"
  45
  46 echo "Connecting to lakshya"
  47 if [ "$VALGRIND" = "true" ]
  48 then
  49    valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u lakshya -p lakshya123 -s ${REL_PATH}/qut.sql
  50 else
  51    $CSQL_INSTALL_ROOT/bin/csql -u lakshya -p lakshya123 -s ${REL_PATH}/qut.sql
  52    if [ $? -ne 0 ]
  53    then
  54       exitStatus Failed 2;
  55    fi
  56 fi
  57
  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}/drusr.sql
  61 else
  62    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drusr.sql
  63    if [ $? -ne 0 ]
  64    then
  65       exitStatus Failed 3;
  66    fi
  67 fi
  68 echo "User Dropped"
  69
  70 exitStatus Passed 0;