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;}
11 if ( createTable(dbMgr
) != 0 ) { conn
.close(); return 3; }
12 int inscount
= insertTuple(dbMgr
, conn
);
13 //check the inscount and return error
15 Table
*table
= dbMgr
->openTable("t1");
18 printf("Unable to open table\n");
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
);
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();
39 dbMgr
->closeTable(table
);
40 dbMgr
->dropTable("t1");