A Select models a query to be used when retrieving data from a DataSource. More...

#include <Select.h>

Inheritance diagram for te::da::Select:

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. More...

Query *	clone () const
	It creates a new copy of this query. More...

Select &	CrossJoin (FromItem *d2)

Select &	CrossJoin (const FromItem &d2)

Select &	distinct (Expression *e)

Select &	distinct (const Expression &e)

Select &	distinct (const std::string &propertyName)

Select &	distinct (Distinct *d)

Select &	distinct (const Distinct &rhs)

Distinct &	distinct ()

const Distinct &	distinct () const

Select &	fields (const Fields &f)

Select &	fields (Fields *f)

Fields &	fields ()

const Fields &	fields () const

Select &	from (const FromItem &item)

Select &	from (FromItem *item)

Select &	from (const FromItem &i1, const FromItem &i2)

Select &	from (FromItem i1, FromItem i2)

Select &	from (const FromItem &i1, const FromItem &i2, const FromItem &i3)

Select &	from (FromItem i1, FromItem i2, FromItem *i3)

Select &	from (const std::string &datasetName)

Select &	from (From *f)

Select &	from (const From &rhs)

From &	from ()

const From &	from () const

Select &	FullOuterJoin (FromItem d2, JoinCondition c)

Select &	FullOuterJoin (const FromItem &d2, const JoinCondition &c)

const Distinct *	getDistinct () const
	It returns the Distinct modifier. More...

const Fields *	getFields () const
	It returns the list of output expressions used to form the result set. More...

const From *	getFrom () const
	It returns the list of source information to be used by the query. More...

const GroupBy *	getGroupBy () const
	It returns the list of expressions used to condense the result set. More...

const Having *	getHaving () const
	It returns the list of expressions used to eliminate group row that doesn't satisfy the condition. More...

std::size_t	getLimit () const
	It tells the maximum number of rows to return. More...

std::size_t	getOffset () const
	It tells the number of rows to skip before starting to return rows. More...

const OrderBy *	getOrderBy () const
	It returns the list of expressions used to sort the output result. More...

Where *	getWhere () const
	It returns the filter condition. More...

Select &	groupBy (const GroupByItem &item)

Select &	groupBy (GroupByItem *item)

Select &	groupBy (const Expression &e)

Select &	groupBy (const std::string &propertyName)

Select &	groupBy (GroupBy *gb)

Select &	groupBy (const GroupBy &rhs)

GroupBy &	groupBy ()

const GroupBy &	groupBy () const

Select &	having (Expression *e)

Select &	having (const Expression &e)

Select &	having (Having *h)

Select &	having (const Having &rhs)

Having &	having ()

const Having &	having () const

Select &	InnerJoin (FromItem d2, JoinCondition c)

Select &	InnerJoin (const FromItem &d2, const JoinCondition &c)

Select &	Join (FromItem d2, JoinType t, JoinCondition c)

Select &	Join (const FromItem &d2, JoinType t, const JoinCondition &c)

Select &	LeftJoin (FromItem d2, JoinCondition c)

Select &	LeftJoin (const FromItem &d2, const JoinCondition &c)

Select &	limit (std::size_t l)

Select &	NaturalJoin (FromItem *d2, JoinType t)

Select &	NaturalJoin (const FromItem &d2, JoinType t)

Select &	offset (std::size_t i)

Select &	operator() (const Field &f)

Select &	operator() (Field *f)

Select &	operator() (const std::string &propertyName)

Select &	operator() (const std::string &propertyName, const std::string &alias)

Select &	operator+ (const te::da::From &f)

Select &	operator+ (te::da::From *f)

Select &	operator+ (const te::da::Where &w)

Select &	operator+ (te::da::Where *w)

Select &	operator+ (const te::da::GroupBy &g)

Select &	operator+ (te::da::GroupBy *g)

Select &	operator+ (const te::da::Having &h)

Select &	operator+ (te::da::Having *h)

Select &	operator+ (const te::da::OrderBy &o)

Select &	operator+ (te::da::OrderBy *o)

Select &	operator= (const Select &rhs)

Select &	orderBy (const OrderByItem &item)

Select &	orderBy (OrderByItem *item)

Select &	orderBy (const Expression &e, SortOrder o=ASC)

Select &	orderBy (const std::string &propertyName, SortOrder o=ASC)

