include/DatabaseManagerImpl.h

   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 #ifndef DATABASE_MANAGER_IMPL_H
  17 #define DATABASE_MANAGER_IMPL_H
  18 #include<os.h>
  19 #include<CatalogTables.h>
  20 #include<Lock.h>
  21 #include<DatabaseManager.h>
  22 #include<Process.h>
  23 #include<Util.h>
  24 //Note::DatabaseManagerImpl is used to hide functionalites from normal database user.
  25 //User is exposed to DatabaseManagerImpl, for our tools we shall type cast DatabaseManager
  26 //to DatabaseManagerImpl to retreive internal information such as db statistics, etc
  27 class Database;
  28 class SessionImpl;
  29 class TableDef;
  30 class Table;
  31 class FieldNameList;
  32 class ChunkIterator;
  33 class Chunk;
  34 class TransactionManager;
  35 class CSqlProcInfo
  36 {
  37     public:
  38     CSqlProcInfo() { sysDbAttachAddr = userDbAttachAddr = NULL;}
  39     void *sysDbAttachAddr;
  40     void *userDbAttachAddr;
  41 };
  42
  43 //Global object
  44 static CSqlProcInfo csqlProcInfo;
  45
  46 class DatabaseManagerImpl : public DatabaseManager
  47 {
  48     private:
  49     Database* systemDatabase_;
  50     //pointer to system Database
  51
  52     Database* db_;
  53     //pointer to database
  54
  55     LockManager *lMgr_;
  56
  57     TransactionManager *tMgr_;
  58
  59
  60     ProcessManager *pMgr_;
  61     int procSlot;
  62
  63     List tableHandleList; // list of table handles
  64
  65     //only SessionImpl creates object of this class
  66     DatabaseManagerImpl() { systemDatabase_ = NULL; tMgr_ = NULL; lMgr_ =  NULL;
  67                             pMgr_ = NULL; db_ = NULL; }
  68     ~DatabaseManagerImpl();
  69
  70     DbRetVal openSystemDatabase();
  71     DbRetVal closeSystemDatabase();
  72     ChunkIterator getSystemTableIterator(CatalogTableID id);
  73     Chunk* getSystemTableChunk(CatalogTableID id);
  74
  75     void createLockManager();
  76     void createTransactionManager();
  77
  78     Chunk* createUserChunk(size_t size = 0);
  79     DbRetVal deleteUserChunk(Chunk *chunk);
  80
  81
  82     DbRetVal createHashIndex(const char *indName, const char *tableName,
  83                         FieldNameList &fldList, int bucketSize, bool isUnique, bool isPrimary = false);
  84     DbRetVal createTreeIndex(const char *indName, const char *tableName,
  85              FieldNameList &fldList, int bucketSize, bool isUnique, bool isPrimary = false);
  86     void initHashBuckets(Bucket *buck, int bucketSize);
  87
  88     DbRetVal dropIndexInt(const char *name, bool takeLock);
  89     DbRetVal writeSchemaFile();
  90     public:
  91
  92     Database* db() { return db_; }
  93     Database* sysDb() { return systemDatabase_; }
  94     void setSysDb(Database *db) { systemDatabase_ = db; }
  95     void setDb(Database *db) { db_ = db; }
  96
  97     void setProcSlot();
  98     TransactionManager* txnMgr() { return tMgr_; }
  99     LockManager* lockMgr() { return lMgr_; }
 100
 101     //for user database file there is no limit for the number
 102     //of tables or chunks
 103     DbRetVal createDatabase(const char *name, size_t size);
 104     DbRetVal deleteDatabase(const char *name);
 105
 106     DbRetVal openDatabase(const char *name);
 107     DbRetVal closeDatabase();
 108
 109
 110     DbRetVal createTable(const char *name, TableDef &def);
 111     DbRetVal dropTable(const char *name);
 112     Table* openTable(const char *name, bool checkpkfk=true);
 113     void closeTable(Table *table);
 114     DbRetVal createIndex(const char *indName, IndexInitInfo *info);
 115     DbRetVal dropIndex(const char *name);
 116     DbRetVal createForeignKey(char *kfName,ForeignKeyInfo *info);
 117     DbRetVal dropForeignKey(void *ctptr,bool trylock);
 118     List getAllTableNames(int *rv=NULL);
 119
 120     DbRetVal registerThread();
 121     DbRetVal deregisterThread();
 122     bool isAnyOneRegistered();
 123     void printUsageStatistics();
 124     void printDebugLockInfo();
 125     void printDebugTransInfo();
 126     void printDebugChunkInfo();
 127     void printDebugProcInfo();
 128     int getNoOfPagesForTable(char *tblName);
 129     DbRetVal loadRecords(char *tblName, char *buffer);
 130     DbRetVal pasteRecords(char *tblName, void *buffer);
 131     DbRetVal checkPoint();
 132     DbRetVal recover();
 133     DbRetVal printIndexInfo(char *name);
 134     void printTreeIndexNodeInfo(char *name,bool flag);
 135     friend class SessionImpl;
 136 };
 137 #endif