te::da::BasicQueries Class Reference

#include <BasicQueries.h>

Static Public Member Functions
static TEDATAACCESSEXPORT void	AppendExpressionToWhereClause (te::da::Select *select, te::da::Expression *expression)
static TEDATAACCESSEXPORT std::unique_ptr< te::da::Fields >	GetFields (const te::da::DataSetType *dataSetType)
static TEDATAACCESSEXPORT std::unique_ptr< te::da::Fields >	GetFields (const std::vector< std::string > &vecColummns)
static TEDATAACCESSEXPORT std::unique_ptr< te::da::From >	GetFrom (const te::da::DataSetType *dataSetType)
static TEDATAACCESSEXPORT std::unique_ptr< te::da::Expression >	GetInExpression (const std::string &propertyName, const std::vector< int > &vecValues)
static TEDATAACCESSEXPORT std::unique_ptr< te::da::Expression >	GetInExpression (const std::string &propertyName, const std::vector< std::string > &vecValues)
static TEDATAACCESSEXPORT std::unique_ptr< te::da::Expression >	GetIntersectsExpression (const te::da::DataSetType *dataSetType, const te::gm::Envelope &envelope)
static TEDATAACCESSEXPORT std::unique_ptr< te::da::Select >	GetQuery (bool distinct, const std::vector< std::string > &vecColumns, const std::string &tableName, const std::vector< std::string > &vecWhereColumns, const std::vector< te::dt::AbstractData *> &vecWhereValues)
	Helper function to create a query from the given parameters. More...
static TEDATAACCESSEXPORT std::unique_ptr< te::da::Select >	GetQuery (bool distinct, const std::vector< std::string > &vecColumns, const std::string &tableName)
	Helper function to create a query from the given parameters. More...
static TEDATAACCESSEXPORT std::unique_ptr< te::da::Expression >	GetRelationalExpression (const std::string &propertyName, int propertyValue, const std::string &relationalOperator)
static TEDATAACCESSEXPORT std::unique_ptr< te::da::Expression >	GetRelationalExpression (const std::string &propertyName, const std::string &propertyValue, const std::string &relationalOperator)
static TEDATAACCESSEXPORT std::unique_ptr< te::da::Select >	GetSimpleQuery (const te::da::DataSetType *dataSetType)
static TEDATAACCESSEXPORT std::unique_ptr< te::da::Select >	GetSimpleQueryEqualTo (const te::da::DataSetType *dataSetType, const std::string &propertyName, int propertyValue)
static TEDATAACCESSEXPORT std::unique_ptr< te::da::Select >	GetSimpleQueryEqualTo (const te::da::DataSetType *dataSetType, const std::string &propertyName, const std::string &propertyValue)
static TEDATAACCESSEXPORT std::unique_ptr< te::da::Select >	GetSimpleQueryIntersects (const te::da::DataSetType *dataSetType, const te::gm::Envelope &envelope)
static TEDATAACCESSEXPORT std::unique_ptr< te::da::Where >	GetWhereEqualTo (const std::string &propertyName, int propertyValue)
static TEDATAACCESSEXPORT std::unique_ptr< te::da::Where >	GetWhereEqualTo (const std::string &propertyName, const std::string &propertyValue)

Private Member Functions
	BasicQueries ()=delete
	~BasicQueries ()=delete

Detailed Description

Definition at line 58 of file BasicQueries.h.

Constructor & Destructor Documentation

BasicQueries()

te::da::BasicQueries::BasicQueries ( )

privatedelete

~BasicQueries()

te::da::BasicQueries::~BasicQueries ( )

privatedelete

Member Function Documentation

AppendExpressionToWhereClause()

static TEDATAACCESSEXPORT void te::da::BasicQueries::AppendExpressionToWhereClause ( te::da::Select *  select, te::da::Expression *  expression  )

static

GetFields() [1/2]

static TEDATAACCESSEXPORT std::unique_ptr<te::da::Fields> te::da::BasicQueries::GetFields ( const te::da::DataSetType *  dataSetType )

static

GetFields() [2/2]

static TEDATAACCESSEXPORT std::unique_ptr<te::da::Fields> te::da::BasicQueries::GetFields ( const std::vector< std::string > &  vecColummns )

static

GetFrom()

static TEDATAACCESSEXPORT std::unique_ptr<te::da::From> te::da::BasicQueries::GetFrom ( const te::da::DataSetType *  dataSetType )

