aboutsummaryrefslogtreecommitdiff
path: root/src/server/shared/Database/QueryResult.h
diff options
context:
space:
mode:
Diffstat (limited to 'src/server/shared/Database/QueryResult.h')
-rw-r--r--src/server/shared/Database/QueryResult.h102
1 files changed, 102 insertions, 0 deletions
diff --git a/src/server/shared/Database/QueryResult.h b/src/server/shared/Database/QueryResult.h
new file mode 100644
index 00000000000..4eec9915362
--- /dev/null
+++ b/src/server/shared/Database/QueryResult.h
@@ -0,0 +1,102 @@
+/*
+ * Copyright (C) 2005-2009 MaNGOS <http://getmangos.com/>
+ *
+ * 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
+ */
+
+#if !defined(QUERYRESULT_H)
+#define QUERYRESULT_H
+
+#include <ace/Refcounted_Auto_Ptr.h>
+#include <ace/Null_Mutex.h>
+
+#include "Field.h"
+
+#ifdef WIN32
+#define FD_SETSIZE 1024
+#include <winsock2.h>
+#include <mysql/mysql.h>
+#else
+#include <mysql.h>
+#endif
+
+class QueryResult
+{
+ public:
+ QueryResult(MYSQL_RES *result, MYSQL_FIELD *fields, uint64 rowCount, uint32 fieldCount);
+ ~QueryResult();
+
+ bool NextRow();
+
+ Field *Fetch() const { return mCurrentRow; }
+
+ const Field & operator [] (int index) const { return mCurrentRow[index]; }
+
+ uint32 GetFieldCount() const { return mFieldCount; }
+ uint64 GetRowCount() const { return mRowCount; }
+
+ protected:
+ Field *mCurrentRow;
+ uint32 mFieldCount;
+ uint64 mRowCount;
+
+ private:
+ enum Field::DataTypes ConvertNativeType(enum_field_types mysqlType) const;
+ void EndQuery();
+ MYSQL_RES *mResult;
+
+};
+
+typedef ACE_Refcounted_Auto_Ptr<QueryResult, ACE_Null_Mutex> QueryResult_AutoPtr;
+
+typedef std::vector<std::string> QueryFieldNames;
+
+class QueryNamedResult
+{
+ public:
+ explicit QueryNamedResult(QueryResult* query, QueryFieldNames const& names) : mQuery(query), mFieldNames(names) {}
+ ~QueryNamedResult() { delete mQuery; }
+
+ // compatible interface with QueryResult
+ bool NextRow() { return mQuery->NextRow(); }
+ Field *Fetch() const { return mQuery->Fetch(); }
+ uint32 GetFieldCount() const { return mQuery->GetFieldCount(); }
+ uint64 GetRowCount() const { return mQuery->GetRowCount(); }
+ Field const& operator[] (int index) const { return (*mQuery)[index]; }
+
+ // named access
+ Field const& operator[] (const std::string &name) const { return mQuery->Fetch()[GetField_idx(name)]; }
+ QueryFieldNames const& GetFieldNames() const { return mFieldNames; }
+
+ uint32 GetField_idx(const std::string &name) const
+ {
+ for (size_t idx = 0; idx < mFieldNames.size(); ++idx)
+ {
+ if(mFieldNames[idx] == name)
+ return idx;
+ }
+ ASSERT(false && "unknown field name");
+ return uint32(-1);
+ }
+
+ protected:
+ QueryResult *mQuery;
+ QueryFieldNames mFieldNames;
+};
+
+#endif
+