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) |
| 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 |
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 |