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 R	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::auto_ptr< Distinct >	m_distinct

std::auto_ptr< Fields >	m_fields

std::auto_ptr< From >	m_from

std::auto_ptr< GroupBy >	m_groupBy

std::auto_ptr< Having >	m_having

std::size_t	m_limit

std::size_t	m_offset

std::auto_ptr< OrderBy >	m_orderBy

std::auto_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 R te::common::BaseVisitable< QueryVisitor , R >::ReturnType

inherited

Definition at line 58 of file BaseVisitable.h.

typedef QueryVisitor te::common::BaseVisitable< QueryVisitor , R >::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.

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

Definition at line 53 of file Select.cpp.

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

Definition at line 66 of file Select.cpp.

References m_fields.

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

Definition at line 80 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 95 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 111 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 128 of file Select.cpp.

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

Definition at line 141 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 158 of file Select.cpp.

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

Definition at line 171 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 188 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 206 of file Select.cpp.

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

Definition at line 219 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 235 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 252 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 265 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 283 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 302 of file Select.cpp.

References m_fields.

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

Definition at line 317 of file Select.cpp.

References m_fields.

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

Definition at line 332 of file Select.cpp.

References m_fields.

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

Definition at line 347 of file Select.cpp.

References m_fields.

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

Definition at line 362 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 382 of file Select.cpp.

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

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

Destructor.

Definition at line 402 of file Select.cpp.

Member Function Documentation

virtual ReturnType te::common::BaseVisitable< QueryVisitor , R >::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 424 of file Select.cpp.

Referenced by te::map::QueryLayerRenderer::drawLayerGeometries(), te::map::QueryLayerRenderer::drawLayerLinkedGroupingMem(), 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 635 of file Select.cpp.

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

Definition at line 640 of file Select.cpp.

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

Definition at line 863 of file Select.cpp.

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

Definition at line 873 of file Select.cpp.

References te::da::Expression::clone().

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

Definition at line 883 of file Select.cpp.

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

Definition at line 893 of file Select.cpp.

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

Definition at line 899 of file Select.cpp.

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

Definition at line 905 of file Select.cpp.

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

Definition at line 910 of file Select.cpp.

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

Definition at line 429 of file Select.cpp.

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

Definition at line 435 of file Select.cpp.

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

Definition at line 441 of file Select.cpp.

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

Definition at line 446 of file Select.cpp.

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

Definition at line 487 of file Select.cpp.

References te::da::FromItem::clone().

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

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

Definition at line 497 of file Select.cpp.

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

Definition at line 507 of file Select.cpp.

References te::da::FromItem::clone().

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

Definition at line 518 of file Select.cpp.

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

Definition at line 529 of file Select.cpp.

References te::da::FromItem::clone().

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

Definition at line 541 of file Select.cpp.

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

Definition at line 553 of file Select.cpp.

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

Definition at line 563 of file Select.cpp.

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

Definition at line 569 of file Select.cpp.

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

Definition at line 575 of file Select.cpp.

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

Definition at line 580 of file Select.cpp.

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

Definition at line 625 of file Select.cpp.

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

Definition at line 630 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 992 of file Select.cpp.

Referenced by te::serialize::xml::Save(), 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 932 of file Select.cpp.

Referenced by te::da::SpatialQueryProcessor::getOIDSet(), te::qt::widgets::QueryLayerBuilderWizard::getSelectQuery(), te::qt::widgets::TableLinkDialog::getSelectQuery(), te::serialize::xml::Save(), te::ogr::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 942 of file Select.cpp.

Referenced by te::da::SpatialQueryProcessor::getDataSetName(), te::da::SpatialQueryProcessor::getOIDSet(), te::serialize::xml::Save(), 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 962 of file Select.cpp.

Referenced by te::serialize::xml::Save(), 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 972 of file Select.cpp.

Referenced by te::serialize::xml::Save(), 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 1002 of file Select.cpp.

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 1012 of file Select.cpp.

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 982 of file Select.cpp.

Referenced by te::serialize::xml::Save(), 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 952 of file Select.cpp.

Referenced by te::serialize::xml::Save(), te::ogr::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 697 of file Select.cpp.

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

Definition at line 707 of file Select.cpp.

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

Definition at line 717 of file Select.cpp.

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

Definition at line 727 of file Select.cpp.

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

Definition at line 737 of file Select.cpp.

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

Definition at line 743 of file Select.cpp.

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

Definition at line 749 of file Select.cpp.

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

Definition at line 754 of file Select.cpp.

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

Definition at line 759 of file Select.cpp.

References te::da::Having::setExp().

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

