#include <DataSourceTransactor.h>

Inheritance diagram for te::sqlite::DataSourceTransactor:

Classes
class	Impl

Public Member Functions
void	add (const std::string &datasetName, te::da::DataSet *d, const std::map< std::string, std::string > &options, std::size_t limit=0)

void	addCheckConstraint (const std::string &datasetName, te::da::CheckConstraint *cc)
	It adds a check constraint to the dataset. More...

void	addForeignKey (const std::string &datasetName, te::da::ForeignKey *fk)
	It adds a foreign key constraint to a dataset. More...

void	addIndex (const std::string &datasetName, te::da::Index *idx, const std::map< std::string, std::string > &options)
	It adds an index to the dataset. More...

void	addPrimaryKey (const std::string &datasetName, te::da::PrimaryKey *pk)
	It adds a primary key constraint to the dataset schema. More...

void	addProperty (const std::string &datasetName, te::dt::Property *p)
	It adds a new property to the dataset schema. More...

void	addSequence (te::da::Sequence *sequence)
	It creates a new sequence in the data source. More...

void	addUniqueKey (const std::string &datasetName, te::da::UniqueKey *uk)
	It adds a unique key constraint to the dataset. More...

void	begin ()
	It starts a new transaction. More...

void	cancel ()
	It requests that the data source stop the processing of the current command. More...

bool	checkConstraintExists (const std::string &datasetName, const std::string &name)
	It checks if a check-constraint with the given name exists in the data source. More...

void	cloneDataSet (const std::string &name, const std::string &cloneName, const std::map< std::string, std::string > &options)
	It clones the dataset in the data source. More...

void	commit ()
	It commits the transaction. More...

void	createDataSet (te::da::DataSetType *dt, const std::map< std::string, std::string > &options)
	It creates the dataset schema definition in the target data source. More...

bool	dataSetExists (const std::string &name)
	It checks if a dataset with the given name exists in the data source. More...

	DataSourceTransactor (DataSource parent, sqlite3 db)

void	dropCheckConstraint (const std::string &datasetName, const std::string &name)
	It removes the check constraint from the dataset. More...

void	dropDataSet (const std::string &name)
	It removes the dataset schema from the data source. More...

void	dropForeignKey (const std::string &datasetName, const std::string &fkName)
	It removes the foreign key constraint from the dataset schema. More...

void	dropIndex (const std::string &datasetName, const std::string &idxName)
	It removes the index from the dataset schema. More...

void	dropPrimaryKey (const std::string &datasetName)
	It removes the primary key constraint from the dataset schema. More...

void	dropProperty (const std::string &datasetName, const std::string &name)
	It removes a property from the given dataset. More...

void	dropSequence (const std::string &name)
	It removes the sequence from the data source. More...

void	dropUniqueKey (const std::string &datasetName, const std::string &name)
	It removes the unique key constraint from the dataset. More...

std::string	escape (const std::string &value)
	It escapes a string for using in commands and queries. More...

void	execute (const te::da::Query &command)
	It executes the specified command using a generic query representation. More...

void	execute (const std::string &command)
	It executes the specifed command in the data source native language. More...

bool	foreignKeyExists (const std::string &datasetName, const std::string &name)
	It checks if a foreign key with the given name exists in the data source. More...

std::auto_ptr< te::da::BatchExecutor >	getBatchExecutor ()
	It creates a batch command executor. More...

std::auto_ptr< te::da::CheckConstraint >	getCheckConstraint (const std::string &datasetName, const std::string &name)
	It gets the check constraint of the dataset with the given name. More...

std::vector< std::string >	getCheckConstraintNames (const std::string &datasetName)
	It gets the check constraint names of the given dataset. More...

std::auto_ptr< te::da::DataSet >	getDataSet (const std::string &name, te::common::TraverseType travType=te::common::FORWARDONLY, bool connected=false, const te::common::AccessPolicy accessPolicy=te::common::RAccess)
	It gets the dataset identified by the given name. A dataset can be connected or disconnected. A connected dataset, after its creation through the data source transactor, continues to depend on the connection given by its associated data source. Differently, a disconnected dataset, after its creation, no more depends of the connection given by the data source, and it continues to live after the connection has been released to the data source. More...

std::auto_ptr< te::da::DataSet >	getDataSet (const std::string &name, const std::string &propertyName, const te::gm::Envelope *e, te::gm::SpatialRelation r, te::common::TraverseType travType=te::common::FORWARDONLY, bool connected=false, const te::common::AccessPolicy accessPolicy=te::common::RAccess)
	It gets the dataset identified by the given name using a spatial filter over the specified property. A dataset can be connected or disconnected. A connected dataset, after its creation through the data source transactor, continues to depend on the connection given by its associated data source. Differently, a disconnected dataset, after its creation, no more depends of the connection given by the data source, and it continues to live after the connection has been released to the data source. More...

std::auto_ptr< te::da::DataSet >	getDataSet (const std::string &name, const std::string &propertyName, const te::gm::Geometry *g, te::gm::SpatialRelation r, te::common::TraverseType travType=te::common::FORWARDONLY, bool connected=false, const te::common::AccessPolicy accessPolicy=te::common::RAccess)
	It gets the dataset identified by the given name using a spatial filter over the given geometric property. A dataset can be connected or disconnected. A connected dataset, after its creation through the data source transactor, continues to depend on the connection given by its associated data source. Differently, a disconnected dataset, after its creation, no more depends of the connection given by the data source, and it continues to live after the connection has been released to the data source. More...

std::vector< std::string >	getDataSetNames ()
	It It gets the dataset names available in the data source. More...

std::auto_ptr< te::da::DataSetType >	getDataSetType (const std::string &name)
	It gets information about the given dataset. More...

te::da::DataSource *	getDataSource () const
	It returns the parent data source of the transactor. More...

sqlite3 *	getDB () const

std::auto_ptr< te::gm::Envelope >	getExtent (const std::string &datasetName, const std::string &propertyName)
	It retrieves the bounding rectangle of the spatial property for the given dataset. More...

std::auto_ptr< te::gm::Envelope >	getExtent (const std::string &datasetName, std::size_t propertyPos)
	It retrieves the bounding rectangle for the spatial property lying in the given position in the dataset. More...

std::auto_ptr< te::da::ForeignKey >	getForeignKey (const std::string &datasetName, const std::string &name)
	It retrieves the foreign key from the given dataset. More...

std::vector< std::string >	getForeignKeyNames (const std::string &datasetName)
	It gets the foreign key names of the given dataset. More...

std::auto_ptr< te::da::Index >	getIndex (const std::string &datasetName, const std::string &name)
	It gets the index with the given name from the dataset. More...

std::vector< std::string >	getIndexNames (const std::string &datasetName)
	It gets the index names of the given dataset. More...

boost::int64_t	getLastGeneratedId ()
	It returns the last id generated by an insertion command. More...

std::size_t	getNumberOfDataSets ()
	It retrieves the number of data sets available in the data source. More...

std::size_t	getNumberOfItems (const std::string &datasetName)
	It retrieves the number of items of the given dataset. More...

std::size_t	getNumberOfProperties (const std::string &datasetName)
	It gets the number of properties of the given dataset. More...

