2 * Copyright (C) 2005-2008 MaNGOS <http://getmangos.com/>
4 * This program is free software; you can redistribute it and/or modify
5 * it under the terms of the GNU General Public License as published by
6 * the Free Software Foundation; either version 2 of the License, or
7 * (at your option) any later version.
9 * This program is distributed in the hope that it will be useful,
10 * but WITHOUT ANY WARRANTY; without even the implied warranty of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 * GNU General Public License for more details.
14 * You should have received a copy of the GNU General Public License
15 * along with this program; if not, write to the Free Software
16 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
21 #ifndef _DATABASEMYSQL_H
22 #define _DATABASEMYSQL_H
25 #include "Policies/Singleton.h"
26 #include "zthread/FastMutex.h"
29 #define FD_SETSIZE 1024
31 #include <mysql/mysql.h>
36 class MANGOS_DLL_SPEC DatabaseMysql
: public Database
38 friend class MaNGOS::OperatorNew
<DatabaseMysql
>;
44 //! Initializes Mysql and connects to a server.
45 /*! infoString should be formated like hostname;username;password;database. */
46 bool Initialize(const char *infoString
);
47 void InitDelayThread();
48 void HaltDelayThread();
49 QueryResult
* Query(const char *sql
);
50 bool Execute(const char *sql
);
51 bool DirectExecute(const char* sql
);
52 bool BeginTransaction();
53 bool CommitTransaction();
54 bool RollbackTransaction();
56 operator bool () const { return mMysql
!= NULL
; }
58 unsigned long escape_string(char *to
, const char *from
, unsigned long length
);
59 using Database::escape_string
;
61 // must be call before first query in thread
63 // must be call before finish thread run
66 ZThread::FastMutex mMutex
;
68 ZThread::ThreadImpl
* tranThread
;
72 static size_t db_count
;
74 bool _TransactionCmd(const char *sql
);