Database.cpp

   1 /*****************************************************************************
   2  * Copyright (c) 2007 Russ Adams, Sean Eubanks, Asgard Contributors
   3  * This file is part of Asgard.
   4  *
   5  * Asgard 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  * Asgard 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  * You should have received a copy of the GNU General Public License
  16  * along with Asgard; if not, write to the Free Software
  17  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
  18  ****************************************************************************/
  19
  20 #include <cassert>
  21 #include "Database.h"
  22 #include "MapObjectFactory.h"
  23 #include "MapObjectType.h"
  24 #include "QueryGenerator.h"
  25 #include "DatabaseColumnMap.h"
  26 #include "GameEngine.h"
  27
  28 Database* Database::instance = NULL;
  29
  30 Database::Database()
  31 {
  32    int status = sqlite3_open(ASGARD_DATABASE, &this->asgardDb);
  33
  34    if(status != SQLITE_OK)
  35    {
  36       sqlite3_close(this->asgardDb);
  37    }
  38
  39    // TODO: Add some type of logging for status
  40 }
  41
  42 Database::~Database()
  43 {
  44    sqlite3_close(this->asgardDb);
  45 }
  46
  47 Database* Database::getInstance()
  48 {
  49    if(instance == NULL) instance = new Database();
  50    return instance;
  51 }
  52
  53 void Database::determineVisibleBoxes(Coordinate currentPosition, int *visibleBoxes, int numVisibleBoxes)
  54 {
  55
  56 }
  57
  58 bool Database::loadBoundingBox(int boxId)
  59 {
  60    char **sqliteErrorCode;
  61
  62    sqlite3_exec(this->asgardDb, QueryGenerator::container(boxId), MapObjectFactory::processRow, (void*)(MAP_OBJECT_TYPE_CONTAINER), sqliteErrorCode);
  63    sqlite3_exec(this->asgardDb, QueryGenerator::nonPlayerCharacter(boxId), MapObjectFactory::processRow, (void*)MAP_OBJECT_TYPE_NON_PLAYER_CHARACTER, sqliteErrorCode);
  64    sqlite3_exec(this->asgardDb, QueryGenerator::staticMapObject(boxId), MapObjectFactory::processRow, (void*)MAP_OBJECT_TYPE_STATIC_MAP_OBJECT, sqliteErrorCode);
  65    sqlite3_exec(this->asgardDb, QueryGenerator::tile(boxId), MapObjectFactory::processRow, (void*)MAP_OBJECT_TYPE_TILE, sqliteErrorCode);
  66
  67    return true;
  68 }
  69
  70 char*** Database::loadHardpoints(int smoId)
  71 {
  72    char*** table = NULL;
  73    int* numRows;
  74    int* numColumns;
  75    char** sqliteErrorCode;
  76
  77    sqlite3_get_table(this->asgardDb, QueryGenerator::hardpoint(smoId), table, numRows, numColumns, sqliteErrorCode);
  78
  79    assert(*numColumns == CONTAINER_COLUMN_COUNT);
  80
  81    return table;
  82 }
  83
  84 char*** Database::loadNonPlayerCharacterPath(int npcId)
  85 {
  86    char*** table = NULL;
  87    int* numRows;
  88    int* numColumns;
  89    char** sqliteErrorCode;
  90
  91    sqlite3_get_table(this->asgardDb, QueryGenerator::nonPlayerCharacterPath(npcId), table, numRows, numColumns, sqliteErrorCode);
  92
  93    assert(*numColumns == HARDPOINT_COLUMN_COUNT);
  94
  95    return table;
  96 }