Select &	orderBy (OrderBy *o)

Select &	orderBy (const OrderBy &rhs)

OrderBy &	orderBy ()

const OrderBy &	orderBy () const

Select &	RightJoin (FromItem d2, JoinCondition c)

Select &	RightJoin (const FromItem &d2, const JoinCondition &c)

TE_DEFINE_VISITABLE	Select ()
	Default constructor. More...

	Select (Fields fds, From f=0, Where w=0, OrderBy o=0)

	Select (const Fields &fds)

	Select (const Fields &fds, const From &f)

	Select (const Fields &fds, const From &f, const Where &w)

	Select (const Fields &fds, const From &f, const Where &w, const OrderBy &o)

	Select (Fields fds, From f, OrderBy *o)

	Select (const Fields &fds, const From &f, const OrderBy &o)

	Select (Fields fds, From f, Where w, GroupBy gb, OrderBy *o=0)

	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 OrderBy &o)

	Select (Fields fds, From f, GroupBy gb, OrderBy o=0)

	Select (const Fields &fds, const From &f, const GroupBy &gb)

	Select (const Fields &fds, const From &f, const GroupBy &gb, const OrderBy &o)

	Select (Fields fds, From f, Where w, GroupBy gb, Having h, OrderBy o=0)

	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 (Field *f)

	Select (const Field &f)

	Select (const std::string &propertyName)

	Select (const std::string &propertyName, const std::string &alias)

	Select (const Select &rhs)

	Select (const Select *rhs)

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

void	setFields (Fields *f)
	It sets the list of output expressions used to form the result set. More...

void	setFrom (From *f)
	It sets the list of source information. More...

void	setGroupBy (GroupBy *g)
	It sets the list of expressions used to condense the result set. More...

void	setHaving (Having *h)
	It sets the list of expressions used to eliminate group row that doesn't satisfy the condition. More...

void	setLimit (std::size_t m)
	It specifies the maximum number of rows to return. More...

void	setOffset (std::size_t o)
	It specifies the number of rows to skip before starting to return rows. More...

void	setOrderBy (OrderBy *o)
	It sets the list of expressions used to sort the output result. More...

void	setWhere (Where *w)
	It sets the filter codition. More...

Select &	where (Expression *e)

Select &	where (const Expression &e)

Select &	where (Where *w)

Select &	where (const Where &rhs)

Where &	where ()

const Where &	where () const

	~Select ()
	Destructor. More...

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

Detailed Description

A Select models a query to be used when retrieving data from a DataSource.

See also: Query, Fields, From, Expression, GroupBy, Expression, OrderBy, Distinct

Definition at line 65 of file Select.h.

Member Typedef Documentation

typedef void te::common::BaseVisitable< QueryVisitor , void >::ReturnType

inherited

Definition at line 58 of file BaseVisitable.h.

typedef QueryVisitor te::common::BaseVisitable< QueryVisitor , void >::VisitorType

inherited

Definition at line 57 of file BaseVisitable.h.

Constructor & Destructor Documentation

te::da::Select::Select ( )

Default constructor.

Definition at line 40 of file Select.cpp.

Referenced by clone().

te::da::Select::Select	(	Fields *	fds,
		From *	f = `0`,
		Where *	w = `0`,
		OrderBy *	o = `0`
	)

Definition at line 44 of file Select.cpp.

te::da::Select::Select ( const Fields & fds )

Definition at line 56 of file Select.cpp.

References m_fields.

te::da::Select::Select	(	const Fields &	fds,
		const From &	f
	)

Definition at line 61 of file Select.cpp.

References m_fields, and m_from.

te::da::Select::Select	(	const Fields &	fds,
		const From &	f,
		const Where &	w
	)

Definition at line 67 of file Select.cpp.

References m_fields, m_from, and m_where.

te::da::Select::Select	(	const Fields &	fds,
		const From &	f,
		const Where &	w,
		const OrderBy &	o
	)

Definition at line 75 of file Select.cpp.

References m_fields, m_from, m_orderBy, and m_where.

te::da::Select::Select	(	Fields *	fds,
		From *	f,
		OrderBy *	o
	)

Definition at line 85 of file Select.cpp.

te::da::Select::Select	(	const Fields &	fds,
		const From &	f,
		const OrderBy &	o
	)

Definition at line 96 of file Select.cpp.

