test/sqlapi/Select/selecttest7.c

   1 /*   create table T1 with two fields,
   2  *   insert 10 rows into the table ,
   3  *   call fetch without call execute,it returns NULL.
   4
   5  *   Author : Jitendra Lenka
   6  */
   7
   8 #include"common.h"
   9
  10 int main()
  11 {
  12     DbRetVal rv = OK;
  13     AbsSqlConnection *con = createConnection();
  14     rv  = con->connect("root","manager");
  15     if(rv!=OK)return 1;
  16     AbsSqlStatement *stmt = createStatement();
  17     stmt->setConnection(con);
  18     char statement[200];
  19     strcpy(statement,"CREATE TABLE T1(F1 INT,F2 CHAR(20));");
  20     int rows=0;
  21     rv = stmt->prepare(statement);
  22     if(rv!=OK) { delete stmt; delete con; return 1; }
  23     rv = stmt->execute(rows);
  24     if(rv!=OK) { delete stmt; delete con; return 2; }
  25     stmt->free();
  26     printf("Table created\n");
  27 //  insert records
  28     strcpy(statement,"INSERT INTO T1 VALUES(?,?);");
  29     int f1var = 1;
  30     char f2var[24] = "lakshya";
  31     rv = stmt->prepare(statement);
  32     if(rv!=OK) { delete stmt; delete con; return 3; }
  33     int count=0;
  34     for(int i=0;i<2;i++) {
  35         for(int j=0;j<5;j++) {
  36             f1var = j;
  37             rv = con->beginTrans();
  38             if(rv!=OK)break;
  39             stmt->setIntParam(1,f1var);
  40             stmt->setStringParam(2,f2var);
  41             rv = stmt->execute(rows);
  42             if(rv!=OK)break;
  43             rv = con->commit();
  44                 if(rv!=OK)break;
  45                 count++;
  46         }
  47         printf("%d rows inserted\n",count);
  48     }
  49     stmt->free();
  50 //*******************************************
  51     strcpy(statement,"SELECT * FROM T1;");
  52     rv = stmt->prepare(statement);
  53     if(rv !=OK) { delete stmt; delete con; return 4; }
  54     stmt->bindField(1,&f1var);
  55     stmt->bindField(2,f2var);
  56     void *ret;
  57     count = 0;
  58     rv = con->beginTrans();
  59     if(rv!=OK)return 5;
  60     //stmt->execute(rows);
  61     while(1) {
  62         ret = ((char*)stmt->fetch());
  63         if(ret==NULL) {
  64             printf("without prepare,Fetch failed\n");
  65             strcpy(statement,"DROP TABLE T1;");
  66             rv = stmt->prepare(statement);
  67             rv = stmt->execute(rows);
  68             if(rv==OK){printf("Table dropped successfully\n");}
  69             stmt->free();
  70             delete stmt;
  71             delete con;
  72             return 0;
  73         }
  74         printf("Test script failed\n");
  75     }
  76     stmt->free(); delete stmt; delete con;
  77     return 7;
  78 }
  79