std::auto_ptr< te::da::PreparedQuery >	getPrepared (const std::string &qName=std::string(""))
	It creates a prepared query object that may be used for query commands (select, insert, update and delete) that are used repeatedly. More...

std::auto_ptr< te::da::PrimaryKey >	getPrimaryKey (const std::string &datasetName)
	It retrieves the primary key of the dataset. More...

boost::ptr_vector< te::dt::Property >	getProperties (const std::string &datasetName)
	It retrieves the properties of the dataset. More...

std::auto_ptr< te::dt::Property >	getProperty (const std::string &datasetName, const std::string &name)
	It retrieves the property with the given name from the dataset. More...

std::auto_ptr< te::dt::Property >	getProperty (const std::string &datasetName, std::size_t propertyPos)
	It retrieves the property lying in the given position from the dataset. More...

std::vector< std::string >	getPropertyNames (const std::string &datasetName)
	It gets the property names of the given dataset. More...

std::auto_ptr< te::da::Sequence >	getSequence (const std::string &name)
	It gets the sequence with the given name in the data source. More...

std::vector< std::string >	getSequenceNames ()
	It gets the sequence names available in the data source. More...

std::auto_ptr< te::da::UniqueKey >	getUniqueKey (const std::string &datasetName, const std::string &name)
	It gets the unique key in the dataset with the given name. More...

std::vector< std::string >	getUniqueKeyNames (const std::string &datasetName)
	It gets the unique key names of the given dataset. More...

bool	hasDataSets ()
	It checks if the data source has any dataset. More...

bool	indexExists (const std::string &datasetName, const std::string &name)
	It checks if an index with the given name exists in the dataset. More...

bool	isDataSetNameValid (const std::string &datasetName)
	It returns true if the given string is a valid dataset name. More...

bool	isInTransaction () const
	It returns true if a transaction is in progress, otherwise, it returns false. More...

bool	isPropertyNameValid (const std::string &propertyName)
	It checks if the given property name is valid. More...

void	optimize (const std::map< std::string, std::string > &opInfo)
	For some data access drivers, this method will perform some operations to optimize the data storage. More...

bool	primaryKeyExists (const std::string &datasetName, const std::string &name)
	It checks if a primary key exists in the dataset. More...

bool	propertyExists (const std::string &datasetName, const std::string &name)
	It checks if a property with the given name exists in the dataset. More...

std::auto_ptr< te::da::DataSet >	query (const te::da::Select &q, te::common::TraverseType travType=te::common::FORWARDONLY, bool connected=false, const te::common::AccessPolicy accessPolicy=te::common::RAccess)
	It executes a query that may return some data using a generic query. A dataset can be connected or disconnected. A connected dataset, after its creation through the data source transactor, continues to depend on the connection given by its associated data source. Differently, a disconnected dataset, after its creation, no more depends of the connection given by the data source, and it continues to live after the connection has been released to the data source. This method is different of the method that accepts a dataset name and a spatial filter, because it allows the retrieving of only a subset of the attributes, since a query can include a property list. More...

std::auto_ptr< te::da::DataSet >	query (const std::string &query, te::common::TraverseType travType=te::common::FORWARDONLY, bool connected=false, const te::common::AccessPolicy accessPolicy=te::common::RAccess)
	It executes a query that may return some data using the data source native language. A dataset can be connected or disconnected. A connected dataset, after its creation through the data source transactor, continues to depend on the connection given by its associated data source. Differently, a disconnected dataset, after its creation, no more depends of the connection given by the data source, and it continues to live after the connection has been released to the data source. More...

void	remove (const std::string &datasetName, const te::da::ObjectIdSet *oids=0)
	It removes all the informed items from the dataset. More...

void	renameDataSet (const std::string &name, const std::string &newName)
	It renames a dataset. More...

void	renameProperty (const std::string &datasetName, const std::string &propertyName, const std::string &newPropertyName)
	It renames a property of the given dataset. More...

void	rollBack ()
	It aborts the transaction. Any changes will be rolled-back. More...

bool	sequenceExists (const std::string &name)
	It checks if a sequence with the given name exists in the data source. More...

bool	uniqueKeyExists (const std::string &datasetName, const std::string &name)
	It checks if a unique key with the given name exists in the dataset. More...

void	update (const std::string &datasetName, te::da::DataSet dataset, const std::vector< std::size_t > &properties, const te::da::ObjectIdSet oids, const std::map< std::string, std::string > &options, std::size_t limit=0)
	It updates the contents of a dataset for the set of data items. More...

	~DataSourceTransactor ()
	Virtual destructor. More...

DataSet Retrieval
Methods for retrieving data from the data source.
std::unique_ptr< te::da::DataSet >	getDataSet (const std::string &name, const ObjectIdSet *oids, te::common::TraverseType travType=te::common::FORWARDONLY, bool connected=false, const te::common::AccessPolicy accessPolicy=te::common::RAccess)
	It gets the dataset identified by the given name using the set of objects identification. A dataset can be connected or disconnected. A connected dataset, after its creation through the data source transactor, continues to depend on the connection given by its associated data source. Differently, a disconnected dataset, after its creation, no more depends of the connection given by the data source, and it continues to live after the connection has been released to the data source. More...

Dataset Metadata Retrieval
Methods for retrieving metadata about the datasets of the data source.
virtual std::unique_ptr< te::da::DataSetTypeCapabilities >	getCapabilities (const std::string &name)
	It gets capabilities about a data set. More...

virtual void	changePropertyDefinition (const std::string &datasetName, const std::string &propName, te::dt::Property *newProp)

virtual std::string	getGeometryTypeName (te::gm::GeomType type)
	It gets the datasource geometry type name equivalent to terralib. More...

Dataset Persistence Methods
Methods for dealing with the persistence of data in a data source.
virtual void	add (const std::string &datasetName, DataSet *d, const std::map< std::string, std::string > &options, std::size_t limit=0, bool enableProgress=true)=0
	It adds data items to the dataset in the data source. More...

virtual void	update (const std::string &datasetName, DataSet *dataset, const std::vector< std::set< int > > &properties, const std::vector< size_t > &ids)
	It updates the contents of a dataset. More...

Private Attributes
Impl *	m_pImpl

Detailed Description

Definition at line 44 of file attic/src/sqlite/DataSourceTransactor.h.

Constructor & Destructor Documentation

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

Definition at line 92 of file attic/src/sqlite/DataSourceTransactor.cpp.

References m_pImpl.

te::sqlite::DataSourceTransactor::~DataSourceTransactor ( )

virtual

Virtual destructor.

Reimplemented from te::da::DataSourceTransactor.

Definition at line 98 of file attic/src/sqlite/DataSourceTransactor.cpp.

References m_pImpl.

Member Function Documentation

void te::sqlite::DataSourceTransactor::add	(	const std::string &	datasetName,
		te::da::DataSet *	d,
		const std::map< std::string, std::string > &	options,
		std::size_t	limit = `0`
	)

Definition at line 1086 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::da::ScopedTransaction::commit(), te::sqlite::GetSQLBindValues(), te::da::GetSQLValueNames(), te::sqlite::DataSourceTransactor::Impl::m_db, m_pImpl, and te::da::DataSet::moveNext().

