A class that implements a prepared query for the TerraLib SQLite Data Access Driver. More...

#include <PreparedQuery.h>

Inheritance diagram for te::sqlite::PreparedQuery:

Public Member Functions
void	bind (int i, char value)
	Binds the i-th parameter of the query to a value. More...

void	bind (int i, unsigned char value)
	Binds the i-th parameter of the query to a value. More...

void	bind (int i, boost::int16_t value)
	Binds the i-th parameter of the query to a value. More...

void	bind (int i, boost::int32_t value)
	Binds the i-th parameter of the query to a value. More...

void	bind (int i, boost::int64_t value)
	Binds the i-th parameter of the query to a value. More...

void	bind (int i, bool value)
	Binds the i-th parameter of the query to a value. More...

void	bind (int i, float value)
	Binds the i-th parameter of the query to a value. More...

void	bind (int i, double value)
	Binds the i-th parameter of the query to a value. More...

void	bind (int i, const std::string &value)
	Binds the i-th parameter of the query to a value. More...

void	bind (int i, const te::dt::ByteArray &value)
	Binds the i-th parameter of the query to a value. More...

void	bind (int i, const te::gm::Geometry &value)
	Binds the i-th parameter of the query to a value. More...

void	bind (int i, const te::rst::Raster &value)
	Binds the i-th parameter of the query to a value. More...

void	bind (int i, const te::dt::DateTime &value)
	Binds the i-th parameter of the query to a value. More...

void	bind (int i, const te::da::DataSet &value)
	Binds the i-th parameter of the query to a value. More...

void	bind (int i, const te::dt::AbstractData &ad)
	Binds the i-th parameter of the query to a value. More...

void	bind (const std::vector< std::size_t > &propertiesPos, std::size_t offset, te::da::DataSet *d)

void	bind (const std::vector< std::size_t > &propertiesPos, te::da::DataSet *d)

void	bind (te::da::DataSet *d)

void	bindNumeric (int i, const std::string &value)
	Binds the i-th parameter of the query to a value. More...

void	execute ()

std::string	getName () const
	It returns the prepared query name. More...

te::da::DataSourceTransactor *	getTransactor () const
	It returns a pointer to the underlying data source transactor. More...

void	prepare (const te::da::Query &query, const std::vector< te::dt::Property * > &paramTypes)
	It prepares the query that may be used for commands that are used mutiple times (select, insert, update and delete). More...

void	prepare (const std::string &query, const std::vector< te::dt::Property * > &paramTypes)
	It prepares the query using native dialect. More...

void	prepare (const std::string &query)

	PreparedQuery (DataSourceTransactor parent, sqlite3 db)

te::da::DataSet *	query (te::common::TraverseType travType=te::common::FORWARDONLY, te::common::AccessPolicy rwRole=te::common::RAccess)

	~PreparedQuery ()
	Virtual destructor. More...

Private Attributes
sqlite3 *	m_db

sqlite3_stmt *	m_stmt

DataSourceTransactor *	m_t

Detailed Description

A class that implements a prepared query for the TerraLib SQLite Data Access Driver.

See also: te::da::PreparedQuery

Definition at line 68 of file PreparedQuery.h.

Constructor & Destructor Documentation

te::sqlite::PreparedQuery::PreparedQuery	(	DataSourceTransactor *	parent,
		sqlite3 *	db
	)

te::sqlite::PreparedQuery::~PreparedQuery ( )

virtual

Virtual destructor.

Reimplemented from te::da::PreparedQuery.

Member Function Documentation

void te::sqlite::PreparedQuery::bind	(	int	i,
		char	value
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::bind	(	int	i,
		unsigned char	value
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::bind	(	int	i,
		boost::int16_t	value
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::bind	(	int	i,
		boost::int32_t	value
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::bind	(	int	i,
		boost::int64_t	value
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::bind	(	int	i,
		bool	value
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::bind	(	int	i,
		float	value
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::bind	(	int	i,
		double	value
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::bind	(	int	i,
		const std::string &	value
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::bind	(	int	i,
		const te::dt::ByteArray &	value
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::bind	(	int	i,
		const te::gm::Geometry &	value
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::bind	(	int	i,
		const te::rst::Raster &	value
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::bind	(	int	i,
		const te::dt::DateTime &	value
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::bind	(	int	i,
		const te::da::DataSet &	value
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::bind	(	int	i,
		const te::dt::AbstractData &	ad
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Reimplemented from te::da::PreparedQuery.

void te::sqlite::PreparedQuery::bind	(	const std::vector< std::size_t > &	propertiesPos,
		std::size_t	offset,
		te::da::DataSet *	d
	)

void te::sqlite::PreparedQuery::bind	(	const std::vector< std::size_t > &	propertiesPos,
		te::da::DataSet *	d
	)

void te::sqlite::PreparedQuery::bind ( te::da::DataSet * d )

void te::sqlite::PreparedQuery::bindNumeric	(	int	i,
		const std::string &	value
	)

virtual

Binds the i-th parameter of the query to a value.

Parameters

i	The parameter index.
value	The parameter value.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::execute ( )

virtual

Implements te::da::PreparedQuery.

std::string te::sqlite::PreparedQuery::getName ( ) const

virtual

It returns the prepared query name.

Parameters

return The prepared query name.

Implements te::da::PreparedQuery.

te::da::DataSourceTransactor* te::sqlite::PreparedQuery::getTransactor ( ) const

virtual

It returns a pointer to the underlying data source transactor.

Returns: A pointer to the underlying data source transactor.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::prepare	(	const te::da::Query &	query,
		const std::vector< te::dt::Property * > &	paramTypes
	)

virtual

It prepares the query that may be used for commands that are used mutiple times (select, insert, update and delete).

This command will submit a request to create a prepared query with the given parameters.

Parameters

query	The query to be prepared.
paramTypes	The list of parameters data type.

Exceptions

Exception It throws an exception if the prepared query can not be created. For example if another prepared query with the same name already exists, this may throws an exception.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::prepare	(	const std::string &	query,
		const std::vector< te::dt::Property * > &	paramTypes
	)

virtual

It prepares the query using native dialect.

This command may be used for commands that are used mutiple times (select, insert, update and delete).

This command will submit a request to create a prepared query with the given parameters.

Parameters

query	The query to be prepared.
paramTypes	The list of parameters data type.

Exceptions

Exception It throws an exception if the prepared query can not be created. For example if another prepared query with the same name already exists, this may throws an exception.

Implements te::da::PreparedQuery.

void te::sqlite::PreparedQuery::prepare ( const std::string & query )

te::da::DataSet* te::sqlite::PreparedQuery::query	(	te::common::TraverseType	travType = `te::common::FORWARDONLY`,
		te::common::AccessPolicy	rwRole = `te::common::RAccess`
	)

virtual

Implements te::da::PreparedQuery.

Member Data Documentation

sqlite3* te::sqlite::PreparedQuery::m_db

private

Definition at line 133 of file PreparedQuery.h.

sqlite3_stmt* te::sqlite::PreparedQuery::m_stmt

private

Definition at line 132 of file PreparedQuery.h.

DataSourceTransactor* te::sqlite::PreparedQuery::m_t

private

Definition at line 131 of file PreparedQuery.h.

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

C:/AA_TL5_master/terralib5/src/terralib/sqlite/PreparedQuery.h

Public Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation