src/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 #include "RowSet.h"
  28
  29 Database* Database::instance = NULL;
  30
  31 Database::Database()
  32 {
  33    int status = sqlite3_open(ASGARD_DATABASE, &this->asgardDb);
  34
  35    if(status != SQLITE_OK)
  36    {
  37       sqlite3_close(this->asgardDb);
  38    }
  39
  40    // TODO: Add some type of logging for status
  41 }
  42
  43 Database::~Database()
  44 {
  45    sqlite3_close(this->asgardDb);
  46 }
  47
  48 Database* Database::getInstance()
  49 {
  50    if(instance == NULL) instance = new Database();
  51    return instance;
  52 }
  53
  54 void Database::determineVisibleBoxes(Coordinate currentPosition, int *visibleBoxes, int numVisibleBoxes)
  55 {
  56    // Map as of 0.3.0 is 1 boundbox, 0.
  57    visibleBoxes[0] =  1;
  58 }
  59
  60 bool Database::loadBoundingBox(int boxId)
  61 {
  62    char* query;
  63    MapObjectType type;
  64    char *sqliteErrorCode;
  65
  66    // Invalid Bounding Box
  67    if (boxId <= 0)
  68       return false;
  69
  70    // NonPlayerCharacter
  71    query = QueryGenerator::nonPlayerCharacter(boxId);
  72    type = MAP_OBJECT_TYPE_NON_PLAYER_CHARACTER;
  73    sqlite3_exec(this->asgardDb, query, MapObjectFactory::processRow, (void*)&type, &sqliteErrorCode);
  74    delete query;
  75
  76    // Container
  77    query = QueryGenerator::container(boxId);
  78    type = MAP_OBJECT_TYPE_CONTAINER;
  79    sqlite3_exec(this->asgardDb, query, MapObjectFactory::processRow, (void*)&type, &sqliteErrorCode);
  80    delete query;
  81
  82    // StaticMapObject
  83    query = QueryGenerator::staticMapObject(boxId);
  84    type = MAP_OBJECT_TYPE_STATIC_MAP_OBJECT;
  85    sqlite3_exec(this->asgardDb, query, MapObjectFactory::processRow, (void*)&type, &sqliteErrorCode);
  86    delete query;
  87
  88    // Tile
  89    query = QueryGenerator::tile(boxId);
  90    type = MAP_OBJECT_TYPE_TILE;
  91    sqlite3_exec(this->asgardDb, query, MapObjectFactory::processRow, (void*)&type, &sqliteErrorCode);
  92    delete query;
  93
  94    sqlite3_free(sqliteErrorCode);
  95
  96    return true;
  97 }
  98
  99 RowSet* Database::loadHardpoints(int smoId)
 100 {
 101    RowSet* rs = new RowSet();
 102    char* query;
 103    int rc;
 104
 105    query = QueryGenerator::hardpoint(smoId);
 106    rc = rs->select(this->asgardDb, query);
 107    delete query;
 108
 109    if (rc == SQLITE_OK)
 110    {
 111       assert(rs->getColCount() == HARDPOINT_COLUMN_COUNT);
 112    }
 113
 114    return rs;
 115 }
 116
 117 RowSet* Database::loadNonPlayerCharacterPath(int npcId)
 118 {
 119    RowSet* rs = new RowSet();
 120    char* query;
 121    int rc;
 122
 123    query = QueryGenerator::nonPlayerCharacterPath(npcId);
 124    rc = rs->select(this->asgardDb, query);
 125    delete query;
 126
 127    if (rc == SQLITE_OK)
 128    {
 129       assert(rs->getColCount() == NON_PLAYER_CHARACTER_PATH_COLUMN_COUNT);
 130    }
 131
 132    return rs;
 133
 134 }