preparedStatement.hpp

/*
  ANCH Framework: ANother C++ Hack is a C++ framework based on C++11 standard
  Copyright (C) 2012 Vincent Lachenal
 
  This file is part of ANCH Framework.
 
  ANCH Framework is free software: you can redistribute it and/or modify
  it under the terms of the GNU Lesser General Public License as published by
  the Free Software Foundation, either version 3 of the License, or
  (at your option) any later version.
 
  ANCH Framework 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 Lesser General Public License for more details.
 
  You should have received a copy of the GNU Lesser General Public License
  along with ANCH Framework.  If not, see <http://www.gnu.org/licenses/>.
*/
#pragma once
 
#include <set>
#include <string>
 
#include "sql/sqlException.hpp"
#include "sql/resultSet.hpp"
#include "sql/types/date.hpp"
#include "sql/types/time.hpp"
#include "sql/types/timestamp.hpp"
 
 
namespace anch::sql {

  class PreparedStatement {
 
    // Attributes +
  protected:
    std::map<std::size_t,std::string> _values;

    std::size_t _nbPlaceholders;
    // Attributes -
 
    // Constructors +
  public:
    PreparedStatement() noexcept;
    // Constructors -
 
    // Destructor +
  public:
    virtual ~PreparedStatement() noexcept;
    // Destructor -
 
    // Methods +
  public:
    virtual ResultSet* executeQuery() = 0;

    virtual uint64_t executeUpdate() = 0;

    void set(std::size_t idx, int16_t value);

    void set(std::size_t idx, uint16_t value);

    void set(std::size_t idx, int32_t value);

    void set(std::size_t idx, uint32_t value);

    void set(std::size_t idx, int64_t value);

    void set(std::size_t idx, uint64_t value);

    void set(std::size_t idx, const std::string& value);

    void set(std::size_t idx, const char* const value);

    virtual void set(std::size_t idx, const anch::sql::Date& value);

    virtual void set(std::size_t idx, const anch::sql::Time& value);

    virtual void set(std::size_t idx, const anch::sql::Timestamp& value);
 
  protected:
    std::set<std::size_t> getPlaceholders(const std::string& query) const;

    inline void checkIndex(std::size_t index) const {
      if(index > _nbPlaceholders) {
        std::ostringstream oss;
        oss << "Index " << index << " is upper than number of wildcards " << _nbPlaceholders;
        throw SqlException(oss.str(), true);
      }
    }
    // Methods -
 
  };
 
}