test/cache/Gateway/test013.ksh

   1 #!/bin/ksh
   2
   3 #  Create 't1' table with f1 int, f2 char(10) ,primarykey(f1) in target database
   4 #  Insert some records with null values
   5 #  Select from CSQL with -g .It should give actual data as in target database
   6 #  it should be unloaded by -u option
   7
   8 input=${PWD}/cache/Gateway/complex.sql
   9 REL_PATH=.
  10 if [ -s "$input" ]
  11 then
  12     REL_PATH=${PWD}/cache/Gateway
  13 fi
  14
  15 cp $REL_PATH/csql.conf /tmp/csql.conf
  16 export CSQL_CONFIG_FILE=/tmp/csql.conf
  17
  18 echo DSN=$DSN >>$CSQL_CONFIG_FILE
  19 DS="$DSN $DBUSER $PASSWORD"
  20 rm -f /tmp/csql/csqlds.conf
  21 touch /tmp/csql/csqlds.conf
  22 $CSQL_INSTALL_ROOT/bin/csqlds -U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
  23 if [ $? -ne 0 ]
  24 then
  25    exit 1;
  26 fi
  27
  28 if [ $DSN = "sybase" ]
  29 then
  30     echo "create table t1 (f1 int ,f2 char(10) NULL,primary key(f1));" >${REL_PATH}/t1create.sql
  31 elif [ $DSN = "db2" ]
  32 then
  33     echo "create table t1 (f1 int NOT NULL ,f2 char(10) ,primary key(f1));" >${REL_PATH}/t1create.sql
  34 else
  35     echo "create table t1 (f1 int,f2 char(10),primary key(f1));" >${REL_PATH}/t1create.sql
  36 fi
  37 for a in 1 2 3 4 5
  38 do
  39 echo "insert into t1 values($a,'INDIA$a');"
  40 echo "insert into t1 values($a+10 , NULL);"
  41 done>>${REL_PATH}/t1create.sql
  42 echo "t1create.sql file created"
  43 echo "select * from t1;">${REL_PATH}/sel.sql
  44 echo "select file created"
  45 isql $DS < ${REL_PATH}/t1create.sql >/dev/null 2>&1
  46 if [ $? -ne 0 ]
  47 then
  48    rm -f ${REL_PATH}/sel.sql
  49    rm -f ${REL_PATH}/t1create.sql
  50    exit 1;
  51 fi
  52
  53 rm -f /tmp/csql/csqltable.conf
  54 touch /tmp/csql/csqltable.conf
  55 echo "drop table t1;">${REL_PATH}/dp.sql
  56
  57 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  58 pid=$!
  59 sleep 5
  60
  61 echo "Select * from t1 in CSQL"
  62 $CSQL_INSTALL_ROOT/bin/csql -g -s ${REL_PATH}/sel.sql
  63 if [ $? -ne 0 ]
  64 then
  65    rm -f ${REL_PATH}/sel.sql
  66    rm -f ${REL_PATH}/t1create.sql
  67    isql $DS < ${REL_PATH}/dp.sql >/dev/null 2>&1
  68    exit 3;
  69 fi
  70
  71 echo "Checking for table created or not"
  72 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l
  73 if [ $? -ne 0 ]
  74 then
  75    rm -f ${REL_PATH}/sel.sql
  76    rm -f ${REL_PATH}/t1create.sql
  77    isql $DS < ${REL_PATH}/dp.sql >/dev/null 2>&1
  78    exit 4;
  79 fi
  80
  81 rm -f /tmp/csql/csqltable.conf
  82 touch /tmp/csql/csqltable.conf
  83 isql $DS < ${REL_PATH}/dp.sql >/dev/null 2>&1
  84
  85 rm -f ${REL_PATH}/dp.sql
  86 rm -f ${REL_PATH}/sel.sql
  87 rm -f ${REL_PATH}/t1create.sql
  88 kill -9 $pid
  89 ipcrm -M 1199 -M 2277
  90 exit 0;