fromBuilder.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 "sql/builder/selectBuilderPart.hpp"
 
 
namespace anch {
  namespace sql {
 
    class SelectBuilder;
    class SQLQuery;
    class ClausesBuilder;

    class FromBuilder: public anch::sql::SelectBuilderPart {
 
      // Constructors +
    public:
      FromBuilder() = delete;

      FromBuilder(anch::sql::SelectBuilder& select, const std::string& table);

      FromBuilder(anch::sql::SelectBuilder& select, const anch::sql::SelectBuilder& subquery);

      FromBuilder(anch::sql::SelectBuilder& select, const anch::sql::SQLQuery& subquery);

      FromBuilder(anch::sql::SelectBuilder& select, const anch::sql::SelectBuilder& subquery, const std::string& alias);

      FromBuilder(anch::sql::SelectBuilder& select, const anch::sql::SQLQuery& subquery, const std::string& alias);
      // Constructors -
 
      // Destructor +
    public:
      virtual ~FromBuilder();
      // Destructor -
 
      // SQL commands +
    public:
      FromBuilder& selfJoin(const std::string& table);

      FromBuilder& selfJoin(const anch::sql::SQLQuery& subquery, const std::string& alias);

      FromBuilder& selfJoin(const anch::sql::SelectBuilder& subquery, const std::string& alias);

      FromBuilder& innerJoin(const std::string& table, const anch::sql::ClausesBuilder& clauses);

      FromBuilder& innerJoin(const anch::sql::SQLQuery& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      FromBuilder& innerJoin(const anch::sql::SelectBuilder& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      inline FromBuilder& join(const std::string& table, const anch::sql::ClausesBuilder& clauses);

      inline FromBuilder& join(const anch::sql::SQLQuery& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      inline FromBuilder& join(const anch::sql::SelectBuilder& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      FromBuilder& leftOuterJoin(const std::string& table, const anch::sql::ClausesBuilder& clauses);

      FromBuilder& leftOuterJoin(const anch::sql::SQLQuery& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      FromBuilder& leftOuterJoin(const anch::sql::SelectBuilder& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      inline FromBuilder& leftJoin(const std::string& table, const anch::sql::ClausesBuilder& clauses);

      inline FromBuilder& leftJoin(const anch::sql::SQLQuery& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      inline FromBuilder& leftJoin(const anch::sql::SelectBuilder& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      FromBuilder& rightOuterJoin(const std::string& table, const anch::sql::ClausesBuilder& clauses);

      FromBuilder& rightOuterJoin(const anch::sql::SQLQuery& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      FromBuilder& rightOuterJoin(const anch::sql::SelectBuilder& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      inline FromBuilder& rightJoin(const std::string& table, const anch::sql::ClausesBuilder& clauses);

      inline FromBuilder& rightJoin(const anch::sql::SQLQuery& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      inline FromBuilder& rightJoin(const anch::sql::SelectBuilder& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      FromBuilder& fullOuterJoin(const std::string& table, const anch::sql::ClausesBuilder& clauses);

      FromBuilder& fullOuterJoin(const anch::sql::SQLQuery& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      FromBuilder& fullOuterJoin(const anch::sql::SelectBuilder& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      inline FromBuilder& fullJoin(const std::string& table, const anch::sql::ClausesBuilder& clauses);

      inline FromBuilder& fullJoin(const anch::sql::SQLQuery& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      inline FromBuilder& fullJoin(const anch::sql::SelectBuilder& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      FromBuilder& naturalJoin(const std::string& table);

      FromBuilder& naturalJoin(const anch::sql::SQLQuery& subquery, const std::string& alias);

      FromBuilder& naturalJoin(const anch::sql::SelectBuilder& subquery, const std::string& alias);

      FromBuilder& crossJoin(const std::string& table);

      FromBuilder& crossJoin(const anch::sql::SQLQuery& subquery, const std::string& alias);

      FromBuilder& crossJoin(const anch::sql::SelectBuilder& subquery, const std::string& alias);

      anch::sql::SelectBuilder& where(const anch::sql::ClausesBuilder& clauses);
      // SQL commands -
 
      // Methods +
    private:
      void addJoin(const std::string& join, const anch::sql::SelectBuilder& subquery, const std::string& alias);

      void addJoin(const std::string& join, const anch::sql::SQLQuery& subquery, const std::string& alias);

      void addJoin(const std::string& join, const std::string& table, const anch::sql::ClausesBuilder& clauses);

      void addJoin(const std::string& join, const anch::sql::SelectBuilder& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);

      void addJoin(const std::string& join, const anch::sql::SQLQuery& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses);
      // Methods -
 
    };
 
 
    FromBuilder&
    FromBuilder::join(const std::string& table, const anch::sql::ClausesBuilder& clauses) {
      return innerJoin(table, clauses);
    }
 
    FromBuilder&
    FromBuilder::join(const anch::sql::SQLQuery& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses) {
      return innerJoin(subquery, alias, clauses);
    }
 
    FromBuilder&
    FromBuilder::join(const anch::sql::SelectBuilder& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses) {
      return innerJoin(subquery, alias, clauses);
    }
 
    FromBuilder&
    FromBuilder::leftJoin(const std::string& table, const anch::sql::ClausesBuilder& clauses) {
      return leftOuterJoin(table, clauses);
    }
 
    FromBuilder&
    FromBuilder::leftJoin(const anch::sql::SQLQuery& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses) {
      return leftOuterJoin(subquery, alias, clauses);
    }
 
    FromBuilder&
    FromBuilder::leftJoin(const anch::sql::SelectBuilder& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses) {
      return leftOuterJoin(subquery, alias, clauses);
    }
 
    FromBuilder&
    FromBuilder::rightJoin(const std::string& table, const anch::sql::ClausesBuilder& clauses) {
      return rightOuterJoin(table, clauses);
    }
 
    FromBuilder&
    FromBuilder::rightJoin(const anch::sql::SQLQuery& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses) {
      return rightOuterJoin(subquery, alias, clauses);
    }
 
    FromBuilder&
    FromBuilder::rightJoin(const anch::sql::SelectBuilder& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses) {
      return rightOuterJoin(subquery, alias, clauses);
    }
 
    FromBuilder&
    FromBuilder::fullJoin(const std::string& table, const anch::sql::ClausesBuilder& clauses) {
      return fullOuterJoin(table, clauses);
    }
 
    FromBuilder&
    FromBuilder::fullJoin(const anch::sql::SQLQuery& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses) {
      return fullOuterJoin(subquery, alias, clauses);
    }
 
    FromBuilder&
    FromBuilder::fullJoin(const anch::sql::SelectBuilder& subquery, const std::string& alias, const anch::sql::ClausesBuilder& clauses) {
      return fullOuterJoin(subquery, alias, clauses);
    }
 
  }  // sql
}  // anch