virtual void te::da::DataSourceTransactor::add	(	const std::string &	datasetName,
		DataSet *	d,
		const std::map< std::string, std::string > &	options,
		std::size_t	limit = `0`,
		bool	enableProgress = `true`
	)

pure virtualinherited

It adds data items to the dataset in the data source.

Parameters

datasetName	The target dataset name.
d	The data items to be added to the dataset.
options	A list of optional modifiers (driver specific).
limit	The number of items to be used from the input dataset. If set to 0 (default), all items are used.
enableProgress	Enable task progress during the save.

Exceptions

Exception An exception can be thrown, if the input dataset items could not be added to the given dataset.

Note: The dataset reading will start in the current position. So, keep in mind that it is the caller responsability to inform the right position(and a valid one) in the dataset 'd', to start the inserting process.; Not thread-safe!

Implemented in te::pgis::Transactor, te::ws::ogc::wcs::da::Transactor, te::ado::Transactor, terralib4::Transactor, te::ws::ogc::wms::da::Transactor, te::stmem::Transactor, te::wfs::Transactor, te::ogr::Transactor, and te::gdal::Transactor.

void te::sqlite::DataSourceTransactor::addCheckConstraint	(	const std::string &	datasetName,
		te::da::CheckConstraint *	cc
	)

virtual

It adds a check constraint to the dataset.

Parameters

datasetName	The dataset where the constraint will be added.
cc	The check constraint.

Exceptions

Exception An exception can be thrown, if the check constraint could not be added to the dataset schema.

Note: Don't delete the given check constraint, because the schema will take the ownership of it.; Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 719 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::addForeignKey	(	const std::string &	datasetName,
		te::da::ForeignKey *	fk
	)

virtual

It adds a foreign key constraint to a dataset.

Parameters

datasetName	The dataset where the foreign key constraint will be added.
fk	The foreign key constraint.

Exceptions

Exception An exception can be thrown, if the foreign key could not be added to the dataset schema.

Note: Don't delete the given foreign key, because the schema will take the ownership of it.; Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 593 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::addIndex	(	const std::string &	datasetName,
		te::da::Index *	idx,
		const std::map< std::string, std::string > &	options
	)

virtual

It adds an index to the dataset.

Parameters

datasetName	The dataset where the index will be added.
idx	The index to be added.
options	A list of optional modifiers (driver specific).

Exceptions

Exception An exception can be thrown, if the index could not be added to the dataset schema.

Note: Don't delete the given index, because the schema will take the ownership of it.; Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 797 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::da::B_TREE_TYPE, execute(), te::da::Index::getIndexType(), te::da::Index::getName(), te::da::Index::getProperties(), and te::da::R_TREE_TYPE.

void te::sqlite::DataSourceTransactor::addPrimaryKey	(	const std::string &	datasetName,
		te::da::PrimaryKey *	pk
	)

virtual

It adds a primary key constraint to the dataset schema.

Parameters

datasetName	The name of the dataset where the primary key will be added.
pk	The primary key constraint.

Exceptions

Exception An exception can be thrown, if the primary key could not be added to the dataset schema.

Note: Don't delete the given primary key, because the schema will take the ownership of it.; Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 500 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::addProperty	(	const std::string &	datasetName,
		te::dt::Property *	p
	)

virtual

It adds a new property to the dataset schema.

Parameters

datasetName	The dataset where the property will be added.
p	The new property to be added.

Exceptions

Exception An exception can be thrown, if the property could not be added to the dataset schema.

Note: Don't delete the given property, because the schema will take the ownership of it.; Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 417 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::sqlite::Convert2SpatiaLiteGeom(), execute(), te::dt::GEOMETRY_TYPE, te::gm::GeometryProperty::getGeometryType(), te::dt::Property::getName(), te::sqlite::GetSQLType(), te::gm::GeometryProperty::getSRID(), te::dt::Property::getType(), te::dt::SimpleProperty::isRequired(), and p.

void te::sqlite::DataSourceTransactor::addSequence ( te::da::Sequence * sequence )

virtual

It creates a new sequence in the data source.

Exceptions

Exception An exception can be thrown, if the sequence could not be added to the data source.

Note: Don't delete the given sequence, because the schema will take the ownership of it.; Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 890 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::addUniqueKey	(	const std::string &	datasetName,
		te::da::UniqueKey *	uk
	)

virtual

It adds a unique key constraint to the dataset.

Parameters

datasetName	The dataset where the unique key will be added.
uk	The unique key constraint.

Exceptions

Exception An exception can be thrown, if the unique key could not be added to the dataset schema.

Note: Don't delete the given unique key, because the schema will take the ownership of it.; Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 664 of file attic/src/sqlite/DataSourceTransactor.cpp.

References execute(), te::da::Constraint::getName(), and te::da::UniqueKey::getProperties().

void te::sqlite::DataSourceTransactor::begin ( )

virtual

It starts a new transaction.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 108 of file attic/src/sqlite/DataSourceTransactor.cpp.

References execute(), te::sqlite::DataSourceTransactor::Impl::m_isInTransaction, and m_pImpl.

void te::sqlite::DataSourceTransactor::cancel ( )

virtual

It requests that the data source stop the processing of the current command.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 307 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::sqlite::DataSourceTransactor::Impl::m_db, and m_pImpl.

void te::da::DataSourceTransactor::changePropertyDefinition	(	const std::string &	datasetName,
		const std::string &	propName,
		te::dt::Property *	newProp
	)

virtualinherited

Reimplemented in te::pgis::Transactor, te::ado::Transactor, te::ogr::Transactor, and te::gpkg::Transactor.

Definition at line 90 of file src/terralib/dataaccess/datasource/DataSourceTransactor.cpp.

Referenced by te::vp::Merge::updateInputDst().

bool te::sqlite::DataSourceTransactor::checkConstraintExists	(	const std::string &	datasetName,
		const std::string &	name
	)

virtual

It checks if a check-constraint with the given name exists in the data source.

Parameters

datasetName	The dataset name.
name	The check-constraint name.

Exceptions

Exception An exception can be thrown, if the existence of the check constraint could not be determined.

Returns: True, if the check-constraint exists in the dataset; otherwise, it returns false.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 714 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::cloneDataSet	(	const std::string &	name,
		const std::string &	cloneName,
		const std::map< std::string, std::string > &	options
	)

virtual

It clones the dataset in the data source.

Parameters

name	The dataset to be cloned.
cloneName	The name of the cloned dataset.
options	A list of optional modifiers. It is driver specific.

Exceptions

Exception An exception can be thrown, if the dataset schema could not be cloned.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 1069 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::commit ( )

virtual

It commits the transaction.

After commiting or rolling back, you can start another transaction.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 114 of file attic/src/sqlite/DataSourceTransactor.cpp.

References execute(), te::sqlite::DataSourceTransactor::Impl::m_isInTransaction, and m_pImpl.

void te::sqlite::DataSourceTransactor::createDataSet	(	te::da::DataSetType *	dt,
		const std::map< std::string, std::string > &	options
	)

virtual

It creates the dataset schema definition in the target data source.

If a dataset schema with the same name already exists in the target data source, this may throw an exception.

After calling this method, the dataset schema may be updated.

Parameters

