trie index tests addition
[csql.git] / test / dbapi / DataType / longtest.c
blob62473de0b86a2f1d90cf84fb6a22c8b6e01cc996
1 #include<CSql.h>
3 long 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 long 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 %ld %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", typeLong, 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
73 Table *table = dbMgr->openTable("t1");
74 if (table == NULL) { printf("Unable to open table\n"); return 4; }
75 table->bindFld("f1", &id);
76 table->bindFld("f2", name);
77 char *tuple;
78 int ret;
79 long i;
80 rv =conn.startTransaction();
81 for(i = 0; i< 5; i++)
83 if (rv != OK) exit(5);
84 id= i;
85 strcpy(name, "PRABAKARAN0123456750590");
86 ret = table->insertTuple();
87 if (ret != 0) break;
89 conn.commit();
91 conn.startTransaction();
92 select(table, OpEquals);
93 conn.commit();
95 conn.startTransaction();
96 select(table, OpNotEquals);
97 conn.commit();
99 conn.startTransaction();
100 select(table, OpLessThan);
101 conn.commit();
103 conn.startTransaction();
104 select( table, OpLessThanEquals);
105 conn.commit();
107 conn.startTransaction();
108 select( table, OpGreaterThan);
109 conn.commit();
111 conn.startTransaction();
112 select( table, OpGreaterThanEquals);
113 conn.commit();
115 dbMgr->closeTable(table);
116 dbMgr->dropTable("t1");
118 conn.close();
119 return 0;