References m_fields, m_from, and m_orderBy.

te::da::Select::Select	(	Fields *	fds,
		From *	f,
		Where *	w,
		GroupBy *	gb,
		OrderBy *	o = `0`
	)

Definition at line 104 of file Select.cpp.

te::da::Select::Select	(	const Fields &	fds,
		const From &	f,
		const Where &	w,
		const GroupBy &	gb
	)

Definition at line 117 of file Select.cpp.

References m_fields, m_from, m_groupBy, and m_where.

te::da::Select::Select	(	const Fields &	fds,
		const From &	f,
		const Where &	w,
		const GroupBy &	gb,
		const OrderBy &	o
	)

Definition at line 127 of file Select.cpp.

References m_fields, m_from, m_groupBy, m_orderBy, and m_where.

te::da::Select::Select	(	Fields *	fds,
		From *	f,
		GroupBy *	gb,
		OrderBy *	o = `0`
	)

Definition at line 138 of file Select.cpp.

te::da::Select::Select	(	const Fields &	fds,
		const From &	f,
		const GroupBy &	gb
	)

Definition at line 151 of file Select.cpp.

References m_fields, m_from, and m_groupBy.

te::da::Select::Select	(	const Fields &	fds,
		const From &	f,
		const GroupBy &	gb,
		const OrderBy &	o
	)

Definition at line 159 of file Select.cpp.

References m_fields, m_from, m_groupBy, and m_orderBy.

te::da::Select::Select	(	Fields *	fds,
		From *	f,
		Where *	w,
		GroupBy *	gb,
		Having *	h,
		OrderBy *	o = `0`
	)

Definition at line 169 of file Select.cpp.

te::da::Select::Select	(	const Fields &	fds,
		const From &	f,
		const Where &	w,
		const GroupBy &	gb,
		const Having &	h
	)

Definition at line 183 of file Select.cpp.

References m_fields, m_from, m_groupBy, m_having, and m_where.

te::da::Select::Select	(	const Fields &	fds,
		const From &	f,
		const Where &	w,
		const GroupBy &	gb,
		const Having &	h,
		const OrderBy &	o
	)

Definition at line 194 of file Select.cpp.

References m_fields, m_from, m_groupBy, m_having, m_orderBy, and m_where.

te::da::Select::Select ( Field * f )

Definition at line 206 of file Select.cpp.

References m_fields.

te::da::Select::Select ( const Field & f )

Definition at line 212 of file Select.cpp.

References m_fields.

te::da::Select::Select ( const std::string & propertyName )

Definition at line 218 of file Select.cpp.

References m_fields.

te::da::Select::Select	(	const std::string &	propertyName,
		const std::string &	alias
	)

Definition at line 224 of file Select.cpp.

References m_fields.

te::da::Select::Select ( const Select & rhs )

Definition at line 232 of file Select.cpp.

References m_distinct, m_fields, m_from, m_groupBy, m_having, m_orderBy, and m_where.

te::da::Select::Select ( const Select * rhs )

Definition at line 244 of file Select.cpp.

References m_distinct, m_fields, m_from, m_groupBy, m_having, m_orderBy, m_where, and ~Select().

te::da::Select::~Select ( )

default

Destructor.

Referenced by Select().

Member Function Documentation

virtual ReturnType te::common::BaseVisitable< QueryVisitor , void >::accept ( VisitorType & guest ) const

pure virtualinherited

It call the visit method from the guest object.

Parameters

guest The guest or visitor.

Returns: Any valid value define by the template type R.

te::da::Query * te::da::Select::clone ( ) const

virtual

It creates a new copy of this query.

Implements te::da::Query.

Definition at line 276 of file Select.cpp.

References Select().

Referenced by te::map::QueryLayer::clone(), te::map::QueryLayerRenderer::drawLayerGeometries(), te::map::QueryLayerRenderer::drawLayerLinkedGroupingMem(), te::map::QueryLayer::getData(), te::qt::widgets::GroupingWidget::getLinkedDataAsDouble(), te::qt::widgets::GroupingWidget::getLinkedDataAsString(), and te::qt::widgets::ChartLayerWidget::getMaxValue().

te::da::Select & te::da::Select::CrossJoin ( FromItem * d2 )

Definition at line 487 of file Select.cpp.