dt	The dataset schema to be created. It may be changed during the operation.
options	A list of optional modifiers (driver specific).

Precondition: The schema of a related dataset in a foreign key must be already in the data source.

Postcondition: In some data sources, this method may output implicit indexes, sequences or constraints. The method, if necessary, will create and adjust the dataset schema.; The caller of this method will take the ownership of the given schema.

Note: If you want to create a new schema based on an already existing one, you must create a fresh copy of the DataSetType with the clone() method.; Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 935 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::sqlite::Convert2SpatiaLiteGeom(), te::sqlite::Convert2SQLCreate(), execute(), te::dt::GEOMETRY_TYPE, te::da::DataSetType::getForeignKey(), te::gm::GeometryProperty::getGeometryType(), te::dt::Property::getName(), te::da::DataSetType::getNumberOfForeignKeys(), te::da::DataSetType::getPrimaryKey(), te::da::ForeignKey::getProperties(), te::da::PrimaryKey::getProperties(), te::dt::CompositeProperty::getProperty(), te::da::ForeignKey::getReferencedDataSetType(), te::da::ForeignKey::getReferencedProperties(), te::gm::GeometryProperty::getSRID(), te::dt::Property::getType(), p, te::da::Constraint::setName(), and te::dt::CompositeProperty::size().

bool te::sqlite::DataSourceTransactor::dataSetExists ( const std::string & name )

virtual

It checks if a dataset with the given name exists in the data source.

Parameters

name	The dataset name.

Exceptions

Exception An exception can be thrown, if the existence of a dataset in the data source could not be determined.

Returns: True, if the dataset exists in the data source; otherwise, it returns false.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 930 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::dropCheckConstraint	(	const std::string &	datasetName,
		const std::string &	name
	)

virtual

It removes the check constraint from the dataset.

Parameters

datasetName	The dataset from where the check constraint will be removed.
name	The check constraint to be removed.

Exceptions

Exception An exception can be thrown, if the check constraint could not be removed from the dataset schema.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 724 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::dropDataSet ( const std::string & name )

virtual

It removes the dataset schema from the data source.

Parameters

name	The dataset name whose schema will be removed from the data source.

Exceptions

Exception An exception can be thrown, if the dataset could not be removed from the data source.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 1076 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::dropForeignKey	(	const std::string &	datasetName,
		const std::string &	fkName
	)

virtual

It removes the foreign key constraint from the dataset schema.

Parameters

datasetName	The dataset where the foreign key will be removed.
fkName	The foreign key to be removed.

Exceptions

Exception An exception can be thrown, if the foreign key could not be removed from the dataset schema.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 598 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::dropIndex	(	const std::string &	datasetName,
		const std::string &	idxName
	)

virtual

It removes the index from the dataset schema.

Parameters

datasetName	The dataset where the index will be removed.
idxName	The index to be removed.

Exceptions

Exception An exception can be thrown, if the index could not be removed from the dataset schema.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 846 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::dropPrimaryKey ( const std::string & datasetName )

virtual

It removes the primary key constraint from the dataset schema.

Parameters

datasetName The dataset from where the primary key will be removed.

Exceptions

Exception An exception can be thrown, if the primary key could not be dropped from the dataset schema.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 506 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::dropProperty	(	const std::string &	datasetName,
		const std::string &	name
	)

virtual

It removes a property from the given dataset.

Parameters

datasetName	The dataset from where the given property will be removed.
name	The property to be removed from the dataset.

Exceptions

Exception An exception can be thrown, if the dataset property could not be removed.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 460 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::dropSequence ( const std::string & name )

virtual

It removes the sequence from the data source.

Parameters

name	The sequence that will be removed.

Exceptions

Exception An exception can be thrown, if the sequence could not be removed from the data source.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 895 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::dropUniqueKey	(	const std::string &	datasetName,
		const std::string &	name
	)

virtual

It removes the unique key constraint from the dataset.

Parameters

datasetName	The dataset from where the unique key will be removed.
name	The unique key constraint name.

Exceptions

Exception An exception can be thrown, if the unique key could not be removed from the dataset schema.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 689 of file attic/src/sqlite/DataSourceTransactor.cpp.

References execute().

std::string te::sqlite::DataSourceTransactor::escape ( const std::string & value )

virtual

It escapes a string for using in commands and queries.

Parameters

value Any string.

Returns: A valid escaped string.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 317 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::execute ( const te::da::Query & command )

virtual

It executes the specified command using a generic query representation.

Parameters

command A query like: CREATE, DROP, ALTER, INSERT, UPDATE, DELETE.

Exceptions

Exception It can throw an exception, if the query cannot be performed.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 268 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::common::BaseVisitable< T, R >::accept(), te::sqlite::DataSource::getDialect(), te::sqlite::DataSourceTransactor::Impl::m_parent, and m_pImpl.

Referenced by addIndex(), addProperty(), addUniqueKey(), begin(), commit(), createDataSet(), dropUniqueKey(), and te::sqlite::BatchExecutor::execute().

void te::sqlite::DataSourceTransactor::execute ( const std::string & command )

virtual

It executes the specifed command in the data source native language.

Parameters

command A query string in the data source native language (like: CREATE, DROP, ALTER, INSERT, UPDATE, DELETE).

Exceptions

Exception It can throw an exception, if the query cannot be performed.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 278 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::sqlite::DataSourceTransactor::Impl::m_db, and m_pImpl.

bool te::sqlite::DataSourceTransactor::foreignKeyExists	(	const std::string &	datasetName,
		const std::string &	name
	)

virtual

It checks if a foreign key with the given name exists in the data source.

Parameters

datasetName	The dataset name.
name	The foreign key name.

Exceptions

Exception An exception can be thrown, if the existence of the foreign key could not be obtained.

Returns: True, if the foreign key exists in the dataset; otherwise, it returns false.

Implements te::da::DataSourceTransactor.

Definition at line 576 of file attic/src/sqlite/DataSourceTransactor.cpp.

References query().

std::auto_ptr< te::da::BatchExecutor > te::sqlite::DataSourceTransactor::getBatchExecutor ( )

virtual

It creates a batch command executor.

Exceptions

Exception An exception can be thrown if the batch command executor cannot be performed.

Returns: A batch command executor owned by the caller.

Implements te::da::DataSourceTransactor.

Definition at line 302 of file attic/src/sqlite/DataSourceTransactor.cpp.

std::unique_ptr< te::da::DataSetTypeCapabilities > te::da::DataSourceTransactor::getCapabilities ( const std::string & name )

virtualinherited

It gets capabilities about a data set.

Parameters

name	Name of the dataset.

Returns: The capabilities of the data set.

Note: By default it returns a fully support capabilities. If a driver does not support any capabilty, it may reimplement this function.

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

Definition at line 81 of file src/terralib/dataaccess/datasource/DataSourceTransactor.cpp.

std::auto_ptr< te::da::CheckConstraint > te::sqlite::DataSourceTransactor::getCheckConstraint	(	const std::string &	datasetName,
		const std::string &	name
	)

virtual

It gets the check constraint of the dataset with the given name.

Parameters

datasetName	The dataset name.
name	The check constraint name.

Exceptions

Exception An exception can be thrown, if the check constraint could not be retrieved.

