|

MySQLDatabase.hpp

Go to the documentation of this file.

#ifndef IONFLUX_TOOLS_MYSQLDATABASE
#define IONFLUX_TOOLS_MYSQLDATABASE
/* ==========================================================================
 * Ionflux Tools
 * Copyright (c) 2004 Joern P. Meier
 * mail@ionflux.org
 * --------------------------------------------------------------------------
 * MySQLDatabase.hpp                   MySQL database wrapper
 * ==========================================================================
 * 
 * This file is part of Ionflux Tools.
 * 
 * Ionflux Tools is free software; you can redistribute it and/or modify it 
 * under the terms of the GNU General Public License as published by the Free
 * Software Foundation; either version 2 of the License, or (at  your option)
 * any later version.
 * 
 * Ionflux Tools is distributed in the hope that it will be useful, but 
 * WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
 * or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License
 * for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with Ionflux Tools; if not, write to the Free Software Foundation, 
 * Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
 * 
 * ========================================================================== */

#include <iostream>
#include <mysql/mysql.h>
#include "ionflux/Database.hpp"

namespace Ionflux
{

namespace Tools
{

class MySQLDatabaseClassInfo
: public ClassInfo
{
    public:
        MySQLDatabaseClassInfo();
        virtual ~MySQLDatabaseClassInfo() { };
};

class MySQLDatabase
: public Database
{
    protected:
        DatabaseConfig config;
        MYSQL *mysql;
        MYSQL_RES *queryResult;
        unsigned int numRows;
        unsigned int numFields;
        int numAffectedRows;
        DatabaseError lastError;
        
        void freeResult();
        
    public:
        static const std::string DEFAULT_SERVER;
        static const unsigned int DEFAULT_PORT;
        static const std::string DEFAULT_USERNAME;
        static const std::string DEFAULT_PASSWORD;
        static const std::string DEFAULT_DATABASE;
        static const MySQLDatabaseClassInfo mySQLDatabaseClassInfo;
        static const ClassInfo* CLASS_INFO;
        
        MySQLDatabase();
        
        MySQLDatabase(const DatabaseConfig &initConfig);
        
        virtual ~MySQLDatabase();
        
        virtual void setConfig(const DatabaseConfig &newConfig);
        
        virtual void setConfig(Ionflux::Tools::Node &newConfig);
        
        virtual DatabaseConfig getConfig();
        
        virtual bool connect();
        
        virtual void close();
        
        virtual bool query(const std::string &command);
        
        virtual bool listTables(DbTables &tables, 
            const std::string &pattern = "");
        
        virtual bool listColumns(DbColumns &columns, 
            const std::string &table);
        
        virtual unsigned int getNumRows(const std::string &table);
        
        virtual unsigned int getNumRows();
        
        virtual unsigned int getNumAffectedRows();
        
        virtual bool fetchRow(DbRow &row);
        
        virtual bool fetchRowMap(DbRowMap &rowMap);
        
        virtual bool fetchRowTree(Node &rowNode);
        
        virtual bool fetchResult(DbResult &result);
        
        virtual bool fetchResultMap(DbResultMap &resultMap);
        
        virtual bool fetchResultTree(Node &resultNode, int nodeOrder);
        
        virtual std::string sqlEscape(const std::string &source);
        
        virtual bool validateTable(const std::string& tableName, 
            const std::string& createTemplate = "", 
            Node* createConfig = 0);
        
        virtual DatabaseError getError();
        
};

}

}

#endif

---