selectBuilderPart.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 <string>
#include <cstdint>
 
#include "sql/builder/sqlQuery.hpp"
 
 
namespace anch {
  namespace sql {
 
    class SelectBuilder;
    class FieldsBuilder;
    class ClausesBuilder;

    class SelectBuilderPart {
 
      // Attributes +
    protected:
      anch::sql::SelectBuilder& _select;
      // Attributes -
 
      // Constructors +
    protected:
      SelectBuilderPart() = delete;

      SelectBuilderPart(anch::sql::SelectBuilder& select);
      // Constructors -
 
      // Destructor +
      virtual ~SelectBuilderPart();
      // Destructor -
 
      // SQL commands +
    public:
      anch::sql::FieldsBuilder groupBy(const std::string& column);

      anch::sql::FieldsBuilder orderBy(const std::string& column);

      anch::sql::SelectBuilder& having(anch::sql::ClausesBuilder& clauses);

      anch::sql::SelectBuilder& unionOnce(anch::sql::SelectBuilder& other);

      anch::sql::SelectBuilder& unionAll(anch::sql::SelectBuilder& other);

      anch::sql::SelectBuilder& offset(int64_t offset);

      anch::sql::SelectBuilder& fetch(uint64_t limit);

      anch::sql::SelectBuilder& windowByRowNumber(const std::string& alias, const std::string& rowColumn, const std::string& order, uint32_t min, uint32_t max);

      anch::sql::SelectBuilder& windowByRank(const std::string& alias, const std::string& rowColumn, const std::string& order, uint32_t min, uint32_t max);
      // SQL commands -
 
      // Methods +
    public:
      anch::sql::SelectBuilder& done();

      anch::sql::SQLQuery build();
      // Methods -
 
    };
 
  }  // sql
}  // anch