Core/DBLayer: Support retrieving DATE/DATETIME/TIMESTAMP column values directly without casting in sql

(cherry picked from commit 404bb5b3c21b445ae21fbbfcfd7f51d255e07c39)

1 files changed, 27 insertions, 15 deletions

diff --git a/src/server/database/Database/PreparedStatement.cpp b/src/server/database/Database/PreparedStatement.cpp
index 7f3dc0bba5e..56b3a67f96a 100644
--- a/src/server/database/Database/PreparedStatement.cpp
+++ b/src/server/database/Database/PreparedStatement.cpp
@@ -22,6 +22,7 @@
 #include "QueryResult.h"
 #include "Log.h"
 #include "MySQLWorkaround.h"
+#include <fmt/chrono.h>
 
 PreparedStatementBase::PreparedStatementBase(uint32 index, uint8 capacity) :
 m_index(index), statement_data(capacity) { }
@@ -29,91 +30,97 @@ m_index(index), statement_data(capacity) { }
 PreparedStatementBase::~PreparedStatementBase() { }
 
 //- Bind to buffer
-void PreparedStatementBase::setBool(const uint8 index, const bool value)
+void PreparedStatementBase::setBool(uint8 index, bool value)
 {
     ASSERT(index < statement_data.size());
     statement_data[index].data = value;
 }
 
-void PreparedStatementBase::setUInt8(const uint8 index, const uint8 value)
+void PreparedStatementBase::setUInt8(uint8 index, uint8 value)
 {
     ASSERT(index < statement_data.size());
     statement_data[index].data = value;
 }
 
-void PreparedStatementBase::setUInt16(const uint8 index, const uint16 value)
+void PreparedStatementBase::setUInt16(uint8 index, uint16 value)
 {
     ASSERT(index < statement_data.size());
     statement_data[index].data = value;
 }
 
-void PreparedStatementBase::setUInt32(const uint8 index, const uint32 value)
+void PreparedStatementBase::setUInt32(uint8 index, uint32 value)
 {
     ASSERT(index < statement_data.size());
     statement_data[index].data = value;
 }
 
-void PreparedStatementBase::setUInt64(const uint8 index, const uint64 value)
+void PreparedStatementBase::setUInt64(uint8 index, uint64 value)
 {
     ASSERT(index < statement_data.size());
     statement_data[index].data = value;
 }
 
-void PreparedStatementBase::setInt8(const uint8 index, const int8 value)
+void PreparedStatementBase::setInt8(uint8 index, int8 value)
 {
     ASSERT(index < statement_data.size());
     statement_data[index].data = value;
 }
 
-void PreparedStatementBase::setInt16(const uint8 index, const int16 value)
+void PreparedStatementBase::setInt16(uint8 index, int16 value)
 {
     ASSERT(index < statement_data.size());
     statement_data[index].data = value;
 }
 
-void PreparedStatementBase::setInt32(const uint8 index, const int32 value)
+void PreparedStatementBase::setInt32(uint8 index, int32 value)
 {
     ASSERT(index < statement_data.size());
     statement_data[index].data = value;
 }
 
-void PreparedStatementBase::setInt64(const uint8 index, const int64 value)
+void PreparedStatementBase::setInt64(uint8 index, int64 value)
 {
     ASSERT(index < statement_data.size());
     statement_data[index].data = value;
 }
 
-void PreparedStatementBase::setFloat(const uint8 index, const float value)
+void PreparedStatementBase::setFloat(uint8 index, float value)
 {
     ASSERT(index < statement_data.size());
     statement_data[index].data = value;
 }
 
-void PreparedStatementBase::setDouble(const uint8 index, const double value)
+void PreparedStatementBase::setDouble(uint8 index, double value)
 {
     ASSERT(index < statement_data.size());
     statement_data[index].data = value;
 }
 
-void PreparedStatementBase::setString(const uint8 index, const std::string& value)
+void PreparedStatementBase::setDate(uint8 index, SystemTimePoint value)
 {
     ASSERT(index < statement_data.size());
     statement_data[index].data = value;
 }
 
-void PreparedStatementBase::setStringView(const uint8 index, const std::string_view value)
+void PreparedStatementBase::setString(uint8 index, std::string const& value)
+{
+    ASSERT(index < statement_data.size());
+    statement_data[index].data = value;
+}
+
+void PreparedStatementBase::setStringView(uint8 index, std::string_view value)
 {
     ASSERT(index < statement_data.size());
     statement_data[index].data.emplace<std::string>(value);
 }
 
-void PreparedStatementBase::setBinary(const uint8 index, const std::vector<uint8>& value)
+void PreparedStatementBase::setBinary(uint8 index, std::vector<uint8> const& value)
 {
     ASSERT(index < statement_data.size());
     statement_data[index].data = value;
 }
 
-void PreparedStatementBase::setNull(const uint8 index)
+void PreparedStatementBase::setNull(uint8 index)
 {
     ASSERT(index < statement_data.size());
     statement_data[index].data = nullptr;
@@ -194,6 +201,11 @@ std::string PreparedStatementData::ToString(std::vector<uint8> const& /*value*/)
     return "BINARY";
 }
 
+std::string PreparedStatementData::ToString(SystemTimePoint value)
+{
+    return Trinity::StringFormat("{:%F %T}", value);
+}
+
 std::string PreparedStatementData::ToString(std::nullptr_t)
 {
     return "NULL";