A Select models a query to be used when retrieving data from a DataSource. More...
#include <Select.h>
Public Types | |
| typedef void | ReturnType |
| typedef QueryVisitor | VisitorType |
Public Member Functions | |
| virtual ReturnType | accept (VisitorType &guest) const=0 |
| It call the visit method from the guest object. | |
| Query * | clone () const |
| It creates a new copy of this query. | |
| Select & | CrossJoin (const FromItem &d2) |
| Select & | CrossJoin (FromItem *d2) |
| Distinct & | distinct () |
| const Distinct & | distinct () const |
| Select & | distinct (const Distinct &rhs) |
| Select & | distinct (const Expression &e) |
| Select & | distinct (const std::string &propertyName) |
| Select & | distinct (Distinct *d) |
| Select & | distinct (Expression *e) |
| Fields & | fields () |
| const Fields & | fields () const |
| Select & | fields (const Fields &f) |
| Select & | fields (Fields *f) |
| From & | from () |
| const From & | from () const |
| Select & | from (const From &rhs) |
| Select & | from (const FromItem &i1, const FromItem &i2) |
| Select & | from (const FromItem &i1, const FromItem &i2, const FromItem &i3) |
| Select & | from (const FromItem &item) |
| Select & | from (const std::string &datasetName) |
| Select & | from (From *f) |
| Select & | from (FromItem *i1, FromItem *i2) |
| Select & | from (FromItem *i1, FromItem *i2, FromItem *i3) |
| Select & | from (FromItem *item) |
| Select & | FullOuterJoin (const FromItem &d2, const JoinCondition &c) |
| Select & | FullOuterJoin (FromItem *d2, JoinCondition *c) |
| const Distinct * | getDistinct () const |
| It returns the Distinct modifier. | |
| const Fields * | getFields () const |
| It returns the list of output expressions used to form the result set. | |
| const From * | getFrom () const |
| It returns the list of source information to be used by the query. | |
| const GroupBy * | getGroupBy () const |
| It returns the list of expressions used to condense the result set. | |
| const Having * | getHaving () const |
| It returns the list of expressions used to eliminate group row that doesn't satisfy the condition. | |
| std::size_t | getLimit () const |
| It tells the maximum number of rows to return. | |
| std::size_t | getOffset () const |
| It tells the number of rows to skip before starting to return rows. | |
| const OrderBy * | getOrderBy () const |
| It returns the list of expressions used to sort the output result. | |
| Where * | getWhere () const |
| It returns the filter condition. | |
| GroupBy & | groupBy () |
| const GroupBy & | groupBy () const |
| Select & | groupBy (const Expression &e) |
| Select & | groupBy (const GroupBy &rhs) |
| Select & | groupBy (const GroupByItem &item) |
| Select & | groupBy (const std::string &propertyName) |
| Select & | groupBy (GroupBy *gb) |
| Select & | groupBy (GroupByItem *item) |
| Having & | having () |
| const Having & | having () const |
| Select & | having (const Expression &e) |
| Select & | having (const Having &rhs) |
| Select & | having (Expression *e) |
| Select & | having (Having *h) |
| Select & | InnerJoin (const FromItem &d2, const JoinCondition &c) |
| Select & | InnerJoin (FromItem *d2, JoinCondition *c) |
| Select & | Join (const FromItem &d2, JoinType t, const JoinCondition &c) |
| Select & | Join (FromItem *d2, JoinType t, JoinCondition *c) |
| Select & | LeftJoin (const FromItem &d2, const JoinCondition &c) |
| Select & | LeftJoin (FromItem *d2, JoinCondition *c) |
| Select & | limit (std::size_t l) |
| Select & | NaturalJoin (const FromItem &d2, JoinType t) |
| Select & | NaturalJoin (FromItem *d2, JoinType t) |
| Select & | offset (std::size_t i) |
| Select & | operator() (const Field &f) |
| Select & | operator() (const std::string &propertyName) |
| Select & | operator() (const std::string &propertyName, const std::string &alias) |
| Select & | operator() (Field *f) |
| Select & | operator+ (const te::da::From &f) |
| Select & | operator+ (const te::da::GroupBy &g) |
| Select & | operator+ (const te::da::Having &h) |
| Select & | operator+ (const te::da::OrderBy &o) |
| Select & | operator+ (const te::da::Where &w) |
| Select & | operator+ (te::da::From *f) |
| Select & | operator+ (te::da::GroupBy *g) |
| Select & | operator+ (te::da::Having *h) |
| Select & | operator+ (te::da::OrderBy *o) |
| Select & | operator+ (te::da::Where *w) |
| Select & | operator= (const Select &rhs) |
| OrderBy & | orderBy () |
| const OrderBy & | orderBy () const |
| Select & | orderBy (const Expression &e, SortOrder o=ASC) |
| Select & | orderBy (const OrderBy &rhs) |
| Select & | orderBy (const OrderByItem &item) |
| Select & | orderBy (const std::string &propertyName, SortOrder o=ASC) |
| Select & | orderBy (OrderBy *o) |
| Select & | orderBy (OrderByItem *item) |
| Select & | RightJoin (const FromItem &d2, const JoinCondition &c) |
| Select & | RightJoin (FromItem *d2, JoinCondition *c) |
| TE_DEFINE_VISITABLE | Select () |
| Default constructor. | |
| Select (const Field &f) | |
| Select (const Fields &fds) | |
| Select (const Fields &fds, const From &f) | |
| Select (const Fields &fds, const From &f, const GroupBy &gb) | |
| Select (const Fields &fds, const From &f, const GroupBy &gb, const OrderBy &o) | |
| Select (const Fields &fds, const From &f, const OrderBy &o) | |
| Select (const Fields &fds, const From &f, const Where &w) | |
| Select (const Fields &fds, const From &f, const Where &w, const GroupBy &gb) | |
| Select (const Fields &fds, const From &f, const Where &w, const GroupBy &gb, const Having &h) | |
| Select (const Fields &fds, const From &f, const Where &w, const GroupBy &gb, const Having &h, const OrderBy &o) | |
| Select (const Fields &fds, const From &f, const Where &w, const GroupBy &gb, const OrderBy &o) | |
| Select (const Fields &fds, const From &f, const Where &w, const OrderBy &o) | |
| Select (const Select &rhs) | |
| Select (const Select *rhs) | |
| Select (const std::string &propertyName) | |
| Select (const std::string &propertyName, const std::string &alias) | |
| Select (Field *f) | |
| Select (Fields *fds, From *f, GroupBy *gb, OrderBy *o=0) | |
| Select (Fields *fds, From *f, OrderBy *o) | |
| Select (Fields *fds, From *f, Where *w, GroupBy *gb, Having *h, OrderBy *o=0) | |
| Select (Fields *fds, From *f, Where *w, GroupBy *gb, OrderBy *o=0) | |
| Select (Fields *fds, From *f=0, Where *w=0, OrderBy *o=0) | |
| void | setDistinct (Distinct *d) |
| If Distinct is specified, all duplicate rows are removed from the result set (one row is kept from each group of duplicates). | |
| void | setFields (Fields *f) |
| It sets the list of output expressions used to form the result set. | |
| void | setFrom (From *f) |
| It sets the list of source information. | |
| void | setGroupBy (GroupBy *g) |
| It sets the list of expressions used to condense the result set. | |
| void | setHaving (Having *h) |
| It sets the list of expressions used to eliminate group row that doesn't satisfy the condition. | |
| void | setLimit (std::size_t m) |
| It specifies the maximum number of rows to return. | |
| void | setOffset (std::size_t o) |
| It specifies the number of rows to skip before starting to return rows. | |
| void | setOrderBy (OrderBy *o) |
| It sets the list of expressions used to sort the output result. | |
| void | setWhere (Where *w) |
| It sets the filter codition. | |
| Where & | where () |
| const Where & | where () const |
| Select & | where (const Expression &e) |
| Select & | where (const Where &rhs) |
| Select & | where (Expression *e) |
| Select & | where (Where *w) |
| ~Select () | |
| Destructor. | |
Private Attributes | |
| std::unique_ptr< Distinct > | m_distinct |
| std::unique_ptr< Fields > | m_fields |
| std::unique_ptr< From > | m_from |
| std::unique_ptr< GroupBy > | m_groupBy |
| std::unique_ptr< Having > | m_having |
| std::size_t | m_limit |
| std::size_t | m_offset |
| std::unique_ptr< OrderBy > | m_orderBy |
| std::unique_ptr< Where > | m_where |
A Select models a query to be used when retrieving data from a DataSource.
|
inherited |
Definition at line 58 of file BaseVisitable.h.
|
inherited |
Definition at line 57 of file BaseVisitable.h.
| TE_DEFINE_VISITABLE te::da::Select::Select | ( | ) |
Default constructor.
Referenced by CrossJoin(), CrossJoin(), distinct(), distinct(), distinct(), distinct(), distinct(), fields(), fields(), from(), from(), from(), from(), from(), from(), from(), from(), from(), FullOuterJoin(), FullOuterJoin(), groupBy(), groupBy(), groupBy(), groupBy(), groupBy(), groupBy(), having(), having(), having(), having(), InnerJoin(), InnerJoin(), Join(), Join(), LeftJoin(), LeftJoin(), limit(), NaturalJoin(), NaturalJoin(), offset(), operator()(), operator()(), operator()(), operator()(), operator+(), operator+(), operator+(), operator+(), operator+(), operator+(), operator+(), operator+(), operator+(), operator+(), operator=(), orderBy(), orderBy(), orderBy(), orderBy(), orderBy(), orderBy(), RightJoin(), RightJoin(), Select(), Select(), where(), where(), where(), and where().
| te::da::Select::Select | ( | const Fields & | fds | ) |
| te::da::Select::Select | ( | const Fields & | fds, |
| const From & | f, | ||
| const Where & | w, | ||
| const GroupBy & | gb, | ||
| const OrderBy & | o ) |
| te::da::Select::Select | ( | const Fields & | fds, |
| const From & | f, | ||
| const GroupBy & | gb, | ||
| const OrderBy & | o ) |
| te::da::Select::Select | ( | Fields * | fds, |
| From * | f, | ||
| Where * | w, | ||
| GroupBy * | gb, | ||
| Having * | h, | ||
| OrderBy * | o = 0 ) |
| te::da::Select::Select | ( | const Fields & | fds, |
| const From & | f, | ||
| const Where & | w, | ||
| const GroupBy & | gb, | ||
| const Having & | h ) |
| te::da::Select::Select | ( | const Fields & | fds, |
| const From & | f, | ||
| const Where & | w, | ||
| const GroupBy & | gb, | ||
| const Having & | h, | ||
| const OrderBy & | o ) |
| te::da::Select::Select | ( | Field * | f | ) |
| te::da::Select::Select | ( | const Field & | f | ) |
| te::da::Select::Select | ( | const std::string & | propertyName | ) |
| te::da::Select::Select | ( | const std::string & | propertyName, |
| const std::string & | alias ) |
| te::da::Select::~Select | ( | ) |
Destructor.
|
pure virtualinherited |
It call the visit method from the guest object.
| guest | The guest or visitor. |
|
virtual |
| Distinct & te::da::Select::distinct | ( | ) |
| const Distinct & te::da::Select::distinct | ( | ) | const |
| Select & te::da::Select::distinct | ( | const Expression & | e | ) |
References Select().
| Select & te::da::Select::distinct | ( | Expression * | e | ) |
References Select().
| Fields & te::da::Select::fields | ( | ) |
| const Fields & te::da::Select::fields | ( | ) | const |
| From & te::da::Select::from | ( | ) |
| const From & te::da::Select::from | ( | ) | const |
References Select().
| Select & te::da::Select::FullOuterJoin | ( | const FromItem & | d2, |
| const JoinCondition & | c ) |
References Select().
| Select & te::da::Select::FullOuterJoin | ( | FromItem * | d2, |
| JoinCondition * | c ) |
References Select().
| const Distinct * te::da::Select::getDistinct | ( | ) | const |
| const Fields * te::da::Select::getFields | ( | ) | const |
It returns the list of output expressions used to form the result set.
| const From * te::da::Select::getFrom | ( | ) | const |
It returns the list of source information to be used by the query.
| const GroupBy * te::da::Select::getGroupBy | ( | ) | const |
It returns the list of expressions used to condense the result set.
| const Having * te::da::Select::getHaving | ( | ) | const |
It returns the list of expressions used to eliminate group row that doesn't satisfy the condition.
| std::size_t te::da::Select::getLimit | ( | ) | const |
It tells the maximum number of rows to return.
| std::size_t te::da::Select::getOffset | ( | ) | const |
It tells the number of rows to skip before starting to return rows.
| const OrderBy * te::da::Select::getOrderBy | ( | ) | const |
It returns the list of expressions used to sort the output result.
| Where * te::da::Select::getWhere | ( | ) | const |
It returns the filter condition.
| GroupBy & te::da::Select::groupBy | ( | ) |
| const GroupBy & te::da::Select::groupBy | ( | ) | const |
| Select & te::da::Select::groupBy | ( | const Expression & | e | ) |
References Select().
| Select & te::da::Select::groupBy | ( | const GroupByItem & | item | ) |
References Select().
| Select & te::da::Select::groupBy | ( | GroupByItem * | item | ) |
References Select().
| Having & te::da::Select::having | ( | ) |
| const Having & te::da::Select::having | ( | ) | const |
| Select & te::da::Select::having | ( | const Expression & | e | ) |
References Select().
| Select & te::da::Select::having | ( | Expression * | e | ) |
References Select().
| Select & te::da::Select::InnerJoin | ( | const FromItem & | d2, |
| const JoinCondition & | c ) |
References Select().
| Select & te::da::Select::InnerJoin | ( | FromItem * | d2, |
| JoinCondition * | c ) |
References Select().
| Select & te::da::Select::Join | ( | const FromItem & | d2, |
| JoinType | t, | ||
| const JoinCondition & | c ) |
References Select().
| Select & te::da::Select::Join | ( | FromItem * | d2, |
| JoinType | t, | ||
| JoinCondition * | c ) |
References Select().
| Select & te::da::Select::LeftJoin | ( | const FromItem & | d2, |
| const JoinCondition & | c ) |
References Select().
| Select & te::da::Select::LeftJoin | ( | FromItem * | d2, |
| JoinCondition * | c ) |
References Select().
| Select & te::da::Select::operator() | ( | const std::string & | propertyName, |
| const std::string & | alias ) |
References Select().
| Select & te::da::Select::operator+ | ( | const te::da::From & | f | ) |
References Select().
| Select & te::da::Select::operator+ | ( | const te::da::GroupBy & | g | ) |
References Select().
| Select & te::da::Select::operator+ | ( | const te::da::Having & | h | ) |
References Select().
| Select & te::da::Select::operator+ | ( | const te::da::OrderBy & | o | ) |
References Select().
| Select & te::da::Select::operator+ | ( | const te::da::Where & | w | ) |
References Select().
| Select & te::da::Select::operator+ | ( | te::da::From * | f | ) |
References Select().
| Select & te::da::Select::operator+ | ( | te::da::GroupBy * | g | ) |
References Select().
| Select & te::da::Select::operator+ | ( | te::da::Having * | h | ) |
References Select().
| Select & te::da::Select::operator+ | ( | te::da::OrderBy * | o | ) |
References Select().
| Select & te::da::Select::operator+ | ( | te::da::Where * | w | ) |
References Select().
| OrderBy & te::da::Select::orderBy | ( | ) |
| const OrderBy & te::da::Select::orderBy | ( | ) | const |
| Select & te::da::Select::orderBy | ( | const Expression & | e, |
| SortOrder | o = ASC ) |
References te::da::ASC, and Select().
| Select & te::da::Select::orderBy | ( | const OrderByItem & | item | ) |
References Select().
References te::da::ASC, and Select().
| Select & te::da::Select::orderBy | ( | OrderByItem * | item | ) |
References Select().
| Select & te::da::Select::RightJoin | ( | const FromItem & | d2, |
| const JoinCondition & | c ) |
References Select().
| Select & te::da::Select::RightJoin | ( | FromItem * | d2, |
| JoinCondition * | c ) |
References Select().
| void te::da::Select::setDistinct | ( | Distinct * | d | ) |
| void te::da::Select::setFields | ( | Fields * | f | ) |
| void te::da::Select::setFrom | ( | From * | f | ) |
| void te::da::Select::setGroupBy | ( | GroupBy * | g | ) |
| void te::da::Select::setHaving | ( | Having * | h | ) |
| void te::da::Select::setLimit | ( | std::size_t | m | ) |
It specifies the maximum number of rows to return.
| m | The maximum number of rows to return. |
| void te::da::Select::setOffset | ( | std::size_t | o | ) |
It specifies the number of rows to skip before starting to return rows.
| o | The number of rows to skip before starting to return rows. |
| void te::da::Select::setOrderBy | ( | OrderBy * | o | ) |
| void te::da::Select::setWhere | ( | Where * | w | ) |
| Where & te::da::Select::where | ( | ) |
| const Where & te::da::Select::where | ( | ) | const |
| Select & te::da::Select::where | ( | const Expression & | e | ) |
References Select().
| Select & te::da::Select::where | ( | Expression * | e | ) |
References Select().
|
private |