From 1f66d719f2cbbcb144b5080c89dd73fcae261798 Mon Sep 17 00:00:00 2001
From: StormBytePP <stormbyte@gmail.com>
Date: Sat, 15 Aug 2015 02:19:10 +0200
Subject: Core/BuildSystem: Merge collision, debugging, threading, utilities
 and configuration into "common" which does not depend on shared anymore and
 moved database out of shared library These changes enables to build tools
 only without even having MySQL installed

---
 src/server/database/Database/Transaction.cpp | 87 ++++++++++++++++++++++++++++
 1 file changed, 87 insertions(+)
 create mode 100644 src/server/database/Database/Transaction.cpp

(limited to 'src/server/database/Database/Transaction.cpp')

diff --git a/src/server/database/Database/Transaction.cpp b/src/server/database/Database/Transaction.cpp
new file mode 100644
index 00000000000..f657411f716
--- /dev/null
+++ b/src/server/database/Database/Transaction.cpp
@@ -0,0 +1,87 @@
+/*
+ * Copyright (C) 2008-2015 TrinityCore <http://www.trinitycore.org/>
+ *
+ * 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 <http://www.gnu.org/licenses/>.
+ */
+
+#include "DatabaseEnv.h"
+#include "Transaction.h"
+#include <mysqld_error.h>
+
+std::mutex TransactionTask::_deadlockLock;
+
+//- 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);
+}
+
+//- 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()
+{
+    int errorCode = m_conn->ExecuteTransaction(m_trans);
+    if (!errorCode)
+        return true;
+
+    if (errorCode == ER_LOCK_DEADLOCK)
+    {
+        // Make sure only 1 async thread retries a transaction so they don't keep dead-locking each other
+        std::lock_guard<std::mutex> lock(_deadlockLock);
+        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