andandpredicate1.c

b树实现源码,linux和unix下运行,速度快,极好用

//Testing AND with AND operator with all comparision operator on int data type.
//Five tuples are inserted and then selected by setting predicates

#include "common.h"
int main()
{
    Connection conn;
    DbRetVal rv = conn.open("root", "manager");
    if (rv != OK) return 1;
    DatabaseManager *dbMgr = conn.getDatabaseManager();
    if (dbMgr == NULL) { printf("Auth failed\n"); return 2;}

    if ( createTable(dbMgr) != 0 ) { conn.close(); return 3; }
    int inscount =  insertTuple(dbMgr, conn);
    //check the inscount and return error

    Table *table = dbMgr->openTable("t1");
    if (table == NULL)
    {
        printf("Unable to open table\n");
        return 0;
    }


    Condition p1,p2,p3,p4,p5;
    int val1 = 2, val2 = 3, val3 = 5;
    p1.setTerm("f1", OpEquals, &val2);
    p2.setTerm("f2", OpGreaterThan, &val1);
    p3.setTerm("f3", OpNotEquals, &val3);
    p4.setTerm("f4", OpLessThan, &val3);
    p5.setTerm("f5", OpGreaterThanEquals, &val2);


    Condition cond1, cond1a, cond1b, cond1c;
    cond1.setTerm(p1.getPredicate(), OpAnd, p2.getPredicate());
    cond1a.setTerm(cond1.getPredicate(), OpAnd, p3.getPredicate());
    cond1b.setTerm(cond1a.getPredicate(), OpAnd, p4.getPredicate());
    cond1c.setTerm(cond1b.getPredicate(), OpAnd, p5.getPredicate());
    table->setCondition(&cond1c);
    printf("Predicate: (f1 ==3 AND  f2 > 2 AND f3 !=5 AND f4 <5 AND f5 >=3 ) \n");
    conn.startTransaction();
    execAndPrint(table);
    conn.commit();

    Condition cond2, cond2a, cond2b;
    cond2.setTerm(p1.getPredicate(), OpAnd, p2.getPredicate());
    cond2a.setTerm(p3.getPredicate(), OpAnd, p4.getPredicate());
    cond2b.setTerm(cond2.getPredicate(), OpAnd, cond2a.getPredicate());
    table->setCondition(&cond2b);
    printf("Predicate: (f1 ==3 AND  f2 > 2) AND (f3 !=5 AND f4 <5) ) \n");
    conn.startTransaction();
    execAndPrint(table);
    conn.commit();

    dbMgr->closeTable(table);
    dbMgr->dropTable("t1");
    conn.close();
    return 0;

}