tmptest/create.c

   1 /***************************************************************************
   2  *   Copyright (C) 2007 by www.databasecache.com                           *
   3  *   Contact: praba_tuty@databasecache.com                                 *
   4  *                                                                         *
   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.                                   *
   9  *                                                                         *
  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.                          *
  14  *                                                                         *
  15   **************************************************************************/
  16 #include<CSql.h>
  17 int main()
  18 {
  19     //connect to the database first
  20     Connection conn;
  21     DbRetVal rv = conn.open("praba", "manager");
  22     if (rv != OK)
  23     {
  24        printf("Error during connection %d\n", rv);
  25        return -1;
  26     }
  27
  28     //get dbmgr to create table and index
  29     DatabaseManager *dbMgr = conn.getDatabaseManager();
  30     if (dbMgr == NULL) { printf("Auth failed\n"); return -1;}
  31
  32     //create table with two fields, f1 integer and f2 string
  33     TableDef tabDef;
  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     //idxInfo->isUnique = false;
  45     rv = dbMgr->createIndex("indx1", idxInfo);
  46     if (rv != OK) { printf("Index creation failed\n"); return -1; }
  47     printf("Index created\n");
  48
  49     conn.close();
  50     return 0;
  51 }