adding test scripts
[csql.git] / test / tools / csql / testnw028.ksh
blobeaf40965a0edaaa166f0d51ac2d9764fff283335
1 #!/bin/sh
2 # Network test. The same is present in test128.ksh (wihout network)
3 # Default and 'now' testing for Date, Time and Timestamp datatypes
6 QUITFILE=${PWD}/tools/csql/quit.sql
7 REL_PATH=.
8 if [ -s "$QUITFILE" ]
9 then
10 REL_PATH=`pwd`/tools/csql
13 $CSQL_INSTALL_ROOT/bin/csql -o 4 -u root -p manager -s ${REL_PATH}/csqlnow.sql
14 if [ $? -ne 0 ]
15 then
16 exit 1;
19 sleep 1
20 echo "echo INSERT INTO t1(f2) VALUES('NOW');" >${REL_PATH}/insnow.sql
21 echo "INSERT INTO t1(f2) VALUES('NOW');" >>${REL_PATH}/insnow.sql
22 $CSQL_INSTALL_ROOT/bin/csql -o 4 -u root -p manager -s ${REL_PATH}/insnow.sql
23 if [ $? -ne 0 ]
24 then
25 rm -f ${REL_PATH}/insnow.sql
26 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
27 exit 2;
30 sleep 1
31 echo "echo INSERT INTO t1(f3) VALUES('NOW');" >${REL_PATH}/insnow.sql
32 echo "INSERT INTO t1(f3) VALUES('NOW');" >>${REL_PATH}/insnow.sql
33 $CSQL_INSTALL_ROOT/bin/csql -o 4 -u root -p manager -s ${REL_PATH}/insnow.sql
34 if [ $? -ne 0 ]
35 then
36 rm -f ${REL_PATH}/insnow.sql
37 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
38 exit 3;
41 sleep 1
42 echo "echo INSERT INTO t1(f4) VALUES('NOW');" >${REL_PATH}/insnow.sql
43 echo "INSERT INTO t1(f4) VALUES('NOW');" >>${REL_PATH}/insnow.sql
44 $CSQL_INSTALL_ROOT/bin/csql -o 4 -u root -p manager -s ${REL_PATH}/insnow.sql
45 if [ $? -ne 0 ]
46 then
47 rm -f ${REL_PATH}/insnow.sql
48 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
49 exit 4;
52 echo "echo SELECT * FROM t1;" >${REL_PATH}/selnow.sql
53 echo "SELECT * FROM t1;" >>${REL_PATH}/selnow.sql
54 $CSQL_INSTALL_ROOT/bin/csql -o 4 -u root -p manager -s ${REL_PATH}/selnow.sql
55 if [ $? -ne 0 ]
56 then
57 rm -f ${REL_PATH}/insnow.sql
58 rm -f ${REL_PATH}/selnow.sql
59 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
60 exit 5;
63 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
64 if [ $? -ne 0 ]
65 then
66 rm -f ${REL_PATH}/insnow.sql
67 exit 6;
70 rm -f ${REL_PATH}/insnow.sql
71 rm -f ${REL_PATH}/selnow.sql
72 exit 0;