trie index tests addition
[csql.git] / test / dbapi / DataType / inttest.c
blobeb8a55036add49e8681f69256cb5cd1927539b06
1 #include<CSql.h>
3 int id = 0;
4 char name[196] = "PRABAKARAN";
5 int select(Table *table, ComparisionOp op)
7 printf("Operator test for %d\n", op);
8 Condition p1;
9 int val1 = 3;
10 p1.setTerm("f1", op, &val1);
11 table->setCondition(&p1);
12 table->execute();
13 void *tuple;
14 while ((tuple = (char*) table->fetch())) {
15 printf("tuple value is %d %s \n", id, name);
17 table->closeScan();
18 return 0;
21 int main()
24 Connection conn;
25 DbRetVal rv = conn.open("root", "manager");
26 if (rv != OK)
28 printf("Error during connection %d\n", rv);
29 return 1;
31 DatabaseManager *dbMgr = conn.getDatabaseManager();
32 if (dbMgr == NULL) { printf("Auth failed\n"); return 2;}
33 TableDef tabDef;
34 tabDef.addField("f1", typeInt, 0, NULL, true);
35 tabDef.addField("f2", typeString, 196);
36 rv = dbMgr->createTable("t1", tabDef);
37 if (rv != OK) { printf("Table creation failed\n"); return 3; }
38 printf("Table created\n");
39 #ifdef WITHINDEX
40 HashIndexInitInfo *idxInfo = new HashIndexInitInfo();
41 strcpy(idxInfo->tableName, "t1");
42 idxInfo->list.append("f1");
43 idxInfo->indType = hashIndex;
44 idxInfo->isUnique = true;
45 idxInfo->isPrimary = true;
46 rv = dbMgr->createIndex("indx1", idxInfo);
47 if (rv != OK) { printf("Index creation failed\n"); return -1; }
48 printf("Index created\n");
49 delete idxInfo;
50 #endif
51 #ifdef WITHTREEINDEX
52 HashIndexInitInfo *idxInfo = new HashIndexInitInfo();
53 strcpy(idxInfo->tableName, "t1");
54 idxInfo->list.append("f1");
55 idxInfo->indType = treeIndex;
56 rv = dbMgr->createIndex("indx1", idxInfo);
57 if (rv != OK) { printf("Index creation failed\n"); return -1; }
58 printf("Index created\n");
59 delete idxInfo;
60 #endif
61 #ifdef WITHTRIEINDEX
62 HashIndexInitInfo *idxInfo = new HashIndexInitInfo();
63 strcpy(idxInfo->tableName, "t1");
64 idxInfo->list.append("f1");
65 idxInfo->indType = trieIndex;
66 rv = dbMgr->createIndex("indx1", idxInfo);
67 if (rv != OK) { printf("Index creation failed\n"); return -1; }
68 printf("Index created\n");
69 delete idxInfo;
70 #endif
72 Table *table = dbMgr->openTable("t1");
73 if (table == NULL) { printf("Unable to open table\n"); return 4; }
74 table->bindFld("f1", &id);
75 table->bindFld("f2", name);
76 char *tuple;
77 int ret;
78 int i;
79 rv =conn.startTransaction();
80 for(i = 0; i< 5; i++)
82 if (rv != OK) exit(5);
83 id= i;
84 strcpy(name, "PRABAKARAN0123456750590");
85 ret = table->insertTuple();
86 if (ret != 0) break;
88 conn.commit();
90 conn.startTransaction();
91 select(table, OpEquals);
92 conn.commit();
94 conn.startTransaction();
95 select(table, OpNotEquals);
96 conn.commit();
98 conn.startTransaction();
99 select(table, OpLessThan);
100 conn.commit();
102 conn.startTransaction();
103 select( table, OpLessThanEquals);
104 conn.commit();
106 conn.startTransaction();
107 select( table, OpGreaterThan);
108 conn.commit();
110 conn.startTransaction();
111 select( table, OpGreaterThanEquals);
112 conn.commit();
114 dbMgr->closeTable(table);
115 dbMgr->dropTable("t1");
117 conn.close();
118 return 0;