test/system/trans/transtest006.c

   1 /**********************************************************
   2 * Test Case
   3 * create table t1
   4 * create index if specified
   5 * insert 10 tuples
   6 * start new transaction
   7 * select 10 tuples
   8 * check transaction statistics
   9 * abort transation
  10 * check transaction statistics
  11 */
  12 #include "common.h"
  13 #include <DatabaseManagerImpl.h>
  14 int main()
  15 {
  16     Connection conn;
  17     DbRetVal rv = conn.open("root", "manager");
  18     if (rv != OK) return 1;
  19     DatabaseManagerImpl *dbMgr = (DatabaseManagerImpl*) conn.getDatabaseManager();
  20     if (dbMgr == NULL) { printf("Auth failed\n"); return 2;}
  21     int ret =0, rc =0;
  22     if (createTable(dbMgr, "t1") != 0 ) { ret = 3; }
  23 #ifdef WITHINDEX
  24     if (createIndex(dbMgr, "t1","f1", "idx1") != 0 ) { ret = 4; }
  25 #endif
  26     rv = conn.startTransaction();
  27     if (rv != OK) ret = 5;
  28     rc = insertTuple(dbMgr, conn, "t1", 10);
  29     if (rc != 10) ret = 6;
  30     conn.commit();
  31
  32     rv = conn.startTransaction();
  33     if (rv != OK) ret = 5;
  34     rc = selectTuple(dbMgr, conn, "t1", 10);
  35     if (rc != 10) ret = 6;
  36
  37     printf("Before abort\n");
  38     dbMgr->printDebugTransInfo();
  39     conn.rollback();
  40     printf("After abort\n");
  41     dbMgr->printDebugTransInfo();
  42     dropTable(dbMgr ,"t1");
  43     conn.close();
  44     return ret;
  45 }