Core/DBLayer:

- Add basic prepared statement interface (without implementation and thus without testing, without resultset support).
- Based on raczman/Albator´s work on TrinityCore3

Build:
- Add sLog define ¨hack¨ in DatbaseWorkerPool.h to fix some more sLog errors temporarily

FYI: Builds on windows

--HG--
branch : trunk

1 files changed, 147 insertions, 0 deletions

diff --git a/src/server/shared/Database/PreparedStatement.h b/src/server/shared/Database/PreparedStatement.h
new file mode 100644
index 00000000000..580f4ee14a0
--- /dev/null
+++ b/src/server/shared/Database/PreparedStatement.h
@@ -0,0 +1,147 @@
+/*
+ * Copyright (C) 2008-2010 Trinity <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, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+ */
+
+#ifndef _PREPAREDSTATEMENT_H
+#define _PREPAREDSTATEMENT_H
+
+#include "SQLOperation.h"
+
+//- Union for data buffer (upper-level bind -> queue -> lower-level bind)
+union PreparedStatementDataUnion
+{
+    bool boolean;
+    uint8 ui8;
+    int8 i8;
+    uint16 ui16;
+    int16 i16;
+    uint32 ui32;
+    int32 i32;
+    uint64 ui64;
+    int64 i64;
+    double f;   // TODO: Maybe split it up in double and float types
+};
+
+//- This enum helps us differ data held in above union
+enum PreparedStatementValueType
+{
+    TYPE_BOOL,
+    TYPE_UI8,
+    TYPE_UI16,
+    TYPE_UI32,
+    TYPE_UI64,
+    TYPE_I8,
+    TYPE_I16,
+    TYPE_I32,
+    TYPE_I64,
+    TYPE_FLOAT,
+    TYPE_STRING
+};
+
+struct PreparedStatementData
+{
+    PreparedStatementDataUnion data;
+    PreparedStatementValueType type;
+    std::string str;
+};
+
+//- Upper-level class that is used in code
+class PreparedStatement
+{
+    friend class PreparedStatementTask;
+    friend class MySQLPreparedStatement;
+    friend class MySQLConnection;
+
+    public:
+        explicit PreparedStatement(uint32 index);
+        ~PreparedStatement();
+
+        void setBool(const uint8 index,const bool value);
+        void setUInt8(const uint8 index, const uint8 value);
+        void setUInt16(const uint8 index, const uint16 value);
+        void setUInt32(const uint8 index, const uint32 value);
+        void setUInt64(const uint8 index, const uint64 value);
+        void setInt8(const uint8 index, const int8 value);
+        void setInt16(const uint8 index, const int16 value);
+        void setInt32(const uint8 index, const int32 value);
+        void setInt64(const uint8 index, const int64 value);
+        void setDouble(const uint8 index, const double value);
+        void setString(const uint8 index, const std::string& value);
+
+    protected:
+        void BindParameters();
+
+    protected:
+        MySQLPreparedStatement* m_stmt;
+        uint32 m_index;
+        std::vector<PreparedStatementData> statement_data;    //- Buffer of parameters, not tied to MySQL in any way yet
+};
+
+//- Class of which the instances are unique per MySQLConnection
+//- access to these class objects is only done when a prepared statement task
+//- is executed.
+class MySQLPreparedStatement
+{
+    friend class MySQLConnection;
+    friend class PreparedStatement;
+
+    public:
+        MySQLPreparedStatement(MYSQL_STMT* stmt);
+        ~MySQLPreparedStatement();
+
+        void setBool(const uint8 index,const bool value);
+        void setUInt8(const uint8 index, const uint8 value);
+        void setUInt16(const uint8 index, const uint16 value);
+        void setUInt32(const uint8 index, const uint32 value);
+        void setUInt64(const uint8 index, const uint64 value);
+        void setInt8(const uint8 index, const int8 value);
+        void setInt16(const uint8 index, const int16 value);
+        void setInt32(const uint8 index, const int32 value);
+        void setInt64(const uint8 index, const int64 value);
+        void setDouble(const uint8 index, const double value);
+        void setString(const uint8 index, const char* value);
+    
+    protected:
+        MYSQL_STMT* GetSTMT() { return m_Mstmt; }
+        MYSQL_BIND* GetBind() { return m_bind; }
+        PreparedStatement* m_stmt;
+        void ClearParameters();
+        bool CheckValidIndex(uint8 index);
+
+    private:
+        void setValue(MYSQL_BIND* param, enum_field_types type, const void* value, uint32 len, bool isUnsigned);
+
+    private:
+        MYSQL_STMT* m_Mstmt;
+        uint32 m_paramCount;
+        std::vector<bool> m_paramsSet;
+        MYSQL_BIND* m_bind;
+};
+
+//- Lower-level class, enqueuable operation
+class PreparedStatementTask : public SQLOperation
+{
+    public:
+        PreparedStatementTask(PreparedStatement* stmt);
+        ~PreparedStatementTask();
+
+        bool Execute();
+
+    protected:
+        PreparedStatement* m_stmt;
+};
+#endif
\ No newline at end of file