Field builder. More...
#include <fieldsBuilder.hpp>
Public Member Functions | |
virtual | ~FieldsBuilder () |
FieldsBuilder & | field (const std::string &column) |
FieldsBuilder & | as (const std::string &alias) |
FieldsBuilder & | asc () |
FieldsBuilder & | desc () |
FromBuilder | from (const std::string &table) |
![]() | |
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 | |
![]() | |
SelectBuilderPart ()=delete | |
SelectBuilderPart (anch::sql::SelectBuilder &select) | |
virtual | ~SelectBuilderPart () |
![]() | |
anch::sql::SelectBuilder & | _select |
Field builder.
This class will be used to append selected 'columns' in SELECT
queries and in ORDER BY
and GROUP BY
command.
|
virtual |
FieldsBuilder destructor
FieldsBuilder & anch::sql::FieldsBuilder::as | ( | const std::string & | alias | ) |
Add AS
alias on field
alias | the alias |
this
FieldsBuilder & anch::sql::FieldsBuilder::asc | ( | ) |
Add ASC
order by direction.
this
FieldsBuilder & anch::sql::FieldsBuilder::desc | ( | ) |
Add DESC
order by direction.
this
FieldsBuilder & anch::sql::FieldsBuilder::field | ( | const std::string & | column | ) |
Add new field
column | the column |
this
FromBuilder anch::sql::FieldsBuilder::from | ( | const std::string & | table | ) |
Switch to 'from' builder
table | the table where columns are selected from |