test/dbapi/Predicate/orpredicate1.c

   1 //Testing OR operator with all comparision operator on int data type.
   2 //Five tuples are inserted and then selected by setting predicates
   3 //with OR operator
   4
   5 #include "common.h"
   6 int main()
   7 {
   8     Connection conn;
   9     DbRetVal rv = conn.open("root", "manager");
  10     if (rv != OK) return 1;
  11     DatabaseManager *dbMgr = conn.getDatabaseManager();
  12     if (dbMgr == NULL) { printf("Auth failed\n"); return 2;}
  13
  14     if ( createTable(dbMgr) != 0 ) { conn.close(); return 3; }
  15 #ifdef WITHF1INDEX
  16     if (createIndex(dbMgr, "f1", "idx1") != 0) {dbMgr->dropTable("t1");
  17                                         conn.close();
  18                                         return 4;
  19                                        }
  20 #endif
  21
  22 #ifdef WITHF2INDEX
  23     if (createIndex(dbMgr, "f2", "idx2" ) != 0) {dbMgr->dropTable("t1");
  24                                         conn.close();
  25                                         return 4;
  26                                        }
  27 #endif
  28
  29     int inscount =  insertTuple(dbMgr, conn);
  30     //check the inscount and return error
  31
  32     Table *table = dbMgr->openTable("t1");
  33     if (table == NULL)
  34     {
  35         printf("Unable to open table\n");
  36         return 0;
  37     }
  38
  39
  40     Condition p1,p2,p3,p4,p5;
  41     int val1 = 2, val2 = 3, val3 = 4;
  42     p1.setTerm("f1", OpEquals, &val3);
  43     p2.setTerm("f2", OpGreaterThan, &val2);
  44     p3.setTerm("f2", OpEquals, &val3);
  45     p4.setTerm("f1", OpLessThan, &val3);
  46     p5.setTerm("f1", OpGreaterThan, &val1);
  47
  48
  49     Condition cond1;
  50     cond1.setTerm(p1.getPredicate(), OpOr, p2.getPredicate());
  51     table->setCondition(&cond1);
  52     printf("Predicate: f1 ==4 OR f2 >3 \n");
  53     conn.startTransaction();
  54     execAndPrint(table);
  55     conn.commit();
  56
  57     Condition cond2;
  58     cond2.setTerm(p1.getPredicate(), OpOr, p3.getPredicate());
  59     table->setCondition(&cond2);
  60     printf("Predicate: f1 ==4 OR f2 ==4 \n");
  61     conn.startTransaction();
  62     execAndPrint(table);
  63     conn.commit();
  64
  65     Condition cond3;
  66     cond3.setTerm(p4.getPredicate(), OpOr, p5.getPredicate());
  67     table->setCondition(&cond3);
  68     printf("Predicate: f1 <4 OR f2 >2 \n");
  69     conn.startTransaction();
  70     execAndPrint(table);
  71     conn.commit();
  72
  73
  74     Condition cond4;
  75     cond4.setTerm(p4.getPredicate(), OpOr, p2.getPredicate());
  76     table->setCondition(&cond4);
  77     printf("Predicate: f1 <4 OR f2 >3 \n");
  78     conn.startTransaction();
  79     execAndPrint(table);
  80     conn.commit();
  81
  82     dbMgr->closeTable(table);
  83     dbMgr->dropTable("t1");
  84     conn.close();
  85     return 0;
  86
  87 }
  88