#include <fromBuilder.hpp>

Inheritance diagram for anch::sql::FromBuilder:

Collaboration diagram for anch::sql::FromBuilder:

Public Member Functions
	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)
virtual	~FromBuilder ()
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)
FromBuilder &	join (const std::string &table, const anch::sql::ClausesBuilder &clauses)
FromBuilder &	join (const anch::sql::SQLQuery &subquery, const std::string &alias, const anch::sql::ClausesBuilder &clauses)
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)
FromBuilder &	leftJoin (const std::string &table, const anch::sql::ClausesBuilder &clauses)
FromBuilder &	leftJoin (const anch::sql::SQLQuery &subquery, const std::string &alias, const anch::sql::ClausesBuilder &clauses)
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)
FromBuilder &	rightJoin (const std::string &table, const anch::sql::ClausesBuilder &clauses)
FromBuilder &	rightJoin (const anch::sql::SQLQuery &subquery, const std::string &alias, const anch::sql::ClausesBuilder &clauses)
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)
FromBuilder &	fullJoin (const std::string &table, const anch::sql::ClausesBuilder &clauses)
FromBuilder &	fullJoin (const anch::sql::SQLQuery &subquery, const std::string &alias, const anch::sql::ClausesBuilder &clauses)
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)
Public Member Functions inherited from anch::sql::SelectBuilderPart
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)
anch::sql::SelectBuilder &	done ()
anch::sql::SQLQuery	build ()

Additional Inherited Members
Protected Member Functions inherited from anch::sql::SelectBuilderPart
	SelectBuilderPart ()=delete
	SelectBuilderPart (anch::sql::SelectBuilder &select)
virtual	~SelectBuilderPart ()
Protected Attributes inherited from anch::sql::SelectBuilderPart
anch::sql::SelectBuilder &	_select

Detailed Description

SQL from table builder

Since: 0.1

Author: Vincent Lachenal

Constructor & Destructor Documentation

◆ FromBuilder() [1/6]

anch::sql::FromBuilder::FromBuilder ( )

delete

Prohibits FromBuilder default constructor

◆ FromBuilder() [2/6]

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

FromBuilder constructor

Parameters

select	the base SelectBuilder
table	the table

Here is the call graph for this function:

◆ FromBuilder() [3/6]

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

FromBuilder constructor

Parameters

select	the base SelectBuilder
subquery	the subquery

Here is the call graph for this function:

◆ FromBuilder() [4/6]

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

FromBuilder constructor

Parameters

select	the base SelectBuilder
subquery	the subquery

Here is the call graph for this function:

◆ FromBuilder() [5/6]

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

FromBuilder constructor

Parameters

select	the base SelectBuilder
subquery	the subquery
alias	the 'table' alias

Here is the call graph for this function:

◆ FromBuilder() [6/6]

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

FromBuilder constructor

Parameters

select	the base SelectBuilder
subquery	the subquery
alias	the 'table' alias

Here is the call graph for this function:

◆ ~FromBuilder()

virtual anch::sql::FromBuilder::~FromBuilder ( )

virtual

FromBuilder destructor

Member Function Documentation

◆ crossJoin() [1/3]

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

Add cross join on other 'table'

Parameters

subquery	the subquery to add as table
alias	the 'table' alias

Returns: this

Here is the call graph for this function:

◆ crossJoin() [2/3]

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

Add cross join on other 'table'

Parameters

subquery	the subquery to add as table
alias	the 'table' alias

Returns: this

Here is the call graph for this function:

◆ crossJoin() [3/3]

FromBuilder & anch::sql::FromBuilder::crossJoin ( const std::string & table )

Add cross join on other table

Parameters

table the table to add

Returns: this

Here is the call graph for this function:

◆ fullJoin() [1/3]

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

inline

Add full outer join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ fullJoin() [2/3]

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

inline

Add full outer join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ fullJoin() [3/3]

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

inline

Add full outer join on other table

Parameters

table	the table
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ fullOuterJoin() [1/3]

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

Add full outer join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ fullOuterJoin() [2/3]

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

Add full outer join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ fullOuterJoin() [3/3]

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

Add full outer join on other table

Parameters

table	the table
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ innerJoin() [1/3]

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

Add inner join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ innerJoin() [2/3]

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

Add inner join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ innerJoin() [3/3]

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

Add inner join on other table

Parameters

table	the table
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ join() [1/3]

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

inline

Add inner join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ join() [2/3]

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

inline

Add inner join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ join() [3/3]

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

inline

Add inner join on other table

Parameters

table	the table
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ leftJoin() [1/3]

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

inline

Add left outer join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ leftJoin() [2/3]

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

inline

Add left outer join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ leftJoin() [3/3]

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

inline

Add left outer join on other table

Parameters

table	the table
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ leftOuterJoin() [1/3]

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

Add left outer join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ leftOuterJoin() [2/3]

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

Add left outer join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ leftOuterJoin() [3/3]

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

Add left outer join on other table

Parameters

table	the table
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ naturalJoin() [1/3]

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

Add natural join on other 'table'

Parameters

subquery	the subquery to add as table
alias	the 'table' alias

Returns: this

Here is the call graph for this function:

◆ naturalJoin() [2/3]

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

Add natural join on other 'table'

Parameters

subquery	the subquery to add as table
alias	the 'table' alias

Returns: this

Here is the call graph for this function:

◆ naturalJoin() [3/3]

FromBuilder & anch::sql::FromBuilder::naturalJoin ( const std::string & table )

Add natural join on other table

Parameters

table the table to add

Returns: this

Here is the call graph for this function:

◆ rightJoin() [1/3]

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

inline

Add right outer join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ rightJoin() [2/3]

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

inline

Add right outer join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ rightJoin() [3/3]

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

inline

Add right outer join on other table

Parameters

table	the table
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ rightOuterJoin() [1/3]

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

Add right outer join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ rightOuterJoin() [2/3]

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

Add right outer join on other table

Parameters

subquery	the subquery to add as table
alias	the 'table' alias
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ rightOuterJoin() [3/3]

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

Add right outer join on other table

Parameters

table	the table
clauses	the join clauses

Returns: this

Here is the call graph for this function:

◆ selfJoin() [1/3]

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

Add table to 'from' part (old school join)

Parameters

subquery	the subquery to add as table
alias	the 'table' alias

Returns: this

Here is the call graph for this function:

◆ selfJoin() [2/3]

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

Add table to 'from' part (old school join)

Parameters

subquery	the subquery to add as table
alias	the 'table' alias

Returns: this

Here is the call graph for this function:

◆ selfJoin() [3/3]

FromBuilder & anch::sql::FromBuilder::selfJoin ( const std::string & table )

Add table to 'from' part (old school join)

Parameters

table the table to add

Returns: this

Here is the call graph for this function:

◆ where()

anch::sql::SelectBuilder & anch::sql::FromBuilder::where ( const anch::sql::ClausesBuilder & clauses )

Add 'WHERE' and clauses

Parameters

clauses the clauses to add

Returns: the SelectBuilder

Here is the call graph for this function:

The documentation for this class was generated from the following file:

anch-sql/inc/sql/builder/fromBuilder.hpp

Public Member Functions

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ FromBuilder() [1/6]

◆ FromBuilder() [2/6]

◆ FromBuilder() [3/6]

◆ FromBuilder() [4/6]

◆ FromBuilder() [5/6]

◆ FromBuilder() [6/6]

◆ ~FromBuilder()

Member Function Documentation

◆ crossJoin() [1/3]

◆ crossJoin() [2/3]

◆ crossJoin() [3/3]

◆ fullJoin() [1/3]

◆ fullJoin() [2/3]

◆ fullJoin() [3/3]

◆ fullOuterJoin() [1/3]

◆ fullOuterJoin() [2/3]

◆ fullOuterJoin() [3/3]

◆ innerJoin() [1/3]

◆ innerJoin() [2/3]

◆ innerJoin() [3/3]

◆ join() [1/3]

◆ join() [2/3]

◆ join() [3/3]

◆ leftJoin() [1/3]

◆ leftJoin() [2/3]

◆ leftJoin() [3/3]

◆ leftOuterJoin() [1/3]

◆ leftOuterJoin() [2/3]

◆ leftOuterJoin() [3/3]

◆ naturalJoin() [1/3]

◆ naturalJoin() [2/3]

◆ naturalJoin() [3/3]

◆ rightJoin() [1/3]

◆ rightJoin() [2/3]

◆ rightJoin() [3/3]

◆ rightOuterJoin() [1/3]

◆ rightOuterJoin() [2/3]

◆ rightOuterJoin() [3/3]

◆ selfJoin() [1/3]

◆ selfJoin() [2/3]

◆ selfJoin() [3/3]

◆ where()