A visitor for building an SQL statement using PostGIS dialect. More...

#include <SQLVisitor.h>

Inheritance diagram for te::pgis::SQLVisitor:

Public Member Functions
virtual void	visit (const Expression &visited)

virtual void	visit (const DataSetName &visited)

virtual void	visit (const FromItem &visited)

virtual void	visit (const Function &visited)

virtual void	visit (const Insert &visited)

virtual void	visit (const Join &visited)

virtual void	visit (const JoinCondition &visited)

virtual void	visit (const JoinConditionOn &visited)

virtual void	visit (const JoinConditionUsing &visited)

virtual void	visit (const Literal &visited)

virtual void	visit (const LiteralBool &visited)

virtual void	visit (const LiteralDouble &visited)

virtual void	visit (const LiteralInt16 &visited)

virtual void	visit (const LiteralInt32 &visited)

virtual void	visit (const LiteralInt64 &visited)

virtual void	visit (const LiteralString &visited)

virtual void	visit (const PropertyName &visited)

virtual void	visit (const Query &visited)

virtual void	visit (const Select &visited)

virtual void	visit (const SelectExpression &visited)

virtual void	visit (const SubSelect &visited)

virtual void	visit (const In &visited)

virtual void	visit (const Cast &visited)

virtual void	visit (const Fields &visited)

virtual void	visit (const From &visited)

virtual void	visit (const GroupBy &visited)

virtual void	visit (const OrderBy &visited)

Initializer Methods
Methods related to instantiation and destruction.
	SQLVisitor (const te::da::SQLDialect &dialect, std::string &sql, PGconn *conn)
	Default constructor. More...

	~SQLVisitor ()
	Destructor. More...

Select
All concrete visitors must implement these methods.
void	visit (const te::da::LiteralByteArray &visited)

void	visit (const te::da::LiteralDateTime &visited)

void	visit (const te::da::LiteralEnvelope &visited)

void	visit (const te::da::LiteralGeom &visited)

void	visitDistinct (const te::da::Distinct &visited)

Protected Attributes
const SQLDialect &	m_dialect
	The function catalog to use when translating the query. More...

std::string &	m_sql
	The buffer string where the query will be outputed. More...

Private Attributes
PGconn *	m_conn
	The PostGIS connection used to escape string! More...

Detailed Description

A visitor for building an SQL statement using PostGIS dialect.

Definition at line 52 of file src/terralib/postgis/SQLVisitor.h.

Constructor & Destructor Documentation

te::pgis::SQLVisitor::SQLVisitor	(	const te::da::SQLDialect &	dialect,
		std::string &	sql,
		PGconn *	conn
	)

Default constructor.

Definition at line 38 of file src/terralib/postgis/SQLVisitor.cpp.

te::pgis::SQLVisitor::~SQLVisitor ( )

inlinevirtual

Destructor.

Reimplemented from te::da::SQLVisitor.

Definition at line 65 of file src/terralib/postgis/SQLVisitor.h.

Member Function Documentation

