test/tools/csql/test001.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # check no option, ?
   4 # check whether authentication is working
   5 #
   6 QUITFILE=${PWD}/tools/csql/quit.sql
   7 REL_PATH=.
   8 if [ -s "$QUITFILE" ]
   9 then
  10     REL_PATH=`pwd`/tools/csql
  11 fi
  12 echo "Case 1: With no option:"
  13 $CSQL_INSTALL_ROOT/bin/csql < ${REL_PATH}/quit.sql
  14 if [ $? -ne 0 ]
  15 then
  16    exit 1;
  17 fi
  18 echo "Case 2: With ? option:"
  19 if [ "$VALGRIND" = "true" ]
  20 then
  21     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -? 2> $0.valgr
  22 else
  23     $CSQL_INSTALL_ROOT/bin/csql -?
  24     if [ $? -ne 0 ]
  25     then
  26        exit 2;
  27     fi
  28 fi
  29
  30 echo "Case 3: With wrong username and wrong password :"
  31 if [ "$VALGRIND" = "true" ]
  32 then
  33     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u wronguser -p password < ${REL_PATH}/quit.sql 2>> $0.valgr
  34 else
  35     $CSQL_INSTALL_ROOT/bin/csql -u wronguser -p password < ${REL_PATH}/quit.sql >/dev/null 2>&1
  36     if [ $? -eq 0 ]
  37     then
  38        echo passed
  39        exit 3;
  40     fi
  41 fi
  42 echo failed
  43
  44 echo "Case 4: With wrong username :"
  45 if [ "$VALGRIND" = "true" ]
  46 then
  47     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u wronguser -p manager < ${REL_PATH}/quit.sql 2>> $0.valgr
  48 else
  49     $CSQL_INSTALL_ROOT/bin/csql -u wronguser -p manager < ${REL_PATH}/quit.sql >/dev/null 2>&1
  50     if [ $? -eq 0 ]
  51     then
  52        echo Passed
  53        exit 4;
  54     fi
  55 fi
  56 echo Failed
  57
  58 echo "Case 5: With wrong password :"
  59 if [ "$VALGRIND" = "true" ]
  60 then
  61     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p password < ${REL_PATH}/quit.sql 2>> $0.valgr
  62 else
  63     $CSQL_INSTALL_ROOT/bin/csql -u root -p password < ${REL_PATH}/quit.sql >/dev/null 2>&1
  64     if [ $? -eq 0 ]
  65     then
  66        echo passed
  67        exit 5;
  68     fi
  69 fi
  70 echo failed
  71
  72 echo "Case 6: With correct user name  and password :"
  73 if [ "$VALGRIND" = "true" ]
  74 then
  75     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager < ${REL_PATH}/quit.sql 2>> $0.valgr
  76 else
  77     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager < ${REL_PATH}/quit.sql
  78     if [ $? -ne 0 ]
  79     then
  80        echo failed
  81        exit 6;
  82     fi
  83 fi
  84
  85 echo passed