[Home]	[About]
[Screenshots]	[Download]
[News]	[Community]
[Documentation]	[Manual]
[Bugs & Requests]	[Wiki]

/home/tetron/hack/vos/libs/vos/extensions/sqlpersist/mysqldb.hh

Go to the documentation of this file.

#ifndef _MYSQLDB_HH_
#define _MYSQLDB_HH_

#include <vos/vosconfig.h>
#include <boost/thread/mutex.hpp>
#include <vos/extensions/sqlpersist/sqldb.hh>

#ifdef HAVE_MYSQL_MYSQL_H
#include <mysql/mysql.h>
#else
#error HAVE_MYSQL_MYSQL_H is not defined.  Did configure find MySQL?
#endif

namespace VOS {
    class MySQLResult : public SQLResult
    {
    private:
        MYSQL* database;
        MYSQL_RES* result;
        boost::mutex::scoped_lock* lock;
    public:
        MySQLResult(MYSQL* db, MYSQL_RES* res, boost::mutex::scoped_lock* lock);
        virtual ~MySQLResult();
        virtual int countRows();
        virtual SQLRow* getNextRow();
    };

    class SQLPERSIST_API MySQLDatabase : public SQLDatabase
    {
    private:
        MYSQL* database;
        boost::mutex db_mutex;
    public:
        MySQLDatabase(const char* hostname = "localhost", const char* username = "root",
                      const char* password = "", int port = MYSQL_PORT);
        virtual ~MySQLDatabase();

        virtual SQLResult* query(const char* q, unsigned int len);
        virtual bool selectDatabase(const char* db);
        virtual std::string lastError();
        virtual unsigned int escapeString(char* to, const char* from, unsigned int fromlen);
        virtual unsigned int getAffectedRows();
    };
}

#endif