static

GetInExpression() [1/2]

static TEDATAACCESSEXPORT std::unique_ptr<te::da::Expression> te::da::BasicQueries::GetInExpression ( const std::string &  propertyName, const std::vector< int > &  vecValues  )

static

GetInExpression() [2/2]

static TEDATAACCESSEXPORT std::unique_ptr<te::da::Expression> te::da::BasicQueries::GetInExpression ( const std::string &  propertyName, const std::vector< std::string > &  vecValues  )

static

GetIntersectsExpression()

static TEDATAACCESSEXPORT std::unique_ptr<te::da::Expression> te::da::BasicQueries::GetIntersectsExpression ( const te::da::DataSetType *  dataSetType, const te::gm::Envelope &  envelope  )

static

GetQuery() [1/2]

static TEDATAACCESSEXPORT std::unique_ptr<te::da::Select> te::da::BasicQueries::GetQuery ( bool  distinct, const std::vector< std::string > &  vecColumns, const std::string &  tableName, const std::vector< std::string > &  vecWhereColumns, const std::vector< te::dt::AbstractData *> &  vecWhereValues  )

static

Helper function to create a query from the given parameters.

Parameters

distinct	TRUE if distinct clause must be added. FALSE otherwise
vecColumns	A vector containing the columns to be added to the query
tableName	The name of the table to be queried
vecWhereColumns	A vector containing all the columns in the where clause
vecWhereValues	A vector containing all the values in the where clause

Returns

An query resulting from the given parameters

GetQuery() [2/2]

static TEDATAACCESSEXPORT std::unique_ptr<te::da::Select> te::da::BasicQueries::GetQuery ( bool  distinct, const std::vector< std::string > &  vecColumns, const std::string &  tableName  )

static

Helper function to create a query from the given parameters.

Parameters

distinct	TRUE if distinct clause must be added. FALSE otherwise
vecColumns	A vector containing the columns to be added to the query
tableName	The name of the table to be queried

Returns

An query resulting from the given parameters

GetRelationalExpression() [1/2]

static TEDATAACCESSEXPORT std::unique_ptr<te::da::Expression> te::da::BasicQueries::GetRelationalExpression ( const std::string &  propertyName, int  propertyValue, const std::string &  relationalOperator  )

static

GetRelationalExpression() [2/2]

static TEDATAACCESSEXPORT std::unique_ptr<te::da::Expression> te::da::BasicQueries::GetRelationalExpression ( const std::string &  propertyName, const std::string &  propertyValue, const std::string &  relationalOperator  )

static

GetSimpleQuery()

static TEDATAACCESSEXPORT std::unique_ptr<te::da::Select> te::da::BasicQueries::GetSimpleQuery ( const te::da::DataSetType *  dataSetType )

static

GetSimpleQueryEqualTo() [1/2]

static TEDATAACCESSEXPORT std::unique_ptr<te::da::Select> te::da::BasicQueries::GetSimpleQueryEqualTo ( const te::da::DataSetType *  dataSetType, const std::string &  propertyName, int  propertyValue  )

static

GetSimpleQueryEqualTo() [2/2]

static TEDATAACCESSEXPORT std::unique_ptr<te::da::Select> te::da::BasicQueries::GetSimpleQueryEqualTo ( const te::da::DataSetType *  dataSetType, const std::string &  propertyName, const std::string &  propertyValue  )

static

GetSimpleQueryIntersects()

static TEDATAACCESSEXPORT std::unique_ptr<te::da::Select> te::da::BasicQueries::GetSimpleQueryIntersects ( const te::da::DataSetType *  dataSetType, const te::gm::Envelope &  envelope  )

static

GetWhereEqualTo() [1/2]

static TEDATAACCESSEXPORT std::unique_ptr<te::da::Where> te::da::BasicQueries::GetWhereEqualTo ( const std::string &  propertyName, int  propertyValue  )

static

GetWhereEqualTo() [2/2]

static TEDATAACCESSEXPORT std::unique_ptr<te::da::Where> te::da::BasicQueries::GetWhereEqualTo ( const std::string &  propertyName, const std::string &  propertyValue  )

static

---

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

• /home/castejon/castejon_files/develop/terralib5/git_release/src/terralib/dataaccess/utils/BasicQueries.h