Returns: The check constraint with the given name.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 704 of file attic/src/sqlite/DataSourceTransactor.cpp.

std::vector< std::string > te::sqlite::DataSourceTransactor::getCheckConstraintNames ( const std::string & datasetName )

virtual

It gets the check constraint names of the given dataset.

Parameters

datasetName The dataset name.

Exceptions

Exception An exception can be thrown, if the check constraint names could not be retrieved.

Returns: The check constraint names of the dataset.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 709 of file attic/src/sqlite/DataSourceTransactor.cpp.

std::auto_ptr< te::da::DataSet > te::sqlite::DataSourceTransactor::getDataSet	(	const std::string &	name,
		te::common::TraverseType	travType = `te::common::FORWARDONLY`,
		bool	connected = `false`,
		const te::common::AccessPolicy	accessPolicy = `te::common::RAccess`
	)

virtual

It gets the dataset identified by the given name. A dataset can be connected or disconnected. A connected dataset, after its creation through the data source transactor, continues to depend on the connection given by its associated data source. Differently, a disconnected dataset, after its creation, no more depends of the connection given by the data source, and it continues to live after the connection has been released to the data source.

Parameters

name	The dataset name.
accessPolicy	Access policy.
travType	The traverse type associated to the returned dataset.
connected	A flag to indicate if the returned dataset is connected or not.

Exceptions

Exception

It can throw an exception if:

something goes wrong during the data retrieval
if the data source driver doesn't support the traversal type

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 135 of file attic/src/sqlite/DataSourceTransactor.cpp.

References query().

std::auto_ptr< te::da::DataSet > te::sqlite::DataSourceTransactor::getDataSet	(	const std::string &	name,
		const std::string &	propertyName,
		const te::gm::Envelope *	e,
		te::gm::SpatialRelation	r,
		te::common::TraverseType	travType = `te::common::FORWARDONLY`,
		bool	connected = `false`,
		const te::common::AccessPolicy	accessPolicy = `te::common::RAccess`
	)

virtual

It gets the dataset identified by the given name using a spatial filter over the specified property. A dataset can be connected or disconnected. A connected dataset, after its creation through the data source transactor, continues to depend on the connection given by its associated data source. Differently, a disconnected dataset, after its creation, no more depends of the connection given by the data source, and it continues to live after the connection has been released to the data source.

Parameters

name	The dataset name.
propertyName	The name of the spatial property that will be used to apply the spatial filter.
e	A rectangle to be used as a spatial filter when retrieving datasets.
r	The spatial relation to be used during the filter.
accessPolicy	Access policy.
travType	The traversal type associated to the returned dataset.
connected	A flag to indicate if the returned dataset is connected or not.

Exceptions

Exception

It can throw an exception if:

something goes wrong during the data retrieval
if the data source driver doesn't support the traversal type

Note: The envelope coordinates should be in the same coordinate system as the dataset.; Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 147 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::gm::Envelope::m_llx, te::gm::Envelope::m_lly, te::gm::Envelope::m_urx, te::gm::Envelope::m_ury, and query().

std::auto_ptr< te::da::DataSet > te::sqlite::DataSourceTransactor::getDataSet	(	const std::string &	name,
		const std::string &	propertyName,
		const te::gm::Geometry *	g,
		te::gm::SpatialRelation	r,
		te::common::TraverseType	travType = `te::common::FORWARDONLY`,
		bool	connected = `false`,
		const te::common::AccessPolicy	accessPolicy = `te::common::RAccess`
	)

virtual

It gets the dataset identified by the given name using a spatial filter over the given geometric property. A dataset can be connected or disconnected. A connected dataset, after its creation through the data source transactor, continues to depend on the connection given by its associated data source. Differently, a disconnected dataset, after its creation, no more depends of the connection given by the data source, and it continues to live after the connection has been released to the data source.

Parameters

name	The dataset name.
propertyName	The name of the spatial property that will be used to apply the spatial filter.
g	The geometry that will be used as a spatial filter when retrieving the dataset.
r	The spatial relation that will be used during the filtering.
accessPolicy	Access policy.
travType	The traverse type associated to the returned dataset.
connected	A flag to indicate if the returned dataset is connected or not.

Exceptions

Exception

It can throw an exception if:

something goes wrong during the data retrieval
if the data source driver doesn't support the traversal type

Note: The geometry coordinates should be in the same coordinate system as the dataset.; Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 177 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::common::FORWARDONLY, te::sqlite::GetBindableSpatialRelation(), te::sqlite::EWKBSize::getEWKBSize(), te::gm::Geometry::getMBR(), te::gm::Envelope::m_llx, te::gm::Envelope::m_lly, m_pImpl, te::gm::Envelope::m_urx, te::gm::Envelope::m_ury, te::sqlite::DataSourceTransactor::Impl::queryLite(), and te::common::Globals::sm_machineByteOrder.

std::unique_ptr< te::da::DataSet > te::da::DataSourceTransactor::getDataSet	(	const std::string &	name,
		const ObjectIdSet *	oids,
		te::common::TraverseType	travType = `te::common::FORWARDONLY`,
		bool	connected = `false`,
		const te::common::AccessPolicy	accessPolicy = `te::common::RAccess`
	)

inherited

It gets the dataset identified by the given name using the set of objects identification. A dataset can be connected or disconnected. A connected dataset, after its creation through the data source transactor, continues to depend on the connection given by its associated data source. Differently, a disconnected dataset, after its creation, no more depends of the connection given by the data source, and it continues to live after the connection has been released to the data source.

Parameters

name	The dataset name of the dataset.
oids	A pointer for the set of objects. Do not pass null, nor an empty set.
accessPolicy	Access policy.
travType	The traverse type associated to the returned dataset.
connected	A flag to indicate if the returned dataset is connected or not.

Exceptions

Exception

It can throw an exception if:

something goes wrong during data retrieval
if the data source driver doesn't support the traversal type

Definition at line 47 of file src/terralib/dataaccess/datasource/DataSourceTransactor.cpp.

References te::da::ObjectIdSet::getExpression(), te::da::DataSourceTransactor::query(), and te::da::ObjectIdSet::size().

std::vector< std::string > te::sqlite::DataSourceTransactor::getDataSetNames ( )

virtual

It It gets the dataset names available in the data source.

Returns: The dataset names available in the data source.

Exceptions

Exception An exception can be thrown, if the dataset names could not be retrieved.

Note: Each dataset in the data source must have a unique name. For example, in a DBMS the name may contain the schema name before the table name separated by a dot notation (".").; Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 333 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::sqlite::DataSourceCatalogLoader::getDataSetNames().

Referenced by getNumberOfDataSets().

std::auto_ptr< te::da::DataSetType > te::sqlite::DataSourceTransactor::getDataSetType ( const std::string & name )

virtual

It gets information about the given dataset.

This method can provide the following information about a dataset:

the list of properties, including: name, data type, size, if the value is required or not, if it is an autoincrement
primary key
foreign keys
unique keys
check constraints
indexes

Parameters

name	The name of the dataset we are looking information for.

Exceptions

Exception An exception can be thrown, if the information about the dataset could not be retrieved.

Returns: The dataset schema.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 346 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::sqlite::DataSourceCatalogLoader::getDataSetType().

