1 /***************************************************************************
2 * Copyright (C) 2007 by www.databasecache.com *
3 * Contact: praba_tuty@databasecache.com *
5 * This program is free software; you can redistribute it and/or modify *
6 * it under the terms of the GNU General Public License as published by *
7 * the Free Software Foundation; either version 2 of the License, or *
8 * (at your option) any later version. *
10 * This program is distributed in the hope that it will be useful, *
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
13 * GNU General Public License for more details. *
15 **************************************************************************/
19 //connect to the database first
21 DbRetVal rv
= conn
.open("praba", "manager");
24 printf("Error during connection %d\n", rv
);
28 //get dbmgr to create table and index
29 DatabaseManager
*dbMgr
= conn
.getDatabaseManager();
30 if (dbMgr
== NULL
) { printf("Auth failed\n"); return -1;}
32 //create table with two fields, f1 integer and f2 string
34 tabDef
.addField("f1", typeInt
, 0, NULL
, true, true);
35 tabDef
.addField("f2", typeInt
);
36 rv
= dbMgr
->createTable("t1", tabDef
);
37 if (rv
!= OK
) { printf("Table creation failed\n"); return -1; }
38 printf("Table created\n");
39 //Creating hash index on field f1 of table t1
40 HashIndexInitInfo
*idxInfo
= new HashIndexInitInfo();
41 strcpy(idxInfo
->tableName
, "t1");
42 idxInfo
->list
.append("f1");
43 idxInfo
->indType
= hashIndex
;
44 rv
= dbMgr
->createIndex("indx1", idxInfo
);
45 if (rv
!= OK
) { printf("Index creation failed\n"); return -1; }
46 printf("Index created\n");