From 87218eadcdeac5ba86a035edfd079958405cb24f Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Wed, 18 Aug 2010 02:25:52 +0200 Subject: * HIGHLY EXPERIMENTAL - USE AT OWN RISK * Database Layer: - Implement connection pooling: Instead of 1 delay thread per database, you can configure between 1 and 32 worker threads that have a seperate thread in the core and have a seperate connection to the MySQL server (based on raczman/Albator´s database layer for Trinitycore3) - Implement a configurable thread bundle for synchroneous requests from seperate core threads (see worldserver.conf.dist for more info) - Every mapupdate thread now has its seperate MySQL connection to the world and characters database - Drop inconsistent PExecuteLog function - query logging will be implemented CONSISTENTLY later - Drop current prepared statement interface - this will be done *properly* later - You´ll need to update your worldserver.conf and authserver.conf - You´re recommended to make a backup of your databases before using this. * HIGHLY EXPERIMENTAL - USE AT OWN RISK * * HIGHLY EXPERIMENTAL - USE AT OWN RISK * etc. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --HG-- branch : trunk --- src/server/shared/Database/SQLOperation.cpp | 212 ++++++++++++++++++++++++++++ 1 file changed, 212 insertions(+) create mode 100644 src/server/shared/Database/SQLOperation.cpp (limited to 'src/server/shared/Database/SQLOperation.cpp') diff --git a/src/server/shared/Database/SQLOperation.cpp b/src/server/shared/Database/SQLOperation.cpp new file mode 100644 index 00000000000..d3af5949faf --- /dev/null +++ b/src/server/shared/Database/SQLOperation.cpp @@ -0,0 +1,212 @@ +/* + * Copyright (C) 2008-2010 Trinity + * + * This program 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. + * + * This program 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 this program; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + */ + +#include "SQLOperation.h" +#include "MySQLConnection.h" + +/*! Basic, ad-hoc queries. */ +BasicStatementTask::BasicStatementTask(const char* sql) +{ + m_sql = strdup(sql); +} + +BasicStatementTask::~BasicStatementTask() +{ + free((void*)m_sql); +} + +bool BasicStatementTask::Execute() +{ + return m_conn->Execute(m_sql); +} + +/*! Transactions. */ +TransactionTask::TransactionTask() +{ +} + +TransactionTask::~TransactionTask() +{ + +} + +void TransactionTask::ForcefulDelete() +{ + while (!m_queries.empty()) + { + free((void*)const_cast(m_queries.front())); + m_queries.pop(); + } +} + +bool TransactionTask::Execute() +{ + if (m_queries.empty()) + return false; + + const char* sql; + + m_conn->BeginTransaction(); + while (!m_queries.empty()) + { + sql = m_queries.front(); + if (!m_conn->Execute(sql)) + { + free((void*)const_cast(sql)); + m_queries.pop(); + m_conn->RollbackTransaction(); + ForcefulDelete(); + return false; + } + + free((void*)const_cast(sql)); + m_queries.pop(); + } + + m_conn->CommitTransaction(); + return true; +} + +/*! Callback statements/holders */ +void SQLResultQueue::Update() +{ + /// execute the callbacks waiting in the synchronization queue + Trinity::IQueryCallback* callback; + while (next(callback)) + { + callback->Execute(); + delete callback; + } +} + +bool SQLQueryHolder::SetQuery(size_t index, const char *sql) +{ + if (m_queries.size() <= index) + { + sLog.outError("Query index (%u) out of range (size: %u) for query: %s", index, (uint32)m_queries.size(), sql); + return false; + } + + if (m_queries[index].first != NULL) + { + sLog.outError("Attempt assign query to holder index (%u) where other query stored (Old: [%s] New: [%s])", + index, m_queries[index].first, sql); + return false; + } + + /// not executed yet, just stored (it's not called a holder for nothing) + m_queries[index] = SQLResultPair(strdup(sql), QueryResult_AutoPtr(NULL)); + return true; +} + +bool SQLQueryHolder::SetPQuery(size_t index, const char *format, ...) +{ + if (!format) + { + sLog.outError("Query (index: %u) is empty.",index); + return false; + } + + va_list ap; + char szQuery [MAX_QUERY_LEN]; + va_start(ap, format); + int res = vsnprintf(szQuery, MAX_QUERY_LEN, format, ap); + va_end(ap); + + if (res==-1) + { + sLog.outError("SQL Query truncated (and not execute) for format: %s",format); + return false; + } + + return SetQuery(index, szQuery); +} + +QueryResult_AutoPtr SQLQueryHolder::GetResult(size_t index) +{ + if (index < m_queries.size()) + { + /// the query strings are freed on the first GetResult or in the destructor + if (m_queries[index].first != NULL) + { + free((void*)(const_cast(m_queries[index].first))); + m_queries[index].first = NULL; + } + /// when you get a result aways remember to delete it! + return m_queries[index].second; + } + else + return QueryResult_AutoPtr(NULL); +} + +void SQLQueryHolder::SetResult(size_t index, QueryResult_AutoPtr result) +{ + /// store the result in the holder + if (index < m_queries.size()) + m_queries[index].second = result; +} + +SQLQueryHolder::~SQLQueryHolder() +{ + for (size_t i = 0; i < m_queries.size(); i++) + { + /// if the result was never used, free the resources + /// results used already (getresult called) are expected to be deleted + if (m_queries[i].first != NULL) + free((void*)(const_cast(m_queries[i].first))); + } +} + +void SQLQueryHolder::SetSize(size_t size) +{ + /// to optimize push_back, reserve the number of queries about to be executed + m_queries.resize(size); +} + +bool SQLQueryHolderTask::Execute() +{ + if (!m_holder || !m_callback || !m_queue) + return false; + + /// we can do this, we are friends + std::vector &queries = m_holder->m_queries; + + for (size_t i = 0; i < queries.size(); i++) + { + /// execute all queries in the holder and pass the results + char const *sql = queries[i].first; + if (sql) + m_holder->SetResult(i, m_conn->Query(sql)); + } + + /// sync with the caller thread + m_queue->add(m_callback); + return true; +} + +bool SQLQueryTask::Execute() +{ + if (!m_callback || !m_queue) + return false; + + /// execute the query and store the result in the callback + m_callback->SetResult(m_conn->Query(m_sql)); + /// add the callback to the sql result queue of the thread it originated from + m_queue->add(m_callback); + return true; +} \ No newline at end of file -- cgit v1.2.3