te::da::DataSource * te::sqlite::DataSourceTransactor::getDataSource ( ) const

virtual

It returns the parent data source of the transactor.

Implements te::da::DataSourceTransactor.

Definition at line 103 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::sqlite::DataSourceTransactor::Impl::m_parent, and m_pImpl.

Referenced by te::sqlite::BatchExecutor::add(), te::sqlite::DataSourceCatalogLoader::getDataSets(), and te::sqlite::PreparedQuery::prepare().

sqlite3 * te::sqlite::DataSourceTransactor::getDB ( ) const

Definition at line 1140 of file attic/src/sqlite/DataSourceTransactor.cpp.

Referenced by te::sqlite::BatchExecutor::execute().

std::auto_ptr< te::gm::Envelope > te::sqlite::DataSourceTransactor::getExtent	(	const std::string &	datasetName,
		const std::string &	propertyName
	)

virtual

It retrieves the bounding rectangle of the spatial property for the given dataset.

Parameters

datasetName	The dataset name.
propertyName	The spatial property name.

Exceptions

Exception An exception can be thrown, if the extent of the geometry property could not be retrieved.

Returns: The spatial property bounding rectangle, or NULL, if none can be retrieved.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 900 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::sqlite::DataSourceCatalogLoader::getExtent().

std::auto_ptr< te::gm::Envelope > te::sqlite::DataSourceTransactor::getExtent	(	const std::string &	datasetName,
		std::size_t	propertyPos
	)

virtual

It retrieves the bounding rectangle for the spatial property lying in the given position in the dataset.

Parameters

datasetName	The dataset name.
propertyPos	The spatial property position.

Exceptions

Exception An exception can be thrown, if the extent of the geometry property lying in the given position could not be retrieved.

Returns: The spatial property bounding rectangle, or NULL if none can be retrieved.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 908 of file attic/src/sqlite/DataSourceTransactor.cpp.

References dt, te::sqlite::DataSourceCatalogLoader::getDataSetType(), and te::sqlite::DataSourceCatalogLoader::getExtent().

std::auto_ptr< te::da::ForeignKey > te::sqlite::DataSourceTransactor::getForeignKey	(	const std::string &	datasetName,
		const std::string &	name
	)

virtual

It retrieves the foreign key from the given dataset.

Parameters

datasetName	The dataset name.
name	The foreign key name.

Exceptions

Exception An exception can be thrown, if the foreign key could not be retrieved.

Returns: If the foreign key exists in the dataset, it is returned; otherwise, a NULL is returned.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 511 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::sqlite::GetAction(), and query().

std::vector< std::string > te::sqlite::DataSourceTransactor::getForeignKeyNames ( const std::string & datasetName )

virtual

It gets the foreign key names of the given dataset.

Parameters

datasetName The dataset name.

Exceptions

Exception An exception can be thrown, if the foreign key names could not be retrieved.

Returns: The foreign key names of the given dataset.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 547 of file attic/src/sqlite/DataSourceTransactor.cpp.

References query().

std::string te::da::DataSourceTransactor::getGeometryTypeName ( te::gm::GeomType type )

virtualinherited

It gets the datasource geometry type name equivalent to terralib.

Parameters

type	The terralib geometry type.

Returns: The geometry type name equivalent to terralib.

Reimplemented in te::pgis::Transactor.

Definition at line 114 of file src/terralib/dataaccess/datasource/DataSourceTransactor.cpp.

std::auto_ptr< te::da::Index > te::sqlite::DataSourceTransactor::getIndex	(	const std::string &	datasetName,
		const std::string &	name
	)

virtual

It gets the index with the given name from the dataset.

Parameters

datasetName	The dataset name.
name	The index name.

Exceptions

Exception An exception can be thrown, if the index could not be retrieved.

Returns: The index with the given name.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 729 of file attic/src/sqlite/DataSourceTransactor.cpp.

std::vector< std::string > te::sqlite::DataSourceTransactor::getIndexNames ( const std::string & datasetName )

virtual

It gets the index names of the given dataset.

Parameters

datasetName The dataset name.

Exceptions

Exception An exception can be thrown, if the index names could not be retrieved.

Returns: The index names of the given dataset.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 734 of file attic/src/sqlite/DataSourceTransactor.cpp.

boost::int64_t te::sqlite::DataSourceTransactor::getLastGeneratedId ( )

virtual

It returns the last id generated by an insertion command.

Returns: The last id generated by an insertion command.

Note: This is the way to deal with auto-increment values.; Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 312 of file attic/src/sqlite/DataSourceTransactor.cpp.

std::size_t te::sqlite::DataSourceTransactor::getNumberOfDataSets ( )

virtual

It retrieves the number of data sets available in the data source.

Exceptions

Exception An exception can be thrown, if the number of datasets could not be retrieved.

Returns: The number of data sets available in the data source.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 340 of file attic/src/sqlite/DataSourceTransactor.cpp.

References getDataSetNames().

std::size_t te::sqlite::DataSourceTransactor::getNumberOfItems ( const std::string & datasetName )

virtual

It retrieves the number of items of the given dataset.

Parameters

datasetName The dataset name.

Exceptions

Exception An exception can be thrown, if the number of items of the dataset could not be retrieved.

Returns: The number of items of the given dataset.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 918 of file attic/src/sqlite/DataSourceTransactor.cpp.

std::size_t te::sqlite::DataSourceTransactor::getNumberOfProperties ( const std::string & datasetName )

virtual

It gets the number of properties of the given dataset.

Parameters

datasetName The dataset name.

Exceptions

Exception An exception can be thrown, if the number of dataset properties could not be retrieved.

Returns: The number of properties of the given dataset.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 399 of file attic/src/sqlite/DataSourceTransactor.cpp.

References dt, and te::sqlite::DataSourceCatalogLoader::getDataSetType().

std::auto_ptr< te::da::PreparedQuery > te::sqlite::DataSourceTransactor::getPrepared ( const std::string & qName = std::string("") )

virtual

It creates a prepared query object that may be used for query commands (select, insert, update and delete) that are used repeatedly.

Parameters

qName The prepared query name.

Exceptions

Exception An exception can be thrown if the prepared query cannot be performed.

Returns: A prepared query object owned by the caller.

Implements te::da::DataSourceTransactor.

Definition at line 297 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::sqlite::DataSourceTransactor::Impl::m_db, and m_pImpl.

std::auto_ptr< te::da::PrimaryKey > te::sqlite::DataSourceTransactor::getPrimaryKey ( const std::string & datasetName )

virtual

It retrieves the primary key of the dataset.

Parameters

datasetName The dataset name.

Exceptions

Exception An exception can be thrown, if the primary key could not be retrieved.

Returns: If a primary key exists in the dataset, it is returned; otherwise, a NULL is returned.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 472 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::dt::TimeDuration::clone(), dt, and te::sqlite::DataSourceCatalogLoader::getDataSetType().

boost::ptr_vector< te::dt::Property > te::sqlite::DataSourceTransactor::getProperties ( const std::string & datasetName )

virtual

It retrieves the properties of the dataset.

Parameters

datasetName The dataset name.

Exceptions

Exception An exception can be thrown, if the dataset properties could not be retrieved.