te::da::Select & te::da::Select::CrossJoin ( const FromItem & d2 )

Definition at line 492 of file Select.cpp.

te::da::Select & te::da::Select::distinct ( Expression * e )

Definition at line 715 of file Select.cpp.

References m_distinct.

te::da::Select & te::da::Select::distinct ( const Expression & e )

Definition at line 725 of file Select.cpp.

References te::da::Expression::clone(), and m_distinct.

te::da::Select & te::da::Select::distinct ( const std::string & propertyName )

Definition at line 735 of file Select.cpp.

References m_distinct.

te::da::Select & te::da::Select::distinct ( Distinct * d )

Definition at line 745 of file Select.cpp.

References m_distinct.

te::da::Select & te::da::Select::distinct ( const Distinct & rhs )

Definition at line 751 of file Select.cpp.

References m_distinct.

te::da::Distinct & te::da::Select::distinct ( )

Definition at line 757 of file Select.cpp.

References m_distinct.

const te::da::Distinct & te::da::Select::distinct ( ) const

Definition at line 762 of file Select.cpp.

References m_distinct.

te::da::Select & te::da::Select::fields ( const Fields & f )

Definition at line 281 of file Select.cpp.

References m_fields.

te::da::Select & te::da::Select::fields ( Fields * f )

Definition at line 287 of file Select.cpp.

References m_fields.

te::da::Fields & te::da::Select::fields ( )

Definition at line 293 of file Select.cpp.

References m_fields.

const te::da::Fields & te::da::Select::fields ( ) const

Definition at line 298 of file Select.cpp.

References m_fields.

te::da::Select & te::da::Select::from ( const FromItem & item )

Definition at line 339 of file Select.cpp.

References te::da::FromItem::clone(), and m_from.

Referenced by te::gdal::Transactor::query().

te::da::Select & te::da::Select::from ( FromItem * item )

Definition at line 349 of file Select.cpp.

References m_from.

te::da::Select & te::da::Select::from	(	const FromItem &	i1,
		const FromItem &	i2
	)

Definition at line 359 of file Select.cpp.

References te::da::FromItem::clone(), and m_from.

te::da::Select & te::da::Select::from	(	FromItem *	i1,
		FromItem *	i2
	)

Definition at line 370 of file Select.cpp.

References m_from.

te::da::Select & te::da::Select::from	(	const FromItem &	i1,
		const FromItem &	i2,
		const FromItem &	i3
	)

Definition at line 381 of file Select.cpp.

References te::da::FromItem::clone(), and m_from.

te::da::Select & te::da::Select::from	(	FromItem *	i1,
		FromItem *	i2,
		FromItem *	i3
	)

Definition at line 393 of file Select.cpp.

References m_from.

te::da::Select & te::da::Select::from ( const std::string & datasetName )

Definition at line 405 of file Select.cpp.

References m_from.

te::da::Select & te::da::Select::from ( From * f )

Definition at line 415 of file Select.cpp.

References m_from.

te::da::Select & te::da::Select::from ( const From & rhs )

Definition at line 421 of file Select.cpp.

References m_from.

te::da::From & te::da::Select::from ( )

Definition at line 427 of file Select.cpp.

References m_from.

Referenced by operator+().

const te::da::From & te::da::Select::from ( ) const

Definition at line 432 of file Select.cpp.

References m_from.

te::da::Select & te::da::Select::FullOuterJoin	(	FromItem *	d2,
		JoinCondition *	c
	)

Definition at line 477 of file Select.cpp.

te::da::Select & te::da::Select::FullOuterJoin	(	const FromItem &	d2,
		const JoinCondition &	c
	)

Definition at line 482 of file Select.cpp.

const te::da::Distinct * te::da::Select::getDistinct ( ) const

It returns the Distinct modifier.

Returns: The Distinct modifier.

Definition at line 844 of file Select.cpp.

References m_distinct.

Referenced by te::serialize::xml::Save(), te::gpkg::SQLVisitor::visit(), te::ogr::SQLVisitor::visit(), and te::da::SQLVisitor::visit().

const te::da::Fields * te::da::Select::getFields ( ) const

It returns the list of output expressions used to form the result set.

Returns: The list of output expressions used to form the result set.

Definition at line 784 of file Select.cpp.

References m_fields.

