test/tools/csqldump/test017.ksh

   1 #!/bin/ksh
   2 # Create table t1 having two integer field f1 ,f2 with primary key f1 . create table t2 having two integer field f3,f4 with foreign key f3 refers t1 (f1) and a primary key f4 . and create table t3 having two integer field f5,f6 with foreign key f5 refers t2 (f4).It Should be passed. Test all valid and invalid DML Operation Related to Foreign Key.use csqldump toll for dumping the foreign key information.
   3 #
   4 input=${PWD}/tools/csqldump/foreign4.sql
   5 REL_PATH=.
   6 if [ -s "$input" ]
   7 then
   8     REL_PATH=${PWD}/tools/csqldump
   9 fi
  10
  11 echo "DROP TABLE t3;" >$REL_PATH/drp1.sql
  12 echo "DROP TABLE t2;" >>$REL_PATH/drp1.sql
  13 echo "DROP TABLE t1;" >>$REL_PATH/drp1.sql
  14
  15 if [ "$VALGRIND" = "true" ]
  16 then
  17     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/foreign4.sql 2> $0.valgr
  18 else
  19     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/foreign4.sql >/dev/null 2>&1
  20     if [ $? -ne 0 ]
  21     then
  22         $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/drp1.sql > /dev/null 2>&1
  23         rm -f $REL_PATH/drp1.sql
  24         exit 1;
  25     fi
  26 fi
  27
  28 if [ "$VALGRIND" = "true" ]
  29 then
  30     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
  31 else
  32     $CSQL_INSTALL_ROOT/bin/csqldump
  33     if [ $? -ne 0 ]
  34     then
  35         $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/drp1.sql > /dev/null 2>&1
  36         rm -f $REL_PATH/drp1.sql
  37         exit 2;
  38     fi
  39 fi
  40
  41 if [ "$VALGRIND" = "true" ]
  42 then
  43     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/drp1.sql 2>> $0.valgr
  44 else
  45     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/drp1.sql > /dev/null 2>&1
  46     if [ $? -ne 0 ]
  47     then
  48         rm -f $REL_PATH/drp1.sql
  49         exit 3;
  50     fi
  51 fi
  52
  53 rm -f $REL_PATH/drp1.sql
  54 exit 0;