test/dbapi/Predicate/orandorpredicate1.c

   1
   2 #include "common.h"
   3 int main()
   4 {
   5     Connection conn;
   6     DbRetVal rv = conn.open("root", "manager");
   7     if (rv != OK) return 1;
   8     DatabaseManager *dbMgr = conn.getDatabaseManager();
   9     if (dbMgr == NULL) { printf("Auth failed\n"); return 2;}
  10
  11     if ( createTable(dbMgr) != 0 ) { conn.close(); return 3; }
  12     int inscount =  insertTuple(dbMgr, conn);
  13     //check the inscount and return error
  14
  15     Table *table = dbMgr->openTable("t1");
  16     if (table == NULL)
  17     {
  18         printf("Unable to open table\n");
  19         return 0;
  20     }
  21     Condition p1,p2,p3,p4;
  22     int val1 = 2, val2 = 3, val3 = 5;
  23     p1.setTerm("f1", OpEquals, &val2);
  24     p2.setTerm("f2", OpGreaterThan, &val1);
  25     p3.setTerm("f3", OpNotEquals, &val3);
  26     p4.setTerm("f4", OpLessThan, &val3);
  27
  28
  29     Condition cond2, cond2a, cond2b;
  30     cond2.setTerm(p1.getPredicate(), OpOr, p2.getPredicate());
  31     cond2a.setTerm(p3.getPredicate(), OpOr, p4.getPredicate());
  32     cond2b.setTerm(cond2.getPredicate(), OpAnd, cond2a.getPredicate());
  33     table->setCondition(&cond2b);
  34     printf("Predicate: (f1 ==3 OR  f2 > 2) AND (f3 !=5 OR f4 <5) ) \n");
  35     conn.startTransaction();
  36     execAndPrint(table);
  37     conn.commit();
  38
  39     dbMgr->closeTable(table);
  40     dbMgr->dropTable("t1");
  41     conn.close();
  42     return 0;
  43
  44 }
  45