Referenced by te::da::SpatialQueryProcessor::getOIDSet(), te::map::QueryLayer::getSchema(), te::serialize::xml::Save(), te::ogr::SQLVisitor::visit(), te::gpkg::SQLVisitor::visit(), and te::da::SQLVisitor::visit().

const te::da::From * te::da::Select::getFrom ( ) const

It returns the list of source information to be used by the query.

Returns: The list of source information to be used by the query.

Definition at line 794 of file Select.cpp.

References m_from.

Referenced by te::da::SpatialQueryProcessor::getDataSetName(), te::da::SpatialQueryProcessor::getOIDSet(), te::map::QueryLayer::getSchema(), te::serialize::xml::Save(), te::gpkg::SQLVisitor::visit(), te::ogr::SQLVisitor::visit(), and te::da::SQLVisitor::visit().

const te::da::GroupBy * te::da::Select::getGroupBy ( ) const

It returns the list of expressions used to condense the result set.

Returns: The list of expressions used to condense the result set.

Definition at line 814 of file Select.cpp.

References m_groupBy.

Referenced by te::serialize::xml::Save(), te::gpkg::SQLVisitor::visit(), te::ogr::SQLVisitor::visit(), and te::da::SQLVisitor::visit().

const te::da::Having * te::da::Select::getHaving ( ) const

It returns the list of expressions used to eliminate group row that doesn't satisfy the condition.

Returns: The list of expressions used to eliminate group row that doesn't satisfy the condition.

Definition at line 824 of file Select.cpp.

References m_having.

Referenced by te::serialize::xml::Save(), te::gpkg::SQLVisitor::visit(), te::ogr::SQLVisitor::visit(), and te::da::SQLVisitor::visit().

std::size_t te::da::Select::getLimit ( ) const

It tells the maximum number of rows to return.

Returns: The maximum number of rows to return.

Definition at line 854 of file Select.cpp.

References m_limit.

Referenced by te::serialize::xml::Save().

std::size_t te::da::Select::getOffset ( ) const

It tells the number of rows to skip before starting to return rows.

Returns: The number of rows to skip before starting to return rows.

Definition at line 864 of file Select.cpp.

References m_offset.

Referenced by te::serialize::xml::Save().

const te::da::OrderBy * te::da::Select::getOrderBy ( ) const

It returns the list of expressions used to sort the output result.

Returns: The list of expressions used to sort the output result.

Definition at line 834 of file Select.cpp.

References m_orderBy.

Referenced by te::serialize::xml::Save(), te::gpkg::SQLVisitor::visit(), te::ogr::SQLVisitor::visit(), and te::da::SQLVisitor::visit().

te::da::Where * te::da::Select::getWhere ( ) const

It returns the filter condition.

Returns: The filter condition.

Definition at line 804 of file Select.cpp.

References m_where.

Referenced by te::vp::GetSelectQueryFromLayer(), te::vp::IntersectionDialog::onOkPushButtonClicked(), te::serialize::xml::Save(), te::ogr::SQLVisitor::visit(), te::gpkg::SQLVisitor::visit(), te::da::SQLVisitor::visit(), te::da::AttributeRestrictionVisitor::visit(), and te::da::SpatialRestrictionVisitor::visit().

te::da::Select & te::da::Select::groupBy ( const GroupByItem & item )

Definition at line 549 of file Select.cpp.

References m_groupBy.

te::da::Select & te::da::Select::groupBy ( GroupByItem * item )

Definition at line 559 of file Select.cpp.

References m_groupBy.

te::da::Select & te::da::Select::groupBy ( const Expression & e )

Definition at line 569 of file Select.cpp.

References m_groupBy.

te::da::Select & te::da::Select::groupBy ( const std::string & propertyName )

Definition at line 579 of file Select.cpp.

References m_groupBy.

te::da::Select & te::da::Select::groupBy ( GroupBy * gb )

Definition at line 589 of file Select.cpp.

References m_groupBy.

te::da::Select & te::da::Select::groupBy ( const GroupBy & rhs )

Definition at line 595 of file Select.cpp.

References m_groupBy.

te::da::GroupBy & te::da::Select::groupBy ( )

Definition at line 601 of file Select.cpp.

References m_groupBy.

Referenced by operator+().

const te::da::GroupBy & te::da::Select::groupBy ( ) const

Definition at line 606 of file Select.cpp.

References m_groupBy.