Returns: The properties of the dataset.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 354 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::sqlite::DataSourceCatalogLoader::getProperties().

std::auto_ptr< te::dt::Property > te::sqlite::DataSourceTransactor::getProperty	(	const std::string &	datasetName,
		const std::string &	name
	)

virtual

It retrieves the property with the given name from the dataset.

Parameters

datasetName	The dataset name.
propertyName	The property name.

Exceptions

Exception An exception can be thrown, if the dataset property could not be retrieved.

Returns: The property with the given name from the dataset.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 362 of file attic/src/sqlite/DataSourceTransactor.cpp.

References dt, te::sqlite::DataSourceCatalogLoader::getDataSetType(), and p.

std::auto_ptr< te::dt::Property > te::sqlite::DataSourceTransactor::getProperty	(	const std::string &	datasetName,
		std::size_t	propertyPos
	)

virtual

It retrieves the property lying in the given position from the dataset.

Parameters

datasetName	The dataset name.
propertyPos	The property position.

Exceptions

Exception An exception can be thrown, if the property lying in the given position could not be retrieved.

Returns: The property in the given position.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 374 of file attic/src/sqlite/DataSourceTransactor.cpp.

References dt, te::sqlite::DataSourceCatalogLoader::getDataSetType(), and p.

std::vector< std::string > te::sqlite::DataSourceTransactor::getPropertyNames ( const std::string & datasetName )

virtual

It gets the property names of the given dataset.

Parameters

datasetName The dataset name.

Exceptions

Exception An exception can be thrown, if the property names of the dataset could not be retrieved.

Returns: The property names of the dataset.

Note: Each dataset in the data source must have a unique name. For example, in a DBMS the name may contain the schema name before the table name separated by a dot notation (".").; Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 385 of file attic/src/sqlite/DataSourceTransactor.cpp.

References dt, and te::sqlite::DataSourceCatalogLoader::getDataSetType().

std::auto_ptr< te::da::Sequence > te::sqlite::DataSourceTransactor::getSequence ( const std::string & name )

virtual

It gets the sequence with the given name in the data source.

Parameters

name	The sequence name.

Exceptions

Exception An exception can be thrown, if the sequence could not be retrieved from the data source.

Returns: The sequence with the given name.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 875 of file attic/src/sqlite/DataSourceTransactor.cpp.

std::vector< std::string > te::sqlite::DataSourceTransactor::getSequenceNames ( )

virtual

It gets the sequence names available in the data source.

Note: Each sequence in the data source must have a unique name. For example, in a DBMS the name may contain the schema name before the sequence name separated by a dot notation (".").

Exceptions

Exception An exception can be thrown, if the sequence names could not be retrieved.

Returns: The sequence names of the data source.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 880 of file attic/src/sqlite/DataSourceTransactor.cpp.

std::auto_ptr< te::da::UniqueKey > te::sqlite::DataSourceTransactor::getUniqueKey	(	const std::string &	datasetName,
		const std::string &	name
	)

virtual

It gets the unique key in the dataset with the given name.

Parameters

datasetName	The dataset name.
name	The unique key name.

Exceptions

Exception An exception can be thrown, if the unique key could not be retrieved.

Returns: The unique key with the given name in the dataset.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 603 of file attic/src/sqlite/DataSourceTransactor.cpp.

std::vector< std::string > te::sqlite::DataSourceTransactor::getUniqueKeyNames ( const std::string & datasetName )

virtual

It gets the unique key names of the given dataset.

Parameters

datasetName The dataset name.

Exceptions

Exception An exception can be thrown, if the unique key names could not be obtained.

Returns: The unique key names of the dataset.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 654 of file attic/src/sqlite/DataSourceTransactor.cpp.

bool te::sqlite::DataSourceTransactor::hasDataSets ( )

virtual

It checks if the data source has any dataset.

Exceptions

Exception An exception can be thrown, if it is not possible to check if the data source has datasets .

Returns: True, if the data source has datasets; otherwise, it returns false.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 923 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::sqlite::DataSourceCatalogLoader::hasDataSets().

bool te::sqlite::DataSourceTransactor::indexExists	(	const std::string &	datasetName,
		const std::string &	name
	)

virtual

It checks if an index with the given name exists in the dataset.

Parameters

datasetName	The dataset name.
name	The index name.

Exceptions

Exception An exception can be thrown, if the index existence could not be determined.

Returns: True, if the index exists in the dataset; otherwise, it returns false.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 792 of file attic/src/sqlite/DataSourceTransactor.cpp.

bool te::sqlite::DataSourceTransactor::isDataSetNameValid ( const std::string & datasetName )

virtual

It returns true if the given string is a valid dataset name.

Parameters

datasetName A dataset name whose validity will be checked.

Returns: True, if the name is valid according to the data source rules.

Note: Not thread-safe!

Reimplemented from te::da::DataSourceTransactor.

Definition at line 322 of file attic/src/sqlite/DataSourceTransactor.cpp.

bool te::sqlite::DataSourceTransactor::isInTransaction ( ) const

virtual

It returns true if a transaction is in progress, otherwise, it returns false.

Returns: True, if a transaction is in progress, otherwise, false.

Implements te::da::DataSourceTransactor.

Definition at line 129 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::sqlite::DataSourceTransactor::Impl::m_isInTransaction, and m_pImpl.

bool te::sqlite::DataSourceTransactor::isPropertyNameValid ( const std::string & propertyName )

virtual

It checks if the given property name is valid.

Parameters

propertyName A property name whose validity will be checked.

Returns: True, if the name is valid according to the data source rules.

Note: Not thread-safe!

Reimplemented from te::da::DataSourceTransactor.

Definition at line 327 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::optimize ( const std::map< std::string, std::string > & opInfo )

virtual

For some data access drivers, this method will perform some operations to optimize the data storage.

This is can be a typical maintenance command in database systems (like vacuum).

Parameters

opInfo Any information needed by the underlying driver in order to fine tune the optimization.

Exceptions

Exception It may throw an exception if something goes wrong.

Note: Not thread-safe!; For some systems you must assure that no other thread are executing commands against the data source.; For some drivers, this method has no effect.

Implements te::da::DataSourceTransactor.

Definition at line 1136 of file attic/src/sqlite/DataSourceTransactor.cpp.

bool te::sqlite::DataSourceTransactor::primaryKeyExists	(	const std::string &	datasetName,
		const std::string &	name
	)

virtual

It checks if a primary key exists in the dataset.

Parameters

datasetName	The dataset name.
name	The primary key name.

Exceptions

Exception An exception can be thrown, if the existence of the primary key could not be determined.

Returns: True, if a primary key exists in the dataset; otherwise, it returns false.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 481 of file attic/src/sqlite/DataSourceTransactor.cpp.

References query().

bool te::sqlite::DataSourceTransactor::propertyExists	(	const std::string &	datasetName,
		const std::string &	name
	)

virtual

It checks if a property with the given name exists in the dataset.

Parameters

datasetName	The dataset name.
name	The property name.

Exceptions

Exception An exception can be thrown, if the existence of the dataset property could not be obtained.

Returns: True, if the property exists in the dataset; otherwise, it returns false.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 408 of file attic/src/sqlite/DataSourceTransactor.cpp.

