test/sqlapi/Select/selecttest4.c

   1 /*   create table T1 with two fields,
   2  *   insert 10 rows into the table ,
   3  *   select with  nonexisting fields.
   4
   5  *   Author : Jitendra Lenka
   6  */
   7
   8 #include<AbsSqlStatement.h>
   9 #include<SqlFactory.h>
  10
  11 int main()
  12 {
  13   DbRetVal rv = OK;
  14   AbsSqlConnection *con = SqlFactory:: createConnection(CSql);
  15   rv  = con->connect("root","manager");
  16   if(rv!=OK)return 1;
  17
  18   AbsSqlStatement *stmt = SqlFactory :: createStatement(CSql);
  19   stmt->setConnection(con);
  20   char statement[200];
  21
  22   strcpy(statement,"CREATE TABLE T1(F1 INT,F2 INT);");
  23
  24   int rows=0;
  25   rv = stmt->prepare(statement);
  26   if(rv!=OK)
  27   {
  28     delete stmt;
  29     delete con;
  30     return 1;
  31  }
  32
  33  rv  = stmt->execute(rows);
  34   if(rv!=OK)
  35   {
  36     delete stmt;
  37     delete con;
  38     return 2;
  39  }
  40  stmt->free();
  41  printf("Table created\n");
  42
  43  //  insert records
  44
  45  strcpy(statement,"INSERT INTO T1 VALUES(?,?);");
  46
  47  int f1var = 1;
  48  int  f2var= 110;
  49
  50  rv = stmt->prepare(statement);
  51  if(rv!=OK)
  52  {
  53    delete stmt;
  54    delete con;
  55    return 3;
  56  }
  57
  58  int count=0;
  59
  60  for(int i=0;i<2;i++)
  61  {
  62
  63    for(int j=0;j<5;j++)
  64     {
  65         f1var = j;
  66         rv = con->beginTrans();
  67         if(rv!=OK)break;
  68
  69
  70         stmt->setIntParam(1,f1var);
  71         stmt->setIntParam(2,f2var);
  72
  73         rv = stmt->execute(rows);
  74         if(rv!=OK)break;
  75         rv = con->commit();
  76         if(rv!=OK)break;
  77         count++;
  78     }
  79     printf("%d rows inserted\n",count);
  80  }
  81  stmt->free();
  82
  83 //*******************************************
  84
  85   strcpy(statement,"SELECT F3 ,F2  FROM T1;");
  86   rv = stmt->prepare(statement);
  87
  88   if(rv !=OK)
  89   {
  90      printf("Test script passed\n");
  91
  92      strcpy(statement,"DROP TABLE T1;");
  93      rv = stmt->prepare(statement);
  94      rv = stmt->execute(rows);
  95      if(rv==OK)printf("Table dropped\n");
  96      stmt->free();
  97      delete stmt;
  98      delete con;
  99      return 0;
 100   }
 101  else
 102  {
 103    printf("Test script failed\n");
 104    delete stmt;
 105    delete con;
 106    return 4;
 107  }
 108
 109 }