te::da::Select & te::da::Select::having ( Expression * e )

Definition at line 611 of file Select.cpp.

References m_having.

te::da::Select & te::da::Select::having ( const Expression & e )

Definition at line 621 of file Select.cpp.

References te::da::Expression::clone(), and m_having.

te::da::Select & te::da::Select::having ( Having * h )

Definition at line 631 of file Select.cpp.

References m_having.

te::da::Select & te::da::Select::having ( const Having & rhs )

Definition at line 637 of file Select.cpp.

References m_having.

te::da::Having & te::da::Select::having ( )

Definition at line 643 of file Select.cpp.

References m_having.

Referenced by operator+().

const te::da::Having & te::da::Select::having ( ) const

Definition at line 648 of file Select.cpp.

References m_having.

te::da::Select & te::da::Select::InnerJoin	(	FromItem *	d2,
		JoinCondition *	c
	)

Definition at line 447 of file Select.cpp.

te::da::Select & te::da::Select::InnerJoin	(	const FromItem &	d2,
		const JoinCondition &	c
	)

Definition at line 452 of file Select.cpp.

te::da::Select & te::da::Select::Join	(	FromItem *	d2,
		JoinType	t,
		JoinCondition *	c
	)

Definition at line 437 of file Select.cpp.

te::da::Select & te::da::Select::Join	(	const FromItem &	d2,
		JoinType	t,
		const JoinCondition &	c
	)

Definition at line 442 of file Select.cpp.

te::da::Select & te::da::Select::LeftJoin	(	FromItem *	d2,
		JoinCondition *	c
	)

Definition at line 457 of file Select.cpp.

te::da::Select & te::da::Select::LeftJoin	(	const FromItem &	d2,
		const JoinCondition &	c
	)

Definition at line 462 of file Select.cpp.

te::da::Select & te::da::Select::limit ( std::size_t l )

Definition at line 767 of file Select.cpp.

References m_limit.

te::da::Select & te::da::Select::NaturalJoin	(	FromItem *	d2,
		JoinType	t
	)

Definition at line 497 of file Select.cpp.

te::da::Select & te::da::Select::NaturalJoin	(	const FromItem &	d2,
		JoinType	t
	)

Definition at line 502 of file Select.cpp.

te::da::Select & te::da::Select::offset ( std::size_t i )

Definition at line 773 of file Select.cpp.

References m_offset.

te::da::Select & te::da::Select::operator() ( const Field & f )

Definition at line 303 of file Select.cpp.

References m_fields.

te::da::Select & te::da::Select::operator() ( Field * f )

Definition at line 312 of file Select.cpp.

References m_fields.

te::da::Select & te::da::Select::operator() ( const std::string & propertyName )

Definition at line 321 of file Select.cpp.

References m_fields.

te::da::Select & te::da::Select::operator()	(	const std::string &	propertyName,
		const std::string &	alias
	)

Definition at line 330 of file Select.cpp.

References m_fields.

te::da::Select & te::da::Select::operator+ ( const te::da::From & f )

Definition at line 869 of file Select.cpp.

References from().

te::da::Select & te::da::Select::operator+ ( te::da::From * f )

Definition at line 875 of file Select.cpp.

References from().

te::da::Select & te::da::Select::operator+ ( const te::da::Where & w )

Definition at line 881 of file Select.cpp.

References where().

te::da::Select & te::da::Select::operator+ ( te::da::Where * w )

Definition at line 887 of file Select.cpp.

References where().

te::da::Select & te::da::Select::operator+ ( const te::da::GroupBy & g )

Definition at line 893 of file Select.cpp.

References groupBy().

te::da::Select & te::da::Select::operator+ ( te::da::GroupBy * g )

Definition at line 899 of file Select.cpp.

References groupBy().

te::da::Select & te::da::Select::operator+ ( const te::da::Having & h )

Definition at line 905 of file Select.cpp.

References having().

te::da::Select & te::da::Select::operator+ ( te::da::Having * h )

Definition at line 911 of file Select.cpp.

References having().

te::da::Select & te::da::Select::operator+ ( const te::da::OrderBy & o )

Definition at line 917 of file Select.cpp.

References orderBy().

te::da::Select & te::da::Select::operator+ ( te::da::OrderBy * o )

Definition at line 923 of file Select.cpp.

References orderBy().

