src/shared/Database/DatabaseImpl.h

   1 /*
   2  * Copyright (C) 2005-2008 MaNGOS <http://getmangos.com/>
   3  *
   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.
   8  *
   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.
  13  *
  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
  17  */
  18
  19 #include "Database/Database.h"
  20 #include "Database/SqlOperations.h"
  21
  22 /// Function body definitions for the template function members of the Database class
  23
  24 #define ASYNC_QUERY_BODY(sql, queue_itr) \
  25     if (!sql) return false; \
  26     \
  27     QueryQueues::iterator queue_itr; \
  28     \
  29     { \
  30         ZThread::ThreadImpl * queryThread = ZThread::ThreadImpl::current(); \
  31         queue_itr = m_queryQueues.find(queryThread); \
  32         if (queue_itr == m_queryQueues.end()) return false; \
  33     }
  34
  35 #define ASYNC_PQUERY_BODY(format, szQuery) \
  36     if(!format) return false; \
  37     \
  38     char szQuery [MAX_QUERY_LEN]; \
  39     \
  40     { \
  41         va_list ap; \
  42         \
  43         va_start(ap, format); \
  44         int res = vsnprintf( szQuery, MAX_QUERY_LEN, format, ap ); \
  45         va_end(ap); \
  46         \
  47         if(res==-1) \
  48         { \
  49             sLog.outError("SQL Query truncated (and not execute) for format: %s",format); \
  50             return false; \
  51         } \
  52     }
  53
  54 #define ASYNC_DELAYHOLDER_BODY(holder, queue_itr) \
  55     if (!holder) return false; \
  56     \
  57     QueryQueues::iterator queue_itr; \
  58     \
  59     { \
  60         ZThread::ThreadImpl * queryThread = ZThread::ThreadImpl::current(); \
  61         queue_itr = m_queryQueues.find(queryThread); \
  62         if (queue_itr == m_queryQueues.end()) return false; \
  63     }
  64
  65 // -- Query / member --
  66
  67 template<class Class>
  68 bool
  69 Database::AsyncQuery(Class *object, void (Class::*method)(QueryResult*), const char *sql)
  70 {
  71     ASYNC_QUERY_BODY(sql, itr)
  72     return m_threadBody->Delay(new SqlQuery(sql, new MaNGOS::QueryCallback<Class>(object, method), itr->second));
  73 }
  74
  75 template<class Class, typename ParamType1>
  76 bool
  77 Database::AsyncQuery(Class *object, void (Class::*method)(QueryResult*, ParamType1), ParamType1 param1, const char *sql)
  78 {
  79     ASYNC_QUERY_BODY(sql, itr)
  80     return m_threadBody->Delay(new SqlQuery(sql, new MaNGOS::QueryCallback<Class, ParamType1>(object, method, (QueryResult*)NULL, param1), itr->second));
  81 }
  82
  83 template<class Class, typename ParamType1, typename ParamType2>
  84 bool
  85 Database::AsyncQuery(Class *object, void (Class::*method)(QueryResult*, ParamType1, ParamType2), ParamType1 param1, ParamType2 param2, const char *sql)
  86 {
  87     ASYNC_QUERY_BODY(sql, itr)
  88     return m_threadBody->Delay(new SqlQuery(sql, new MaNGOS::QueryCallback<Class, ParamType1, ParamType2>(object, method, (QueryResult*)NULL, param1, param2), itr->second));
  89 }
  90
  91 template<class Class, typename ParamType1, typename ParamType2, typename ParamType3>
  92 bool
  93 Database::AsyncQuery(Class *object, void (Class::*method)(QueryResult*, ParamType1, ParamType2, ParamType3), ParamType1 param1, ParamType2 param2, ParamType3 param3, const char *sql)
  94 {
  95     ASYNC_QUERY_BODY(sql, itr)
  96     return m_threadBody->Delay(new SqlQuery(sql, new MaNGOS::QueryCallback<Class, ParamType1, ParamType2, ParamType3>(object, method, (QueryResult*)NULL, param1, param2, param3), itr->second));
  97 }
  98
  99 // -- Query / static --
 100
 101 template<typename ParamType1>
 102 bool
 103 Database::AsyncQuery(void (*method)(QueryResult*, ParamType1), ParamType1 param1, const char *sql)
 104 {
 105     ASYNC_QUERY_BODY(sql, itr)
 106     return m_threadBody->Delay(new SqlQuery(sql, new MaNGOS::SQueryCallback<ParamType1>(method, (QueryResult*)NULL, param1), itr->second));
 107 }
 108
 109 template<typename ParamType1, typename ParamType2>
 110 bool
 111 Database::AsyncQuery(void (*method)(QueryResult*, ParamType1, ParamType2), ParamType1 param1, ParamType2 param2, const char *sql)
 112 {
 113     ASYNC_QUERY_BODY(sql, itr)
 114     return m_threadBody->Delay(new SqlQuery(sql, new MaNGOS::SQueryCallback<ParamType1, ParamType2>(method, (QueryResult*)NULL, param1, param2), itr->second));
 115 }
 116
 117 template<typename ParamType1, typename ParamType2, typename ParamType3>
 118 bool
 119 Database::AsyncQuery(void (*method)(QueryResult*, ParamType1, ParamType2, ParamType3), ParamType1 param1, ParamType2 param2, ParamType3 param3, const char *sql)
 120 {
 121     ASYNC_QUERY_BODY(sql, itr)
 122     return m_threadBody->Delay(new SqlQuery(sql, new MaNGOS::SQueryCallback<ParamType1, ParamType2, ParamType3>(method, (QueryResult*)NULL, param1, param2, param3), itr->second));
 123 }
 124
 125 // -- PQuery / member --
 126
 127 template<class Class>
 128 bool
 129 Database::AsyncPQuery(Class *object, void (Class::*method)(QueryResult*), const char *format,...)
 130 {
 131     ASYNC_PQUERY_BODY(format, szQuery)
 132     return AsyncQuery(object, method, szQuery);
 133 }
 134
 135 template<class Class, typename ParamType1>
 136 bool
 137 Database::AsyncPQuery(Class *object, void (Class::*method)(QueryResult*, ParamType1), ParamType1 param1, const char *format,...)
 138 {
 139     ASYNC_PQUERY_BODY(format, szQuery)
 140     return AsyncQuery(object, method, param1, szQuery);
 141 }
 142
 143 template<class Class, typename ParamType1, typename ParamType2>
 144 bool
 145 Database::AsyncPQuery(Class *object, void (Class::*method)(QueryResult*, ParamType1, ParamType2), ParamType1 param1, ParamType2 param2, const char *format,...)
 146 {
 147     ASYNC_PQUERY_BODY(format, szQuery)
 148     return AsyncQuery(object, method, param1, param2, szQuery);
 149 }
 150
 151 template<class Class, typename ParamType1, typename ParamType2, typename ParamType3>
 152 bool
 153 Database::AsyncPQuery(Class *object, void (Class::*method)(QueryResult*, ParamType1, ParamType2, ParamType3), ParamType1 param1, ParamType2 param2, ParamType3 param3, const char *format,...)
 154 {
 155     ASYNC_PQUERY_BODY(format, szQuery)
 156     return AsyncQuery(object, method, param1, param2, param3, szQuery);
 157 }
 158
 159 // -- PQuery / static --
 160
 161 template<typename ParamType1>
 162 bool
 163 Database::AsyncPQuery(void (*method)(QueryResult*, ParamType1), ParamType1 param1, const char *format,...)
 164 {
 165     ASYNC_PQUERY_BODY(format, szQuery)
 166     return AsyncQuery(method, param1, szQuery);
 167 }
 168
 169 template<typename ParamType1, typename ParamType2>
 170 bool
 171 Database::AsyncPQuery(void (*method)(QueryResult*, ParamType1, ParamType2), ParamType1 param1, ParamType2 param2, const char *format,...)
 172 {
 173     ASYNC_PQUERY_BODY(format, szQuery)
 174     return AsyncQuery(method, param1, param2, szQuery);
 175 }
 176
 177 template<typename ParamType1, typename ParamType2, typename ParamType3>
 178 bool
 179 Database::AsyncPQuery(void (*method)(QueryResult*, ParamType1, ParamType2, ParamType3), ParamType1 param1, ParamType2 param2, ParamType3 param3, const char *format,...)
 180 {
 181     ASYNC_PQUERY_BODY(format, szQuery)
 182     return AsyncQuery(method, param1, param2, param3, szQuery);
 183 }
 184
 185 // -- QueryHolder --
 186
 187 template<class Class>
 188 bool
 189 Database::DelayQueryHolder(Class *object, void (Class::*method)(QueryResult*, SqlQueryHolder*), SqlQueryHolder *holder)
 190 {
 191     ASYNC_DELAYHOLDER_BODY(holder, itr)
 192     return holder->Execute(new MaNGOS::QueryCallback<Class, SqlQueryHolder*>(object, method, (QueryResult*)NULL, holder), m_threadBody, itr->second);
 193 }
 194
 195 template<class Class, typename ParamType1>
 196 bool
 197 Database::DelayQueryHolder(Class *object, void (Class::*method)(QueryResult*, SqlQueryHolder*, ParamType1), SqlQueryHolder *holder, ParamType1 param1)
 198 {
 199     ASYNC_DELAYHOLDER_BODY(holder, itr)
 200     return holder->Execute(new MaNGOS::QueryCallback<Class, SqlQueryHolder*, ParamType1>(object, method, (QueryResult*)NULL, holder, param1), m_threadBody, itr->second);
 201 }
 202
 203 #undef ASYNC_QUERY_BODY
 204 #undef ASYNC_PQUERY_BODY
 205 #undef ASYNC_DELAYHOLDER_BODY