test/adapter/Connect/conntest13.c

   1 //Test for table exist in tdb or not
   2 //
   3
   4 #include"common.h"
   5 #include <SqlOdbcStatement.h>
   6 int main()
   7 {
   8    DbRetVal rv = OK;
   9    AbsSqlConnection *con = createConnection();
  10    rv = con->connect("root","manager");
  11    if(rv !=OK)return 1;
  12    printf("Connection opened\n");
  13
  14    AbsSqlStatement *stmt = createStatement();
  15    stmt->setConnection(con);
  16    char statement[200];
  17    if(strcmp(getenv("DSN"),"oracle")==0)
  18        strcpy(statement,"CREATE TABLE t1(f1 number(9),f2 number(9),primary key(f1));");
  19    else if(strcmp(getenv("DSN"),"db2")==0)
  20        strcpy(statement,"CREATE TABLE t1(f1 INT NOT NULL,f2 INT,primary key(f1))");
  21    else
  22        strcpy(statement,"CREATE TABLE t1(f1 INT,f2 INT,primary key(f1));");
  23
  24    int rows = 0;
  25    rv = stmt->prepare(statement);
  26    if(rv!=OK) { delete stmt; delete con; return 2; }
  27
  28    rv = stmt->execute(rows);
  29    if(rv!=OK) { delete stmt; delete con; return 3; }
  30    stmt->free();
  31    printf("Table t1 CREATED\n");
  32    con->commit();
  33    // insert into statement
  34    printf("TableExists in Tdb Testing Starts Here\n");
  35    char pkfield[200];
  36    SqlOdbcStatement *oStmt= (SqlOdbcStatement *)stmt;
  37    bool tabflag=oStmt->isTableExists("t1");
  38    if(tabflag)
  39    {
  40       printf("Table t1 exists in TDB\n");
  41    }else{
  42       printf("Table t1 does not exists in TDB\n");
  43    }
  44
  45
  46    strcpy(statement,"DROP TABLE t1;");
  47    if(strcmp(getenv("DSN"),"db2")==0){
  48        strcpy(statement,"DROP TABLE t1");
  49    }
  50    rv = stmt->prepare(statement);
  51    if(rv!=OK)
  52    {
  53       delete stmt;
  54       delete con;
  55       return 4;
  56    }
  57    rv = stmt->execute(rows);
  58    if(rv!=OK)
  59    {
  60       delete stmt;
  61       delete con;
  62       return 5;
  63    }
  64    con->commit();
  65    tabflag=oStmt->isTableExists("t1");
  66    if(tabflag)
  67    {
  68       printf("Table t1 exists in TDB\n");
  69    }else{
  70       printf("Table t1 does not exists in TDB\n");
  71    }
  72
  73    printf("Table droped\n");
  74
  75    delete stmt;
  76    delete con;
  77    return 0;
  78 }
  79
  80
  81