void te::da::SQLVisitor::visit ( const Expression & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 75 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

Referenced by te::qt::plugins::tv::TimeViewerDockWidget::onSliderChanged(), te::pgis::Transactor::remove(), te::qt::plugins::tv::TimeViewerDockWidget::setupLayerInt(), te::gpkg::SQLVisitor::visit(), te::ogr::SQLVisitor::visit(), te::ado::SQLVisitor::visit(), and te::da::SQLVisitor::visit().

void te::da::SQLVisitor::visit ( const DataSetName & visited )

virtualinherited

Implements te::da::QueryVisitor.

Reimplemented in te::ogr::SQLVisitor, and te::gpkg::SQLVisitor.

Definition at line 79 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::da::FromItem::getAlias(), te::da::DataSetName::getName(), and te::da::SQLVisitor::m_sql.

void te::da::SQLVisitor::visit ( const FromItem & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 90 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

void te::da::SQLVisitor::visit ( const Function & visited )

virtualinherited

Implements te::da::QueryVisitor.

Reimplemented in te::ado::SQLVisitor.

Definition at line 94 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::da::SQLDialect::find(), te::da::Function::getName(), te::da::SQLVisitor::m_dialect, te::da::SQLVisitor::m_sql, TE_TR, and te::da::SQLFunctionEncoder::toSQL().

void te::da::SQLVisitor::visit ( const Insert & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 106 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::da::Insert::getDataSetName(), te::da::Insert::getFields(), te::da::Insert::getSelect(), te::da::SQLVisitor::m_sql, and te::da::SQLVisitor::visit().

void te::pgis::SQLVisitor::visit ( const te::da::LiteralByteArray & visited )

virtual

Reimplemented from te::da::SQLVisitor.

Definition at line 44 of file src/terralib/postgis/SQLVisitor.cpp.

References te::da::Literal::getValue().

void te::pgis::SQLVisitor::visit ( const te::da::LiteralDateTime & visited )

virtual

Reimplemented from te::da::SQLVisitor.

Definition at line 50 of file src/terralib/postgis/SQLVisitor.cpp.

References te::da::Literal::getValue(), te::da::SQLVisitor::m_sql, and te::dt::AbstractData::toString().

void te::da::SQLVisitor::visit ( const Join & visited )

virtualinherited

Implements te::da::QueryVisitor.

Reimplemented in te::ogr::SQLVisitor, and te::gpkg::SQLVisitor.

Definition at line 130 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::common::BaseVisitable< T, R >::accept(), te::da::CROSS_JOIN, te::da::FULL_OUTER_JOIN, te::da::Join::getCondition(), te::da::Join::getFirst(), te::da::Join::getSecond(), te::da::Join::getType(), te::da::INNER_JOIN, te::da::Join::isNatural(), te::da::JOIN, te::da::LEFT_JOIN, te::da::SQLVisitor::m_sql, te::da::NATURAL_JOIN, and te::da::RIGHT_JOIN.

void te::pgis::SQLVisitor::visit ( const te::da::LiteralEnvelope & visited )

virtual

Reimplemented from te::da::SQLVisitor.

Definition at line 62 of file src/terralib/postgis/SQLVisitor.cpp.

References te::pgis::Convert2PostGIS(), te::da::LiteralEnvelope::getSRID(), te::da::LiteralEnvelope::getValue(), and te::da::SQLVisitor::m_sql.

void te::da::SQLVisitor::visit ( const JoinCondition & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 182 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

void te::pgis::SQLVisitor::visit ( const te::da::LiteralGeom & visited )

virtual

Reimplemented from te::da::SQLVisitor.

Definition at line 68 of file src/terralib/postgis/SQLVisitor.cpp.

References te::pgis::Convert2PostGIS(), te::da::Literal::getValue(), m_conn, and te::da::SQLVisitor::m_sql.

void te::da::SQLVisitor::visit ( const JoinConditionOn & visited )

virtualinherited

Implements te::da::QueryVisitor.

Reimplemented in te::ado::SQLVisitor, te::ogr::SQLVisitor, and te::gpkg::SQLVisitor.

Definition at line 186 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::common::BaseVisitable< T, R >::accept(), te::da::JoinConditionOn::getCondition(), and te::da::SQLVisitor::m_sql.

void te::da::SQLVisitor::visit ( const JoinConditionUsing & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 194 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::common::BaseVisitable< T, R >::accept(), te::da::JoinConditionUsing::getNumFields(), and te::da::SQLVisitor::m_sql.

void te::da::SQLVisitor::visit ( const Literal & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 212 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::da::Literal::getValue(), te::da::SQLVisitor::m_sql, and te::dt::AbstractData::toString().

void te::da::SQLVisitor::visit ( const LiteralBool & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 218 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::da::Literal::getValue(), te::da::SQLVisitor::m_sql, and te::dt::AbstractData::toString().

void te::da::SQLVisitor::visit ( const LiteralDouble & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 236 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::da::Literal::getValue(), te::da::SQLVisitor::m_sql, and te::dt::AbstractData::toString().

void te::da::SQLVisitor::visit ( const LiteralInt16 & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 252 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::da::Literal::getValue(), te::da::SQLVisitor::m_sql, and te::dt::AbstractData::toString().

void te::da::SQLVisitor::visit ( const LiteralInt32 & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 258 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::da::Literal::getValue(), te::da::SQLVisitor::m_sql, and te::dt::AbstractData::toString().

void te::da::SQLVisitor::visit ( const LiteralInt64 & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 264 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::da::Literal::getValue(), te::da::SQLVisitor::m_sql, and te::dt::AbstractData::toString().

void te::da::SQLVisitor::visit ( const LiteralString & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 270 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::da::Literal::getValue(), te::da::SQLVisitor::m_sql, and te::dt::AbstractData::toString().

void te::da::SQLVisitor::visit ( const PropertyName & visited )

virtualinherited

Implements te::da::QueryVisitor.

Reimplemented in te::ado::SQLVisitor, te::ogr::SQLVisitor, and te::gpkg::SQLVisitor.

Definition at line 280 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::da::PropertyName::getName(), and te::da::SQLVisitor::m_sql.

void te::da::SQLVisitor::visit ( const Query & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 285 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

void te::da::SQLVisitor::visit ( const Select & visited )

virtualinherited

Implements te::da::QueryVisitor.

Reimplemented in te::ogr::SQLVisitor, and te::gpkg::SQLVisitor.

Definition at line 289 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::common::BaseVisitable< T, R >::accept(), te::da::Select::getDistinct(), te::da::Where::getExp(), te::da::Having::getExp(), te::da::Select::getFields(), te::da::Select::getFrom(), te::da::Select::getGroupBy(), te::da::Select::getHaving(), te::da::Select::getOrderBy(), te::da::Select::getWhere(), te::da::SQLVisitor::m_sql, te::da::SQLVisitor::visit(), and te::da::SQLVisitor::visitDistinct().

void te::da::SQLVisitor::visit ( const SelectExpression & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 335 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::common::BaseVisitable< T, R >::accept(), te::da::SelectExpression::getSelect(), and te::da::SQLVisitor::m_sql.

void te::da::SQLVisitor::visit ( const SubSelect & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 344 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::common::BaseVisitable< T, R >::accept(), te::da::FromItem::getAlias(), te::da::SubSelect::getSelect(), and te::da::SQLVisitor::m_sql.

void te::da::SQLVisitor::visit ( const In & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 359 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::common::BaseVisitable< T, R >::accept(), te::da::Function::getNumArgs(), te::da::In::getPropertyName(), and te::da::SQLVisitor::m_sql.

void te::da::SQLVisitor::visit ( const Cast & visited )

virtualinherited

Implements te::da::QueryVisitor.

Definition at line 379 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::common::BaseVisitable< T, R >::accept(), te::dt::DATETIME_TYPE, te::dt::DOUBLE_TYPE, te::da::Function::getNumArgs(), te::da::Literal::getValue(), te::dt::SimpleData< T, typeCode >::getValue(), te::dt::INT32_TYPE, te::da::SQLVisitor::m_sql, and te::dt::STRING_TYPE.

void te::da::SQLVisitor::visit ( const Fields & visited )

virtualinherited

Reimplemented in te::ado::SQLVisitor.

Definition at line 456 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::da::SQLVisitor::m_sql.

void te::da::SQLVisitor::visit ( const From & visited )

virtualinherited

Definition at line 475 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::da::SQLVisitor::m_sql.

void te::da::SQLVisitor::visit ( const GroupBy & visited )

virtualinherited

Definition at line 490 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::da::SQLVisitor::m_sql.

void te::da::SQLVisitor::visit ( const OrderBy & visited )

virtualinherited

Definition at line 505 of file src/terralib/dataaccess/query/SQLVisitor.cpp.

References te::da::ASC, and te::da::SQLVisitor::m_sql.

void te::pgis::SQLVisitor::visitDistinct ( const te::da::Distinct & visited )

virtual

Reimplemented from te::da::SQLVisitor.

Definition at line 74 of file src/terralib/postgis/SQLVisitor.cpp.

References te::da::SQLVisitor::m_sql.

Member Data Documentation

PGconn* te::pgis::SQLVisitor::m_conn

private

The PostGIS connection used to escape string!

Definition at line 84 of file src/terralib/postgis/SQLVisitor.h.

Referenced by visit().

const SQLDialect& te::da::SQLVisitor::m_dialect

protectedinherited

The function catalog to use when translating the query.

Definition at line 108 of file src/terralib/dataaccess/query/SQLVisitor.h.

Referenced by te::da::SQLVisitor::visit().

std::string& te::da::SQLVisitor::m_sql

protectedinherited

The buffer string where the query will be outputed.

Definition at line 109 of file src/terralib/dataaccess/query/SQLVisitor.h.

Referenced by te::ogr::SQLVisitor::visit(), te::gpkg::SQLVisitor::visit(), te::da::SQLVisitor::visit(), visit(), te::ado::SQLVisitor::visit(), te::ogr::SQLVisitor::visitDistinct(), te::gpkg::SQLVisitor::visitDistinct(), visitDistinct(), and te::da::SQLVisitor::visitDistinct().

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

Public Member Functions

Protected Attributes

Private Attributes

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation