test/sqlapi/Select/selecttest14.c

   1 /*  create table T1 with 2 fields.
   2  *  get Metadata by Describe <tblName>
   3  *
   4  *
   5  *  select * from T1;
   6
   7  */
   8
   9 #include"common.h"
  10
  11 int main()
  12 {
  13     DbRetVal rv = OK;
  14     AbsSqlConnection *con =  createConnection();
  15     rv = con->connect("root","manager");
  16     if(rv!=OK)return 1;
  17     AbsSqlStatement *stmt = createStatement();
  18     stmt->setConnection(con);
  19     char statement[200];
  20     strcpy(statement,"CREATE TABLE T1(F1 INT,F2 INT);");
  21     int rows = 0;
  22     rv = stmt->prepare(statement);
  23     if(rv!=OK) { delete stmt; delete con; return 2; }
  24     rv = stmt->execute(rows);
  25     if(rv!=OK) { delete stmt; delete con; return 3; }
  26     stmt->free();
  27     printf("Table T1 created\n");
  28     strcpy(statement,"DESCRIBE T1;");
  29     rv = stmt->prepare(statement);
  30     char colName[IDENTIFIER_LENGTH];
  31     int sqlType=0;
  32     int length=0;
  33     int isNull=0;
  34     stmt->bindField(4, colName);
  35     stmt->bindField(5, &sqlType);
  36     stmt->bindField(7, &length);
  37     stmt->bindField(11, &isNull);
  38     int i=0;
  39     rv = stmt->execute(rows);
  40     if (rv != OK) { printError(rv, "execute failed"); return rv; }
  41     while (stmt->fetch(rv) != NULL) {
  42        printf("cnt = %d\n", i++);
  43     }
  44     stmt->free();
  45
  46     strcpy(statement,"DROP TABLE T1;");
  47     rv = stmt->prepare(statement);
  48     if(rv!=OK) { delete stmt; delete con; return 8; }
  49     rv = stmt->execute(rows);
  50     if(rv!=OK) { delete stmt; delete con; return 9; }
  51     printf("Table dropped\n");
  52     stmt->free(); delete stmt; delete con;
  53     return 0;
  54 }