tmwserv/src/dal/mysqldataprovider.h

/*
 *  The Mana World Server
 *  Copyright 2004 The Mana World Development Team
 *
 *  This file is part of The Mana World.
 *
 *  The Mana World  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 any later version.
 *
 *  The Mana  World 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 The Mana  World; if not, write to the  Free Software Foundation, Inc.,
 *  59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
 */

#ifndef _TMWSERV_MYSQL_DATA_PROVIDER_H_
#define _TMWSERV_MYSQL_DATA_PROVIDER_H_


#include <iosfwd>
// added to compile under windows
#ifdef WIN32
#include <winsock2.h>
#endif
#include <mysql/mysql.h>
#include <climits>

#include "dataprovider.h"
#include "common/configuration.hpp"
#include "utils/logger.h"

namespace dal
{


class MySqlDataProvider: public DataProvider
{
    public:

        enum {
            AUTOCOMMIT_OFF = 0,
            AUTOCOMMIT_ON = 1
        };

        MySqlDataProvider(void)
            throw();


        ~MySqlDataProvider(void)
            throw();


        DbBackends
        getDbBackend(void) const
            throw();


        void connect();


        const RecordSet&
        execSql(const std::string& sql,
                const bool refresh = false);


        void
        disconnect(void);

        void
        beginTransaction(void)
            throw (std::runtime_error);

        void
        commitTransaction(void)
            throw (std::runtime_error);

        void
        rollbackTransaction(void)
            throw (std::runtime_error);

        const unsigned int
        getModifiedRows(void) const;

        const unsigned int
        getLastId(void) const;

    private:

        static const std::string CFGPARAM_MYSQL_HOST;
        static const std::string CFGPARAM_MYSQL_PORT;
        static const std::string CFGPARAM_MYSQL_DB;
        static const std::string CFGPARAM_MYSQL_USER;
        static const std::string CFGPARAM_MYSQL_PWD;

        static const std::string CFGPARAM_MYSQL_HOST_DEF;
        static const unsigned int CFGPARAM_MYSQL_PORT_DEF;
        static const std::string CFGPARAM_MYSQL_DB_DEF;
        static const std::string CFGPARAM_MYSQL_USER_DEF;
        static const std::string CFGPARAM_MYSQL_PWD_DEF;


        MYSQL* mDb; 
};


} // namespace dal

#endif // _TMWSERV_MYSQL_DATA_PROVIDER_H_

---