test001.ksh

b树实现源码,linux和unix下运行,速度快,极好用

#!/bin/sh
# Test Case
# check no option, ? 
# check whether authentication is working
#
QUITFILE=${PWD}/tools/csql/quit.sql
REL_PATH=.
if [ -s "$QUITFILE" ]
then
    REL_PATH=`pwd`/tools/csql
fi
echo "Case 1: With no option:"
$CSQL_INSTALL_ROOT/bin/csql < ${REL_PATH}/quit.sql
if [ $? -ne 0 ]
then
   exit 1;
fi
echo "Case 2: With ? option:"
$CSQL_INSTALL_ROOT/bin/csql -? 
if [ $? -ne 0 ]
then
   exit 1;
fi

echo "Case 3: With wrong username :" 
$CSQL_INSTALL_ROOT/bin/csql -u wronguser -p password < ${REL_PATH}/quit.sql 2>/tmp/tmptstlog
if [ $? -eq 0 ]
then
   exit 1;
fi

echo "Case 4: With wrong password :" 
$CSQL_INSTALL_ROOT/bin/csql -u root -p password < ${REL_PATH}/quit.sql 2>/tmp/tmptstlog
if [ $? -eq 0 ]
then
   exit 1;
fi

echo "Case 5: With correct user name  and password :"
$CSQL_INSTALL_ROOT/bin/csql -u root -p manager < ${REL_PATH}/quit.sql
if [ $? -ne 0 ]
then
   exit 1;
fi