OracleStatement.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 <occi.h>
 
#include <cstdio>
#include <list>
#include <string>
 
#include "DatabaseField.h"
#include <sptk5/FieldList.h>
#include <sptk5/db/DatabaseStatement.h>
 
namespace sptk {
 
class OracleConnection;
 
class OracleStatement
    : public DatabaseStatement<OracleConnection, oracle::occi::Statement>
{
public:
    using Connection = oracle::occi::Connection; 
    using Statement = oracle::occi::Statement;   
    using ResultSet = oracle::occi::ResultSet;   
    using MetaData = oracle::occi::MetaData;     
 
    OracleStatement(OracleConnection* connection, const std::string& sql);
 
    OracleStatement(const OracleStatement&) = delete;
 
    OracleStatement(OracleStatement&&) = default;
 
    ~OracleStatement() override;
 
    OracleStatement& operator=(const OracleStatement&) = delete;
 
    OracleStatement& operator=(OracleStatement&&) = default;
 
    void setParameterValues() override;
 
    void execute(bool inTransaction) override;
 
    void execBulk(bool inTransaction, bool lastIteration);
 
    void close() override;
 
    void fetch() override
    {
        if (m_resultSet)
        {
            state().eof = (m_resultSet->next() == ResultSet::END_OF_FETCH);
        }
    }
 
    ResultSet* resultSet()
    {
        return m_resultSet;
    }
 
    void getOutputParameters(FieldList& fields);
 
private:
    Statement* m_createClobStatement {nullptr}; 
    Statement* m_createBlobStatement {nullptr}; 
    ResultSet* m_resultSet {nullptr};           
 
    /*
     * Index of output parameters
     */
    std::vector<unsigned> m_outputParamIndex;
 
    void setClobParameter(uint32_t parameterIndex, unsigned char* data, uint32_t dataSize);
 
    void setBlobParameter(uint32_t parameterIndex, unsigned char* data, uint32_t dataSize);
 
    void getBLOBOutputParameter(unsigned int index, const SDatabaseField& field) const;
 
    void getCLOBOutputParameter(unsigned int index, const SDatabaseField& field) const;
 
    void setCLOBParameterValue(unsigned int parameterIndex, QueryParameter& parameter);
 
    void setBLOBParameterValue(unsigned int parameterIndex, QueryParameter& parameter);
 
    void setDateParameterValue(unsigned int parameterIndex, const QueryParameter& parameter);
 
    void setDateTimeParameterValue(unsigned int parameterIndex, const QueryParameter& parameter);
 
    void setInt64ParamValue(unsigned int parameterIndex, const QueryParameter& parameter);
 
    void setBooleanParamValue(unsigned int parameterIndex, const QueryParameter& parameter);
 
    void setStringParamValue(unsigned int parameterIndex, const QueryParameter& parameter);
 
    void setFloatParamValue(unsigned int parameterIndex, const QueryParameter& parameter);
 
    void setIntParamValue(unsigned int parameterIndex, const QueryParameter& parameter);
 
    void getDateOutputParameter(unsigned int index, const SDatabaseField& field) const;
 
    void getDateTimeOutputParameter(unsigned int index, const SDatabaseField& field) const;
};
 
} // namespace sptk