Definition at line 769 of file Select.cpp.

References te::da::Expression::clone(), and te::da::Having::setExp().

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

Definition at line 779 of file Select.cpp.

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

Definition at line 785 of file Select.cpp.

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

Definition at line 791 of file Select.cpp.

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

Definition at line 796 of file Select.cpp.

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

Definition at line 595 of file Select.cpp.

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

Definition at line 600 of file Select.cpp.

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

Definition at line 585 of file Select.cpp.

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

Definition at line 590 of file Select.cpp.

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

Definition at line 605 of file Select.cpp.

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

Definition at line 610 of file Select.cpp.

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

Definition at line 915 of file Select.cpp.

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

Definition at line 645 of file Select.cpp.

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

Definition at line 650 of file Select.cpp.

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

Definition at line 921 of file Select.cpp.

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

Definition at line 451 of file Select.cpp.

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

Definition at line 460 of file Select.cpp.

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

Definition at line 469 of file Select.cpp.

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

Definition at line 478 of file Select.cpp.

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

Definition at line 1017 of file Select.cpp.

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

Definition at line 1023 of file Select.cpp.

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

Definition at line 1029 of file Select.cpp.

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

Definition at line 1035 of file Select.cpp.

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

Definition at line 1041 of file Select.cpp.

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

Definition at line 1047 of file Select.cpp.

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

Definition at line 1053 of file Select.cpp.

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

Definition at line 1059 of file Select.cpp.

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

Definition at line 1065 of file Select.cpp.

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

Definition at line 1071 of file Select.cpp.

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

Assignment operator.

Definition at line 406 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 801 of file Select.cpp.

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

Definition at line 811 of file Select.cpp.

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

Definition at line 821 of file Select.cpp.

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

Definition at line 831 of file Select.cpp.

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

Definition at line 841 of file Select.cpp.

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

Definition at line 847 of file Select.cpp.

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

Definition at line 853 of file Select.cpp.

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

Definition at line 858 of file Select.cpp.

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

Definition at line 615 of file Select.cpp.

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

Definition at line 620 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 987 of file Select.cpp.

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 927 of file Select.cpp.

Referenced by te::da::SpatialQueryProcessor::getOIDSet(), te::qt::widgets::WhereClauseWidget::getPropertyValues(), and te::vp::IntersectionQuery::run().

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 937 of file Select.cpp.

Referenced by te::da::SpatialQueryProcessor::getOIDSet(), te::qt::widgets::WhereClauseWidget::getPropertyValues(), and te::vp::IntersectionQuery::run().

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 957 of file Select.cpp.

Referenced by te::vp::LineToPolygonQuery::run(), 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 967 of file Select.cpp.

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 997 of file Select.cpp.

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 1007 of file Select.cpp.

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 977 of file Select.cpp.

Referenced by te::map::QueryLayerRenderer::drawLayerGeometries(), te::map::QueryLayerRenderer::drawLayerLinkedGroupingMem(), 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 947 of file Select.cpp.

Referenced by te::da::SpatialQueryProcessor::getOIDSet(), and te::vp::IntersectionQuery::run().

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

Definition at line 655 of file Select.cpp.

References te::da::Where::setExp().

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

Definition at line 665 of file Select.cpp.

References te::da::Expression::clone(), and te::da::Where::setExp().

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

Definition at line 675 of file Select.cpp.

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

Definition at line 681 of file Select.cpp.

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

Definition at line 687 of file Select.cpp.

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

Definition at line 692 of file Select.cpp.

Member Data Documentation

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

private

Definition at line 444 of file Select.h.

Referenced by operator=(), and Select().

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

private

Definition at line 438 of file Select.h.

Referenced by operator=(), and Select().

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

private

Definition at line 439 of file Select.h.

Referenced by operator=(), and Select().

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

private

Definition at line 441 of file Select.h.

Referenced by operator=(), and Select().

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

private

Definition at line 442 of file Select.h.

Referenced by operator=(), and Select().

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

private

Definition at line 445 of file Select.h.

Referenced by operator=().

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

private

Definition at line 446 of file Select.h.

Referenced by operator=().

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

private

Definition at line 443 of file Select.h.

Referenced by operator=(), and Select().

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

private

Definition at line 440 of file Select.h.

Referenced by operator=(), and Select().

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

C:/TL5_2015_release/terralib5/src/terralib/dataaccess/query/Select.h
C:/TL5_2015_release/terralib5/src/terralib/dataaccess/query/Select.cpp

Public Types

Public Member Functions

Private Attributes

Detailed Description

Member Typedef Documentation

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation