test/adapter/Select/selecttest8.c

   1 /*   prepare,execute,free,prepare, second prepare should pass.
   2 */
   3
   4 #include "common.h"
   5 int main()
   6 {
   7         DbRetVal rv = OK;
   8         AbsSqlConnection *con = createConnection();
   9         rv  = con->connect("root","manager");
  10         if(rv!=OK)return 1;
  11
  12         AbsSqlStatement *stmt = createStatement();
  13         stmt->setConnection(con);
  14         char statement[200];
  15
  16         strcpy(statement,"CREATE TABLE t1(f1 INT,f2 CHAR(20));");
  17         if(strcmp(getenv("DSN"),"db2")==0)
  18              strcpy(statement,"CREATE TABLE t1(f1 INT,f2 CHAR(20))");
  19         int rows=0;
  20
  21         rv = stmt->prepare(statement);
  22         if(rv!=OK)
  23         {
  24                 delete stmt;
  25                 delete con;
  26                 return 1;
  27         }
  28         printf("Prepare the Statement\n");
  29         rv  = stmt->execute(rows);
  30         if(rv!=OK)
  31         {
  32                 delete stmt;
  33                 delete con;
  34                 return 2;
  35         }
  36         printf("Execute the Statement\n");
  37         con->commit();
  38         stmt->free();
  39         printf("free all the resources\n");
  40
  41         //again prepare
  42         strcpy(statement,"DROP TABLE t1;");
  43         if(strcmp(getenv("DSN"),"db2")==0)
  44             strcpy(statement,"DROP TABLE t1");
  45         rv = stmt->prepare(statement);
  46         if(rv!=OK)
  47         {
  48                 printf("Test script failed\n");
  49                 delete stmt;
  50                 delete con;
  51                 return 3;
  52         }
  53         printf("Again prepare passed\n");
  54
  55         //Drop the table
  56         rv = stmt->execute(rows);
  57         if(rv==OK)printf("Table dropped successfully\n");
  58         con->commit();
  59         stmt->free();
  60         delete stmt;
  61         delete con;
  62          return 0;
  63 }
  64
  65
  66
  67