test/sqlapi/Connect/conntest5.c

   1 /*  create table T1 ,Insert some records in it.
   2  *  Close the connection, Fetch should fail.
   3
   4  *  Author : Jitendra Lenka
   5  */
   6
   7 #include"common.h"
   8
   9 int main()
  10 {
  11     DbRetVal rv = OK;
  12     AbsSqlConnection *con = createConnection();
  13     rv = con->connect("root","manager");
  14     if(rv !=OK)return 1;
  15     printf("Connection opened\n");
  16     AbsSqlStatement *stmt = createStatement();
  17     stmt->setConnection(con);
  18     char statement[200];
  19     strcpy(statement,"CREATE TABLE T1(F1 INT,F2 INT);");
  20     int rows = 0;
  21     rv = stmt->prepare(statement);
  22     if(rv!=OK) { delete stmt; delete con; return 2; }
  23     rv = stmt->execute(rows);
  24     if(rv!=OK) { delete stmt; delete con; return 3; }
  25     stmt->free();
  26     printf("Table T1 CREATED\n");
  27     // insert into statement
  28     strcpy(statement,"INSERT INTO T1 VALUES(1,1);");
  29     rv = stmt->prepare(statement);
  30     if(rv!=OK) { delete stmt; delete con; return 4; }
  31     rv = con->beginTrans();
  32     if(rv!=OK) { delete stmt; delete con; return 5; }
  33     rv = stmt->execute(rows); if(rv!=OK) return 6;
  34     rv = con->commit();
  35     if(rv!=OK) return 7;
  36     stmt->free();
  37     printf("One record inserted\n");
  38     strcpy(statement,"SELECT F2 FROM T1 ;");
  39     rv = stmt->prepare(statement);
  40     if(rv!=OK) { delete stmt; delete con; return 10; }
  41     int id=10;
  42     stmt->bindField(1,&id);
  43     rv = con->beginTrans();
  44     if(rv!=OK)return 11;
  45     stmt->execute(rows);
  46     int count=0;
  47     stmt->close(); stmt->free();
  48     rv = con->disconnect(); //close the connection
  49     void *rettype;
  50     if(rv!=OK)return 8;
  51     rettype = (char*)stmt->fetch();
  52     if(rettype==NULL && rv == OK) {
  53         printf("After closing the connection,fetch failed\n");
  54                 con->connect("root", "manager");
  55                 stmt->setConnection(con);
  56         strcpy(statement,"DROP TABLE T1;");
  57         rv = stmt->prepare(statement);
  58         rv = stmt->execute(rows);
  59         if(rv==OK) { printf("Table Dropped successfully\n"); }
  60                 stmt->free(); delete stmt; delete con;
  61                 printf("Test script passed\n");
  62         return 0;
  63     }
  64     printf("Test script Failed\n");
  65     delete stmt; delete con;
  66     return 7;
  67 }