te::da::Select & te::da::Select::operator= ( const Select & rhs )

Assignment operator.

Definition at line 258 of file Select.cpp.

References m_distinct, m_fields, m_from, m_groupBy, m_having, m_limit, m_offset, m_orderBy, and m_where.

te::da::Select & te::da::Select::orderBy ( const OrderByItem & item )

Definition at line 653 of file Select.cpp.

References m_orderBy.

te::da::Select & te::da::Select::orderBy ( OrderByItem * item )

Definition at line 663 of file Select.cpp.

References m_orderBy.

te::da::Select & te::da::Select::orderBy	(	const Expression &	e,
		SortOrder	o = `ASC`
	)

Definition at line 673 of file Select.cpp.

References m_orderBy.

te::da::Select & te::da::Select::orderBy	(	const std::string &	propertyName,
		SortOrder	o = `ASC`
	)

Definition at line 683 of file Select.cpp.

References m_orderBy.

te::da::Select & te::da::Select::orderBy ( OrderBy * o )

Definition at line 693 of file Select.cpp.

References m_orderBy.

te::da::Select & te::da::Select::orderBy ( const OrderBy & rhs )

Definition at line 699 of file Select.cpp.

References m_orderBy.

te::da::OrderBy & te::da::Select::orderBy ( )

Definition at line 705 of file Select.cpp.

References m_orderBy.

Referenced by operator+().

const te::da::OrderBy & te::da::Select::orderBy ( ) const

Definition at line 710 of file Select.cpp.

References m_orderBy.

te::da::Select & te::da::Select::RightJoin	(	FromItem *	d2,
		JoinCondition *	c
	)

Definition at line 467 of file Select.cpp.

te::da::Select & te::da::Select::RightJoin	(	const FromItem &	d2,
		const JoinCondition &	c
	)

Definition at line 472 of file Select.cpp.

void te::da::Select::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).

Parameters

d	The Distinct modifier.

Note: Select will take the ownership of Distinct.

Definition at line 839 of file Select.cpp.

References m_distinct.

Referenced by te::qt::widgets::RasterizationWizardPage::getDistinctClasses().

void te::da::Select::setFields ( Fields * f )

It sets the list of output expressions used to form the result set.

Parameters

f	The list of output expressions used to form the result set.

Note: Select will take the ownership of Fields.

Definition at line 779 of file Select.cpp.

References m_fields.

Referenced by DissolvePGISToOGR(), DissolvePGISToPGIS(), te::da::SpatialQueryProcessor::getOIDSet(), te::qt::widgets::WhereClauseWidget::getPropertyValues(), te::vp::GetSelectQueryFromLayer(), te::qt::plugins::tv::TimeViewerDockWidget::onSliderChanged(), te::vp::IntersectionQuery::run(), and te::qt::plugins::tv::TimeViewerDockWidget::setupLayerInt().

void te::da::Select::setFrom ( From * f )

It sets the list of source information.

Parameters

f	The list of source information.

Note: Select will take the ownership of From.

Definition at line 789 of file Select.cpp.

References m_from.

Referenced by DissolvePGISToOGR(), DissolvePGISToPGIS(), te::qt::widgets::RasterizationWizardPage::getDistinctClasses(), te::da::SpatialQueryProcessor::getOIDSet(), te::qt::widgets::WhereClauseWidget::getPropertyValues(), te::vp::GetSelectQueryFromLayer(), te::qt::plugins::tv::TimeViewerDockWidget::onSliderChanged(), te::vp::IntersectionQuery::run(), and te::qt::plugins::tv::TimeViewerDockWidget::setupLayerInt().

void te::da::Select::setGroupBy ( GroupBy * g )

It sets the list of expressions used to condense the result set.

Parameters

g	The list of expressions used to condense the result set.

Note: Select will take the ownership of GroupBy.

Definition at line 809 of file Select.cpp.

References m_groupBy.

Referenced by te::vp::Dissolve::executeQuery(), te::vp::PolygonToLineQuery::run(), and te::vp::GeometricOpQuery::SetAggregByAttribute().

void te::da::Select::setHaving ( Having * h )

It sets the list of expressions used to eliminate group row that doesn't satisfy the condition.

Parameters

h	The list of expressions used to eliminate group row that doesn't satisfy the condition.

Note: Select will take the ownership of Having.

