test/sqlgw/Select/selecttest3.c

   1 /*   create table t1 with two fields,
   2  *   insert 10 rows into the table ,
   3  *   select from nonexisting table.
   4 */
   5
   6 #include "common.h"
   7 int main()
   8 {
   9     DbRetVal rv = OK;
  10     AbsSqlConnection *con = createConnection();
  11     rv  = con->connect("root","manager");
  12     if(rv!=OK)return 1;
  13
  14     AbsSqlStatement *stmt = createStatement();
  15     stmt->setConnection(con);
  16     char statement[200];
  17
  18     int rows=0;
  19     //  insert records
  20
  21     strcpy(statement,"INSERT INTO t1 VALUES(?,?);");
  22     if(strcmp(getenv("DSN"),"db2")==0)
  23         strcpy(statement,"INSERT INTO t1 VALUES(?,?)");
  24
  25     int f1var = 1;
  26     char f2var[20] = "lakshya";
  27
  28     rv = stmt->prepare(statement);
  29     if(rv!=OK) { delete stmt; delete con; return 3; }
  30
  31     int count=0;
  32
  33     for(int i=0;i<2;i++) {
  34         for(int j=0;j<5;j++) {
  35             f1var = j;
  36             rv = con->beginTrans();
  37             if(rv!=OK)break;
  38             stmt->setIntParam(1,f1var);
  39             stmt->setStringParam(2,f2var);
  40                 rv = stmt->execute(rows);
  41             if(rv!=OK)break;
  42             rv = con->commit();
  43             if(rv!=OK)break;
  44             count++;
  45         }
  46         printf("%d rows inserted\n",count);
  47     }
  48     stmt->free();
  49
  50 //*******************************************
  51
  52     strcpy(statement,"SELECT * FROM t11;");
  53     if(strcmp(getenv("DSN"),"db2")==0)
  54         strcpy(statement,"SELECT * FROM t11");
  55     rv = stmt->prepare(statement);
  56
  57     if(rv !=OK) {
  58         printf("test script passed\n");
  59         stmt->free();
  60         delete stmt;
  61         delete con;
  62         return 0;
  63     } else if(rv==OK) {
  64        if(strcmp(getenv("DSN"),"oracle")==0 || strcmp(getenv("DSN"),"psql")==0 || strcmp(getenv("DSN"),"sybase")==0){
  65             printf("Test script Passed\n");
  66             stmt->free(); delete stmt; delete con; return 0;
  67        } else {
  68            printf("Test script failed\n");
  69            stmt->free(); delete stmt; delete con; return 5;
  70        }
  71     } else {
  72         stmt->bindField(1,&f1var);
  73         stmt->bindField(2,f2var);
  74         count = 0;
  75         rv = con->beginTrans();
  76         if(rv!=OK)return 6;
  77         stmt->execute(rows);
  78         while(stmt->fetch()!=NULL)
  79         { count++; }
  80         stmt->close();
  81         rv = con->commit();
  82         if(rv!=OK) { delete stmt; delete con; return 7; }
  83         printf("Total row fetched=%d\n",count);
  84     }
  85     stmt->free(); delete stmt; delete con; return 0;
  86  }
  87
  88
  89