From e8e94a0a663be0a1cefe704d8c6860a526b2d7e9 Mon Sep 17 00:00:00 2001 From: Yehonal Date: Sun, 26 Jun 2016 10:39:44 +0200 Subject: First Commit For Azeroth! --- src/server/shared/Database/Transaction.cpp | 92 ++++++++++++++++++++++++++++++ 1 file changed, 92 insertions(+) create mode 100644 src/server/shared/Database/Transaction.cpp (limited to 'src/server/shared/Database/Transaction.cpp') diff --git a/src/server/shared/Database/Transaction.cpp b/src/server/shared/Database/Transaction.cpp new file mode 100644 index 0000000000..f28284f4d8 --- /dev/null +++ b/src/server/shared/Database/Transaction.cpp @@ -0,0 +1,92 @@ +/* + * Copyright (C) + * + * 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, see . + */ + +#include "DatabaseEnv.h" +#include "Transaction.h" + +//- Append a raw ad-hoc query to the transaction +void Transaction::Append(const char* sql) +{ + SQLElementData data; + data.type = SQL_ELEMENT_RAW; + data.element.query = strdup(sql); + m_queries.push_back(data); +} + +void Transaction::PAppend(const char* sql, ...) +{ + va_list ap; + char szQuery [MAX_QUERY_LEN]; + va_start(ap, sql); + vsnprintf(szQuery, MAX_QUERY_LEN, sql, ap); + va_end(ap); + + Append(szQuery); +} + +//- Append a prepared statement to the transaction +void Transaction::Append(PreparedStatement* stmt) +{ + SQLElementData data; + data.type = SQL_ELEMENT_PREPARED; + data.element.stmt = stmt; + m_queries.push_back(data); +} + +void Transaction::Cleanup() +{ + // This might be called by explicit calls to Cleanup or by the auto-destructor + if (_cleanedUp) + return; + + while (!m_queries.empty()) + { + SQLElementData const &data = m_queries.front(); + switch (data.type) + { + case SQL_ELEMENT_PREPARED: + delete data.element.stmt; + break; + case SQL_ELEMENT_RAW: + free((void*)(data.element.query)); + break; + } + + m_queries.pop_front(); + } + + _cleanedUp = true; +} + +bool TransactionTask::Execute() +{ + if (m_conn->ExecuteTransaction(m_trans)) + return true; + + if (m_conn->GetLastError() == 1213) + { + uint8 loopBreaker = 5; // Handle MySQL Errno 1213 without extending deadlock to the core itself + for (uint8 i = 0; i < loopBreaker; ++i) + if (m_conn->ExecuteTransaction(m_trans)) + return true; + } + + // Clean up now. + m_trans->Cleanup(); + + return false; +} -- cgit v1.2.3