/* * This file is part of the AzerothCore Project. See AUTHORS file for Copyright information * * This program is free software; you can redistribute it and/or modify it * under the terms of the GNU Affero General Public License as published by the * Free Software Foundation; either version 3 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 Affero 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 "PreparedStatement.h" #include "Errors.h" #include "Log.h" #include "MySQLConnection.h" #include "MySQLPreparedStatement.h" #include "MySQLWorkaround.h" #include "QueryResult.h" PreparedStatementBase::PreparedStatementBase(uint32 index, uint8 capacity) : m_index(index), statement_data(capacity) { } PreparedStatementBase::~PreparedStatementBase() { } //- Bind to buffer void PreparedStatementBase::setBool(const uint8 index, const bool value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setUInt8(const uint8 index, const uint8 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setUInt16(const uint8 index, const uint16 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setUInt32(const uint8 index, const uint32 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setUInt64(const uint8 index, const uint64 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setInt8(const uint8 index, const int8 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setInt16(const uint8 index, const int16 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setInt32(const uint8 index, const int32 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setInt64(const uint8 index, const int64 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setFloat(const uint8 index, const float value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setDouble(const uint8 index, const double value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setString(const uint8 index, const std::string& value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setStringView(const uint8 index, const std::string_view value) { ASSERT(index < statement_data.size()); statement_data[index].data.emplace(value); } void PreparedStatementBase::setBinary(const uint8 index, const std::vector& value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setNull(const uint8 index) { ASSERT(index < statement_data.size()); statement_data[index].data = nullptr; } //- Execution PreparedStatementTask::PreparedStatementTask(PreparedStatementBase* stmt, bool async) : m_stmt(stmt), m_result(nullptr) { m_has_result = async; // If it's async, then there's a result if (async) m_result = new PreparedQueryResultPromise(); } PreparedStatementTask::~PreparedStatementTask() { delete m_stmt; if (m_has_result && m_result != nullptr) delete m_result; } bool PreparedStatementTask::Execute() { if (m_has_result) { PreparedResultSet* result = m_conn->Query(m_stmt); if (!result || !result->GetRowCount()) { delete result; m_result->set_value(PreparedQueryResult(nullptr)); return false; } m_result->set_value(PreparedQueryResult(result)); return true; } return m_conn->Execute(m_stmt); } template std::string PreparedStatementData::ToString(T value) { return fmt::format("{}", value); } std::string PreparedStatementData::ToString(bool value) { return ToString(value); } std::string PreparedStatementData::ToString(uint8 value) { return ToString(value); } template std::string PreparedStatementData::ToString(uint16); template std::string PreparedStatementData::ToString(uint32); template std::string PreparedStatementData::ToString(uint64); std::string PreparedStatementData::ToString(int8 value) { return ToString(value); } template std::string PreparedStatementData::ToString(int16); template std::string PreparedStatementData::ToString(int32); template std::string PreparedStatementData::ToString(int64); template std::string PreparedStatementData::ToString(float); template std::string PreparedStatementData::ToString(double); std::string PreparedStatementData::ToString(std::string const& value) { return fmt::format("'{}'", value); } std::string PreparedStatementData::ToString(std::vector const& /*value*/) { return "BINARY"; } std::string PreparedStatementData::ToString(std::nullptr_t) { return "NULL"; }