/* * This file is part of the TrinityCore 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 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 . */ #include "PreparedStatement.h" #include "Errors.h" #include "MySQLConnection.h" #include "QueryResult.h" #include "StringFormat.h" #include PreparedStatementBase::PreparedStatementBase(uint32 index, uint8 capacity) : m_index(index), statement_data(capacity) { } PreparedStatementBase::~PreparedStatementBase() { } //- Bind to buffer void PreparedStatementBase::setBool(uint8 index, bool value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setUInt8(uint8 index, uint8 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setUInt16(uint8 index, uint16 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setUInt32(uint8 index, uint32 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setUInt64(uint8 index, uint64 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setInt8(uint8 index, int8 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setInt16(uint8 index, int16 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setInt32(uint8 index, int32 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setInt64(uint8 index, int64 value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setFloat(uint8 index, float value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setDouble(uint8 index, double value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setDate(uint8 index, SystemTimePoint value) { ASSERT(index < statement_data.size()); statement_data[index].data = value; } void PreparedStatementBase::setString(uint8 index, std::string&& value) { ASSERT(index < statement_data.size()); statement_data[index].data = std::move(value); } void PreparedStatementBase::setString(uint8 index, std::string_view value) { ASSERT(index < statement_data.size()); statement_data[index].data.emplace(value); } void PreparedStatementBase::setBinary(uint8 index, std::vector&& value) { ASSERT(index < statement_data.size()); statement_data[index].data = std::move(value); } void PreparedStatementBase::setBinary(uint8 index, std::span value) { ASSERT(index < statement_data.size()); statement_data[index].data.emplace>(value.begin(), value.end()); } void PreparedStatementBase::setNull(uint8 index) { ASSERT(index < statement_data.size()); statement_data[index].data = nullptr; } //- Execution PreparedQueryResult PreparedStatementTask::Query(MySQLConnection* conn, PreparedStatementBase* stmt) { PreparedResultSet* result = conn->Query(stmt); if (!result || !result->GetRowCount()) { delete result; result = nullptr; } return PreparedQueryResult(result); } bool PreparedStatementTask::Execute(MySQLConnection* conn, PreparedStatementBase* stmt) { return conn->Execute(stmt); } template std::string PreparedStatementData::ToString(T value) { return Trinity::StringFormat("{}", 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 Trinity::StringFormat("'{}'", value); } std::string PreparedStatementData::ToString(std::vector 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"; }