MySQLStatement.h

/*
╔══════════════════════════════════════════════════════════════════════════════╗
║                        SIMPLY POWERFUL TOOLKIT (SPTK)                        ║
╟──────────────────────────────────────────────────────────────────────────────╢
║  copyright            © 1999-2022 Alexey Parshin. All rights reserved.       ║
║  email                alexeyp@gmail.com                                      ║
╚══════════════════════════════════════════════════════════════════════════════╝
┌──────────────────────────────────────────────────────────────────────────────┐
│   This library is free software; you can redistribute it and/or modify it    │
│   under the terms of the GNU Library General Public License as published by  │
│   the Free Software Foundation; either version 2 of the License, or (at your │
│   option) any later version.                                                 │
│                                                                              │
│   This library 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 Library   │
│   General Public License for more details.                                   │
│                                                                              │
│   You should have received a copy of the GNU Library General Public License  │
│   along with this library; if not, write to the Free Software Foundation,    │
│   Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.               │
│                                                                              │
│   Please report all bugs and problems to alexeyp@gmail.com.                  │
└──────────────────────────────────────────────────────────────────────────────┘
*/
 
#pragma once
 
#include <mysql.h>
 
#include <cstdio>
#include <list>
#include <string>
 
#include <sptk5/db/DatabaseField.h>
#include <sptk5/db/DatabaseStatement.h>
 
namespace sptk {
 
class MySQLConnection;
 
class MySQLStatementField;
 
class MySQLStatement
    : public DatabaseStatement<MySQLConnection, MYSQL_STMT>
{
public:
    static VariantDataType mySQLTypeToVariantType(enum_field_types mysqlType);
 
    static enum_field_types variantTypeToMySQLType(VariantDataType dataType);
 
    static void dateTimeToMySQLDate(MYSQL_TIME& mysqlDate, DateTime timestamp, VariantDataType timeType);
 
    MySQLStatement(MySQLConnection* connection, String sql, bool autoPrepare);
 
    MySQLStatement(const MySQLStatement&) = delete;
 
    MySQLStatement(MySQLStatement&&) = default;
 
    MySQLStatement& operator=(const MySQLStatement&) = delete;
 
    MySQLStatement& operator=(MySQLStatement&&) = default;
 
    void enumerateParams(QueryParameterList& queryParams) override;
 
    void setParameterValues() override;
 
    void prepare(const String& sql) const;
 
    void execute(bool) override;
 
    void bindResult(FieldList& fields);
 
    void readResultRow(FieldList& fields);
 
    void close() override;
 
    void fetch() override;
 
private:
    String m_sql;                                  
    std::vector<MYSQL_BIND> m_paramBuffers;        
    std::vector<unsigned long> m_paramLengths;     
    std::vector<MYSQL_BIND> m_fieldBuffers;        
    std::shared_ptr<MYSQL_STMT> m_stmt;            
    std::shared_ptr<MYSQL_RES> m_result {nullptr}; 
    MYSQL_ROW m_row {};                            
 
    void readUnpreparedResultRow(FieldList& fields) const;
 
    void readPreparedResultRow(FieldList& fields);
 
    static void decodeMySQLTime(Field* _field, const MYSQL_TIME& mysqlTime, VariantDataType fieldType);
 
    static void decodeMySQLFloat(Field* _field, MYSQL_BIND& bind);
 
    [[noreturn]] void throwMySQLError() const
    {
        throw DatabaseException(mysql_stmt_error(statement()));
    }
 
    [[nodiscard]] bool bindVarCharField(MYSQL_BIND& bind, MySQLStatementField* field, size_t fieldIndex,
                                        uint32_t dataLength) const;
};
 
} // namespace sptk