References dt, and te::sqlite::DataSourceCatalogLoader::getDataSetType().

std::auto_ptr< te::da::DataSet > te::sqlite::DataSourceTransactor::query	(	const te::da::Select &	q,
		te::common::TraverseType	travType = `te::common::FORWARDONLY`,
		bool	connected = `false`,
		const te::common::AccessPolicy	accessPolicy = `te::common::RAccess`
	)

virtual

It executes a query that may return some data using a generic query. A dataset can be connected or disconnected. A connected dataset, after its creation through the data source transactor, continues to depend on the connection given by its associated data source. Differently, a disconnected dataset, after its creation, no more depends of the connection given by the data source, and it continues to live after the connection has been released to the data source. This method is different of the method that accepts a dataset name and a spatial filter, because it allows the retrieving of only a subset of the attributes, since a query can include a property list.

Exceptions

Exception

It can throw an exception if:

something goes wrong during the data retrieval
if the data source driver doesn't support the traversal type

Parameters

q	A valid query object.
travType	The traverse type associated to the returned dataset.
connected	A flag to indicate if the returned dataset is connected or not.
accessPolicy	Access policy.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 237 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::common::BaseVisitable< T, R >::accept(), te::sqlite::DataSource::getDialect(), te::sqlite::DataSourceTransactor::Impl::m_parent, and m_pImpl.

std::auto_ptr< te::da::DataSet > te::sqlite::DataSourceTransactor::query	(	const std::string &	query,
		te::common::TraverseType	travType = `te::common::FORWARDONLY`,
		bool	connected = `false`,
		const te::common::AccessPolicy	accessPolicy = `te::common::RAccess`
	)

virtual

It executes a query that may return some data using the data source native language. A dataset can be connected or disconnected. A connected dataset, after its creation through the data source transactor, continues to depend on the connection given by its associated data source. Differently, a disconnected dataset, after its creation, no more depends of the connection given by the data source, and it continues to live after the connection has been released to the data source.

Parameters

query	A query string in the data source native language.
travType	The traverse type associated to the returned dataset.
connected	A flag to indicate if the returned dataset is connected or not.
accessPolicy	Access policy.

Exceptions

Exception

It can throw an exception if:

something goes wrong during the data retrieval
if the data source driver doesn't support the traversal type

Note: Don't use this method, if you want portability for your application.; Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 251 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::common::FORWARDONLY, m_pImpl, and te::sqlite::DataSourceTransactor::Impl::queryLite().

void te::sqlite::DataSourceTransactor::remove	(	const std::string &	datasetName,
		const te::da::ObjectIdSet *	oids = `0`
	)

virtual

It removes all the informed items from the dataset.

It removes all the data items from a dataset which are identified by a set of object identifiers. If this set is not informed, all items will be removed.

Parameters

datasetName	The dataset name.
oids	A list of object identifiers used to remove data from the datasource, or NULL for all.

Exceptions

Exception An exception can be thrown, if the data items could not be removed.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 1121 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::renameDataSet	(	const std::string &	name,
		const std::string &	newName
	)

virtual

It renames a dataset.

Parameters

name	The name of the dataset to be renamed.
newName	The new dataset name.

Exceptions

Exception An exception can be thrown, if the dataset could not be renamed.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 1081 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::renameProperty	(	const std::string &	datasetName,
		const std::string &	propertyName,
		const std::string &	newPropertyName
	)

virtual

It renames a property of the given dataset.

Parameters

datasetName	The dataset containig the property to be renamed.
propertyName	The property to be renamed from the dataset.
newPropertyName	The new property name.

Exceptions

Exception An exception can be thrown, if the dataset property could not be renamed.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 465 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::rollBack ( )

virtual

It aborts the transaction. Any changes will be rolled-back.

After commiting or rolling back, you can start another transaction.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 120 of file attic/src/sqlite/DataSourceTransactor.cpp.

References te::sqlite::DataSourceTransactor::Impl::m_db, te::sqlite::DataSourceTransactor::Impl::m_isInTransaction, and m_pImpl.

bool te::sqlite::DataSourceTransactor::sequenceExists ( const std::string & name )

virtual

It checks if a sequence with the given name exists in the data source.

Parameters

name	The sequence name.

Exceptions

Exception An exception can be thrown, if the index existence could not be determined.

Returns: True, if the sequence exists in the data source; otherwise, it returns false.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 885 of file attic/src/sqlite/DataSourceTransactor.cpp.

bool te::sqlite::DataSourceTransactor::uniqueKeyExists	(	const std::string &	datasetName,
		const std::string &	name
	)

virtual

It checks if a unique key with the given name exists in the dataset.

Parameters

datasetName	The dataset name.
name	The unique key name.

Exceptions

Exception An exception can be thrown, if the existence of the unique key could not be determined.

Returns: True, if the unique key exists in the data source; otherwise, it returns false.

Note: Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 659 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::sqlite::DataSourceTransactor::update	(	const std::string &	datasetName,
		te::da::DataSet *	dataset,
		const std::vector< std::size_t > &	properties,
		const te::da::ObjectIdSet *	oids,
		const std::map< std::string, std::string > &	options,
		std::size_t	limit = `0`
	)

virtual

It updates the contents of a dataset for the set of data items.

Parameters

datasetName	The target dataset name.
dataset	The list of data items to be updated.
properties	The list of properties of the dataset to be updated.
oids	The list of objects to be updated.
options	A list of optional modifiers. It is driver specific.
limit	The number of items to be used from the input dataset. If set to 0 (default) all items are used.

Exceptions

Exception An exception can be thrown, if the dataset could not be updated.

Note: The dataset reading will start in the current position. So, keep in mind that it is the caller responsability to inform the right position(and a valid one) for the dataset 'd', to start the updating process.; Not thread-safe!

Implements te::da::DataSourceTransactor.

Definition at line 1126 of file attic/src/sqlite/DataSourceTransactor.cpp.

void te::da::DataSourceTransactor::update	(	const std::string &	datasetName,
		DataSet *	dataset,
		const std::vector< std::set< int > > &	properties,
		const std::vector< size_t > &	ids
	)

virtualinherited

It updates the contents of a dataset.

All rows are edited. The third parameter tells wich columns are edited for each row.

Parameters

datasetName	Name pf the dataset.
dataset	Dataset with editions.
properties	Columns edited for each row. Note that the size of properties must be the same of the dataset.
ids	List of positions of the columns that identifies rows.

Exceptions

te::da::Exception An exception can be thrown, if the dataset could not be updated.

Reimplemented in te::pgis::Transactor, te::ado::Transactor, te::ogr::Transactor, and te::gpkg::Transactor.

Definition at line 96 of file src/terralib/dataaccess/datasource/DataSourceTransactor.cpp.

Member Data Documentation

Impl* te::sqlite::DataSourceTransactor::m_pImpl

private

Definition at line 239 of file attic/src/sqlite/DataSourceTransactor.h.

Referenced by add(), begin(), cancel(), commit(), DataSourceTransactor(), execute(), getDataSet(), getDataSource(), getPrepared(), isInTransaction(), query(), rollBack(), and ~DataSourceTransactor().

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

Classes

Public Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation