anch::sql::SelectBuilder Class Reference

Dynamic SQL select request builder. More...

#include <selectBuilder.hpp>

Collaboration diagram for anch::sql::SelectBuilder:

Public Member Functions
virtual	~SelectBuilder ()
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)
anch::sql::SQLQuery	build ()

Friends
SelectBuilder	anch::sql::select ()
std::ostream &	operator<< (std::ostream &stream, const SelectBuilder &builder)

Detailed Description

Dynamic SQL select request builder.

Dynamic SQL select request builder

Author

Vincent Lachenal

Since

0.1

Constructor & Destructor Documentation

~SelectBuilder()

virtual anch::sql::SelectBuilder::~SelectBuilder ( )

virtual

SelectBuilder destructor

Member Function Documentation

build()

anch::sql::SQLQuery anch::sql::SelectBuilder::build

(

)

Build SQL query

Returns

the query and its prepared statement values

distinct()

SelectBuilder & anch::sql::SelectBuilder::distinct

(

)

Add DISTINCT command

Returns

this

fetch()

SelectBuilder & anch::sql::SelectBuilder::fetch

(

uint64_t

limit

)

Add FETCH FIRST n ROWS ONLY

Parameters

limit

the limit value

Returns

this

field()

anch::sql::FieldsBuilder anch::sql::SelectBuilder::field

(

const std::string &

column

)

Intialize a new fields builder

Returns

the fields builder

groupBy()

anch::sql::FieldsBuilder anch::sql::SelectBuilder::groupBy

(

const std::string &

column

)

Add SQL GROUP BY command

Parameters

column

the first column to group by

Returns

a new FieldsBuilder to add other columns

having()

SelectBuilder & anch::sql::SelectBuilder::having

(

anch::sql::ClausesBuilder &

clauses

)

Add SQL HAVING command and its clauses if not empty

Parameters

clauses

the clauses

Returns

this

Here is the call graph for this function:

offset()

SelectBuilder & anch::sql::SelectBuilder::offset

(

int64_t

offset

)

Add OFFSET n ROWS

Parameters

offset

the offset value

Returns

this

Here is the call graph for this function:

orderBy()

anch::sql::FieldsBuilder anch::sql::SelectBuilder::orderBy

(

const std::string &

column

)

Add SQL ORDER BY command

Parameters

column

the first column to group by

Returns

a new FieldsBuilder to add other columns

unionAll()

SelectBuilder & anch::sql::SelectBuilder::unionAll

(

SelectBuilder &

other

)

Add UNION to other SQL request

Parameters

other

the other SQL request

Returns

this

unionOnce()

SelectBuilder & anch::sql::SelectBuilder::unionOnce

(

SelectBuilder &

other

)

Add UNION to other SQL request

Parameters

other

the other SQL request

Returns

this

windowByRank()

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

Modify current query to add apply rank window function as define in SQL:2003 standard.

Parameters

alias	the current query table alias
rowColumn	the row column alias
order	the ORDER instruction
min	the minimum row number value
max	the maximum row number value

Returns

this

windowByRowNumber()

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

Modify current query to add apply row_number window function as define in SQL:2003 standard.

Parameters

alias	the current query table alias
rowColumn	the row column alias
order	the ORDER instruction
min	the minimum row number value
max	the maximum row number value

Returns

this

Friends And Related Symbol Documentation

operator<<

std::ostream & operator<< ( std::ostream & stream, const SelectBuilder & builder )

friend

SelectBuilder stream insertion operator

Parameters

stream	the output stream
builder	the SelectBuilder

Returns

the output stream

---

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

• anch-sql/inc/sql/builder/selectBuilder.hpp