Definition at line 819 of file Select.cpp.

References m_having.

void te::da::Select::setLimit ( std::size_t m )

It specifies the maximum number of rows to return.

Parameters

m	The maximum number of rows to return.

Definition at line 849 of file Select.cpp.

References m_limit.

void te::da::Select::setOffset ( std::size_t o )

It specifies the number of rows to skip before starting to return rows.

Parameters

o	The number of rows to skip before starting to return rows.

Definition at line 859 of file Select.cpp.

References m_offset.

void te::da::Select::setOrderBy ( OrderBy * o )

It sets the list of expressions used to sort the output result.

Parameters

o	The list of expressions used to sort the output result.

Note: Select will take the ownership of OrderBy.

Definition at line 829 of file Select.cpp.

References m_orderBy.

Referenced by te::map::QueryLayerRenderer::drawLayerGeometries(), te::map::QueryLayerRenderer::drawLayerLinkedGroupingMem(), te::qt::widgets::RasterizationWizardPage::getDistinctClasses(), te::qt::widgets::GroupingWidget::getLinkedDataAsDouble(), te::qt::widgets::GroupingWidget::getLinkedDataAsString(), and te::qt::widgets::ChartLayerWidget::getMaxValue().

void te::da::Select::setWhere ( Where * w )

It sets the filter codition.

Parameters

w	The filter condition.

Note: Select will take the ownership of Where.

Definition at line 799 of file Select.cpp.

References m_where.

Referenced by te::da::SpatialQueryProcessor::getOIDSet(), te::vp::GetSelectQueryFromLayer(), te::vp::IntersectionDialog::onOkPushButtonClicked(), te::qt::plugins::tv::TimeViewerDockWidget::onSliderChanged(), and te::vp::IntersectionQuery::run().

te::da::Select & te::da::Select::where ( Expression * e )

Definition at line 507 of file Select.cpp.

References m_where.

te::da::Select & te::da::Select::where ( const Expression & e )

Definition at line 517 of file Select.cpp.

References te::da::Expression::clone(), and m_where.

te::da::Select & te::da::Select::where ( Where * w )

Definition at line 527 of file Select.cpp.

References m_where.

te::da::Select & te::da::Select::where ( const Where & rhs )

Definition at line 533 of file Select.cpp.

References m_where.

te::da::Where & te::da::Select::where ( )

Definition at line 539 of file Select.cpp.

References m_where.

Referenced by operator+().

const te::da::Where & te::da::Select::where ( ) const

Definition at line 544 of file Select.cpp.

References m_where.

Member Data Documentation

std::unique_ptr<Distinct> te::da::Select::m_distinct

private

Definition at line 444 of file Select.h.

Referenced by distinct(), getDistinct(), operator=(), Select(), and setDistinct().

std::unique_ptr<Fields> te::da::Select::m_fields

private

Definition at line 438 of file Select.h.

Referenced by fields(), getFields(), operator()(), operator=(), Select(), and setFields().

std::unique_ptr<From> te::da::Select::m_from

private

Definition at line 439 of file Select.h.

Referenced by from(), getFrom(), operator=(), Select(), and setFrom().

std::unique_ptr<GroupBy> te::da::Select::m_groupBy

private

Definition at line 441 of file Select.h.

Referenced by getGroupBy(), groupBy(), operator=(), Select(), and setGroupBy().

std::unique_ptr<Having> te::da::Select::m_having

private

Definition at line 442 of file Select.h.

Referenced by getHaving(), having(), operator=(), Select(), and setHaving().

std::size_t te::da::Select::m_limit

private

Definition at line 445 of file Select.h.

Referenced by getLimit(), limit(), operator=(), and setLimit().

std::size_t te::da::Select::m_offset

private

Definition at line 446 of file Select.h.

Referenced by getOffset(), offset(), operator=(), and setOffset().

std::unique_ptr<OrderBy> te::da::Select::m_orderBy

private

Definition at line 443 of file Select.h.

Referenced by getOrderBy(), operator=(), orderBy(), Select(), and setOrderBy().

std::unique_ptr<Where> te::da::Select::m_where

private

Definition at line 440 of file Select.h.

Referenced by getWhere(), operator=(), Select(), setWhere(), and where().

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

Public Types

Public Member Functions

Private Attributes

Detailed Description

Member Typedef Documentation

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation