selectBuilder.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 <sstream>
#include <list>
#include <ostream>
#include <string>
 
#include "sql/builder/fieldsBuilder.hpp"
#include "sql/builder/clausesBuilder.hpp"
#include "sql/builder/sqlQuery.hpp"
 
 
namespace anch {
  namespace sql {
 
    extern SelectBuilder select();
    class FromBuilder;

    class SelectBuilder {
      friend SelectBuilder anch::sql::select();
      friend anch::sql::FieldsBuilder;
      friend anch::sql::FromBuilder;

      friend std::ostream& operator<<(std::ostream& stream, const SelectBuilder& builder);
 
      // Attributes +
    private:
      std::ostringstream _buffer;

      std::list<std::string> _values;
      // Attributes -
 
      // Constructors +
    private:
      SelectBuilder();
      // Constructors -
 
      // Destructor +
    public:
      virtual ~SelectBuilder();
      // Destructor -
 
      // SQL commands +
    public:
      SelectBuilder& distinct();

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

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

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

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

      SelectBuilder& unionOnce(SelectBuilder& other);

      SelectBuilder& unionAll(SelectBuilder& other);

      SelectBuilder& offset(int64_t offset);

      SelectBuilder& fetch(uint64_t limit);

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

      SelectBuilder& windowByRank(const std::string& alias, const std::string& rowColumn, const std::string& order, uint32_t min, uint32_t max);
      // SQL commands -
 
      // Methods +
      anch::sql::SQLQuery build();
 
    private:
      void window(const std::string& function, const std::string& alias, const std::string& rowColumn, const std::string& order, uint32_t min, uint32_t max);
      // Methods -
 
    };
 
  } // sql
} // anch