Loading...
Searching...
No Matches
Transactor.h
Go to the documentation of this file.
1/* Copyright (C) 2008 National Institute For Space Research (INPE) - Brazil.
2
3 This file is part of the TerraLib - a Framework for building GIS enabled applications.
4
5 TerraLib is free software: you can redistribute it and/or modify
6 it under the terms of the GNU Lesser General Public License as published by
7 the Free Software Foundation, either version 3 of the License,
8 or (at your option) any later version.
9
10 TerraLib is distributed in the hope that it will be useful,
11 but WITHOUT ANY WARRANTY; without even the implied warranty of
12 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 GNU Lesser General Public License for more details.
14
15 You should have received a copy of the GNU Lesser General Public License
16 along with TerraLib. See COPYING. If not, write to
17 TerraLib Team at <terralib-team@terralib.org>.
18 */
19
20/*!
21 \file terralib/terralib4/Transactor.h
22
23 \brief DataSourceTransactor implementation for TerraLib 4.x API.
24*/
25
26#ifndef __TERRALIB_TERRALIB4_INTERNAL_DATASOURCETRANSACTOR_H
27#define __TERRALIB_TERRALIB4_INTERNAL_DATASOURCETRANSACTOR_H
28
29// TerraLib
30#include "../dataaccess/datasource/DataSourceTransactor.h"
31#include "Config.h"
32#include "DataSource.h"
33
34// STL
35#include <memory>
36#include <map>
37#include <string>
38
39class TeView;
40class TeAbstractTheme;
41class TeLayer;
42
43namespace te
44{
45 namespace dt { class Property; }
46 namespace gm { class Envelope; class Geometry; }
47}
48
49namespace terralib4
50{
51 class BatchExecutor;
52 class DataSet;
53 class Connection;
54 class ObjectIdSet;
55 class PreparedQuery;
56 class Query;
57 struct ThemeInfo;
58
60 {
61 public:
62
63 Transactor(DataSource* ds, TeDatabase* db);
64
66
68
69 void begin();
70
71 void commit();
72
73 void rollBack();
74
75 bool isInTransaction() const;
76
77 std::unique_ptr<te::da::DataSet> getDataSet(const std::string& name,
79 bool connected = false,
81
82 std::unique_ptr<te::da::DataSet> getDataSet(const std::string& name,
83 const std::string& propertyName,
84 const te::gm::Envelope* e,
87 bool connected = false,
89
90 std::unique_ptr<te::da::DataSet> getDataSet(const std::string& name,
91 const std::string& propertyName,
92 const te::gm::Geometry* g,
95 bool connected = false,
97
98 std::unique_ptr<te::da::DataSet> getDataSet(const std::string& name,
99 const ObjectIdSet* oids,
101 bool connected = false,
102 const te::common::AccessPolicy accessPolicy = te::common::RAccess);
103
104 std::unique_ptr<te::da::DataSet> query(const te::da::Select& q,
106 bool connected = false,
107 const te::common::AccessPolicy accessPolicy = te::common::RAccess);
108
109 std::unique_ptr<te::da::DataSet> query(const std::string& query,
111 bool connected = false,
112 const te::common::AccessPolicy accessPolicy = te::common::RAccess);
113
114 void execute(const te::da::Query& command);
115
116 void execute(const std::string& command);
117
118 std::unique_ptr<te::da::PreparedQuery> getPrepared(const std::string& qName = std::string(""));
119
120 std::unique_ptr<te::da::BatchExecutor> getBatchExecutor();
121
122 void cancel();
123
124 boost::int64_t getLastGeneratedId();
125
126 std::string escape(const std::string& value);
127
128 bool isDataSetNameValid(const std::string& datasetName);
129
130 bool isPropertyNameValid(const std::string& propertyName);
131
132 std::vector<std::string> getDataSetNames();
133
134 std::size_t getNumberOfDataSets();
135
136 std::unique_ptr<te::da::DataSetType> getDataSetType(const std::string& name);
137
138 boost::ptr_vector<te::dt::Property> getProperties(const std::string& datasetName);
139
140 std::unique_ptr<te::dt::Property> getProperty(const std::string& datasetName, const std::string& name);
141
142 std::unique_ptr<te::dt::Property> getProperty(const std::string& datasetName, std::size_t propertyPos);
143
144 std::vector<std::string> getPropertyNames(const std::string& datasetName);
145
146 std::size_t getNumberOfProperties(const std::string& datasetName);
147
148 bool propertyExists(const std::string& datasetName, const std::string& name);
149
150 void addProperty(const std::string& datasetName, te::dt::Property* p);
151
152 void dropProperty(const std::string& datasetName, const std::string& name);
153
154 void renameProperty(const std::string& datasetName,
155 const std::string& propertyName,
156 const std::string& newPropertyName);
157
158 std::unique_ptr<te::da::PrimaryKey> getPrimaryKey(const std::string& datasetName);
159
160 bool primaryKeyExists(const std::string& datasetName, const std::string& name);
161
162 void addPrimaryKey(const std::string& datasetName, te::da::PrimaryKey* pk);
163
164 void dropPrimaryKey(const std::string& datasetName);
165
166 std::unique_ptr<te::da::ForeignKey> getForeignKey(const std::string& datasetName, const std::string& name);
167
168 std::vector<std::string> getForeignKeyNames(const std::string& datasetName);
169
170 bool foreignKeyExists(const std::string& datasetName, const std::string& name);
171
172 void addForeignKey(const std::string& datasetName, te::da::ForeignKey* fk);
173
174 void dropForeignKey(const std::string& datasetName, const std::string& fkName);
175
176 std::unique_ptr<te::da::UniqueKey> getUniqueKey(const std::string& datasetName, const std::string& name);
177
178 std::vector<std::string> getUniqueKeyNames(const std::string& datasetName);
179
180 bool uniqueKeyExists(const std::string& datasetName, const std::string& name);
181
182 void addUniqueKey(const std::string& datasetName, te::da::UniqueKey* uk);
183
184 void dropUniqueKey(const std::string& datasetName, const std::string& name);
185
186 std::unique_ptr<te::da::CheckConstraint> getCheckConstraint(const std::string& datasetName, const std::string& name);
187
188 std::vector<std::string> getCheckConstraintNames(const std::string& datasetName);
189
190 bool checkConstraintExists(const std::string& datasetName, const std::string& name);
191
192 void addCheckConstraint(const std::string& datasetName, te::da::CheckConstraint* cc);
193
194 void dropCheckConstraint(const std::string& datasetName, const std::string& name);
195
196 std::unique_ptr<te::da::Index> getIndex(const std::string& datasetName, const std::string& name);
197
198 std::vector<std::string> getIndexNames(const std::string& datasetName);
199
200 bool indexExists(const std::string& datasetName, const std::string& name);
201
202 void addIndex(const std::string& datasetName, te::da::Index* idx,
203 const std::map<std::string, std::string>& options);
204
205 void dropIndex(const std::string& datasetName, const std::string& idxName);
206
207 std::unique_ptr<te::da::Sequence> getSequence(const std::string& name);
208
209 std::vector<std::string> getSequenceNames();
210
211 bool sequenceExists(const std::string& name);
212
214
215 void dropSequence(const std::string& name);
216
217 std::unique_ptr<te::gm::Envelope> getExtent(const std::string& datasetName,
218 const std::string& propertyName);
219
220 std::unique_ptr<te::gm::Envelope> getExtent(const std::string& datasetName,
221 std::size_t propertyPos);
222
223 std::size_t getNumberOfItems(const std::string& datasetName);
224
226
227 bool dataSetExists(const std::string& name);
228
229 void createDataSet(te::da::DataSetType* dt, const std::map<std::string, std::string>& options);
230
231 void cloneDataSet(const std::string& name,
232 const std::string& cloneName,
233 const std::map<std::string, std::string>& options);
234
235 void dropDataSet(const std::string& name);
236
237 void renameDataSet(const std::string& name, const std::string& newName);
238
239 void add(const std::string& datasetName,
241 const std::map<std::string, std::string>& options,
242 std::size_t limit = 0,
243 bool enableProgress = true);
244
245 void remove(const std::string& datasetName, const te::da::ObjectIdSet* oids = 0);
246
247 void update(const std::string& datasetName,
248 te::da::DataSet* dataset,
249 const std::vector<std::size_t>& properties,
250 const te::da::ObjectIdSet* oids,
251 const std::map<std::string, std::string>& options,
252 std::size_t limit = 0);
253
254 void optimize(const std::map<std::string, std::string>& opInfo);
255
256 std::vector<std::string> getTL4Layers();
257
258 std::vector<std::string> getTL4Tables();
259
260 std::vector<std::string> getTL4Rasters();
261
262 std::vector<std::pair<std::string, std::string> > getTL4RasterFiles();
263
264 std::vector<::terralib4::ThemeInfo> getTL4Themes();
265
266 TeTheme* getTL4Theme(const ::terralib4::ThemeInfo& theme);
267
268 int getLayerSRID(const std::string & layerName);
269
270 private:
271
273 TeDatabase* m_db;
275
276 std::map<int, TeLayer*>& m_layerMap;
277 std::map<int, TeView*>& m_viewMap;
278 std::map<int, TeAbstractTheme*>& m_themeMap;
279 };
280
281} // end namespace terralib4
282
283#endif // __TERRALIB_TERRALIB4_INTERNAL_DATASOURCETRANSACTOR_H
284
285
A class that describes a check constraint.
A class that models the description of a dataset.
Definition: DataSetType.h:73
A dataset is the unit of information manipulated by the data access module of TerraLib.
Definition: DataSet.h:114
A DataSourceTransactor can be viewed as a connection to the data source for reading/writing things in...
An abstract class for data providers like a DBMS, Web Services or a regular file.
Definition: DataSource.h:120
It models a foreign key constraint for a DataSetType.
Definition: ForeignKey.h:49
It describes an index associated to a DataSetType.
Definition: Index.h:53
This class represents a set of unique ids created in the same context. i.e. from the same data set.
Definition: ObjectIdSet.h:56
It describes a primary key (pk) constraint.
Definition: PrimaryKey.h:49
A Query is independent from the data source language/dialect.
Definition: Query.h:47
A Select models a query to be used when retrieving data from a DataSource.
Definition: Select.h:67
It describes a sequence (a number generator).
Definition: Sequence.h:57
It describes a unique key (uk) constraint.
Definition: UniqueKey.h:50
It models a property definition.
Definition: Property.h:60
An Envelope defines a 2D rectangular region.
Definition: Envelope.h:52
Geometry is the root class of the geometries hierarchy, it follows OGC and ISO standards.
Definition: Geometry.h:78
void execute(const std::string &command)
It executes the specifed command in the data source native language.
void addSequence(te::da::Sequence *sequence)
It creates a new sequence in the data source.
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.
std::unique_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.
TeTheme * getTL4Theme(const ::terralib4::ThemeInfo &theme)
bool dataSetExists(const std::string &name)
It checks if a dataset with the given name exists in the data source.
void remove(const std::string &datasetName, const te::da::ObjectIdSet *oids=0)
It removes all the informed items from the dataset.
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.
bool isInTransaction() const
It returns true if a transaction is in progress, otherwise, it returns false.
std::unique_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....
void dropIndex(const std::string &datasetName, const std::string &idxName)
It removes the index from the dataset schema.
std::vector<::terralib4::ThemeInfo > getTL4Themes()
std::vector< std::string > getUniqueKeyNames(const std::string &datasetName)
It gets the unique key names of the given dataset.
std::unique_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 prop...
bool hasDataSets()
It checks if the data source has any dataset.
std::vector< std::string > getForeignKeyNames(const std::string &datasetName)
It gets the foreign key names of the given dataset.
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.
std::vector< std::string > getPropertyNames(const std::string &datasetName)
It gets the property names of the given dataset.
std::unique_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 di...
std::size_t getNumberOfDataSets()
It retrieves the number of data sets available in the data source.
std::unique_ptr< te::da::Sequence > getSequence(const std::string &name)
It gets the sequence with the given name in the data source.
DataSource * m_ds
Definition: Transactor.h:272
std::vector< std::string > getTL4Layers()
std::vector< std::string > getDataSetNames()
It It gets the dataset names available in the data source.
std::unique_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.
boost::int64_t getLastGeneratedId()
It returns the last id generated by an insertion command.
std::unique_ptr< te::da::DataSetType > getDataSetType(const std::string &name)
It gets information about the given dataset.
boost::ptr_vector< te::dt::Property > getProperties(const std::string &datasetName)
It retrieves the properties of the dataset.
TeDatabase * m_db
Definition: Transactor.h:273
std::unique_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....
std::vector< std::pair< std::string, std::string > > getTL4RasterFiles()
bool indexExists(const std::string &datasetName, const std::string &name)
It checks if an index with the given name exists in the dataset.
void dropSequence(const std::string &name)
It removes the sequence from the data source.
void dropDataSet(const std::string &name)
It removes the dataset schema from the data source.
te::da::DataSource * getDataSource() const
It returns the parent data source of the transactor.
std::unique_ptr< te::da::ForeignKey > getForeignKey(const std::string &datasetName, const std::string &name)
It retrieves the foreign key from the given dataset.
std::unique_ptr< te::da::BatchExecutor > getBatchExecutor()
It creates a batch command executor.
std::vector< std::string > getSequenceNames()
It gets the sequence names available in the data source.
std::size_t getNumberOfItems(const std::string &datasetName)
It retrieves the number of items of the given dataset.
void renameProperty(const std::string &datasetName, const std::string &propertyName, const std::string &newPropertyName)
It renames a property of the given dataset.
void begin()
It starts a new transaction.
void cancel()
It requests that the data source stop the processing of the current command.
bool sequenceExists(const std::string &name)
It checks if a sequence with the given name exists in the data source.
void dropForeignKey(const std::string &datasetName, const std::string &fkName)
It removes the foreign key constraint from the dataset schema.
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.
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.
int getLayerSRID(const std::string &layerName)
bool isDataSetNameValid(const std::string &datasetName)
It returns true if the given string is a valid dataset name.
void addPrimaryKey(const std::string &datasetName, te::da::PrimaryKey *pk)
It adds a primary key constraint to the dataset schema.
void addProperty(const std::string &datasetName, te::dt::Property *p)
It adds a new property to the dataset schema.
void addCheckConstraint(const std::string &datasetName, te::da::CheckConstraint *cc)
It adds a check constraint to the dataset.
std::map< int, TeView * > & m_viewMap
Definition: Transactor.h:277
void renameDataSet(const std::string &name, const std::string &newName)
It renames a dataset.
std::unique_ptr< te::da::Index > getIndex(const std::string &datasetName, const std::string &name)
It gets the index with the given name from the dataset.
bool isPropertyNameValid(const std::string &propertyName)
It checks if the given property name is valid.
std::unique_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.
bool uniqueKeyExists(const std::string &datasetName, const std::string &name)
It checks if a unique key with the given name exists in the dataset.
bool propertyExists(const std::string &datasetName, const std::string &name)
It checks if a property with the given name exists in the dataset.
void addUniqueKey(const std::string &datasetName, te::da::UniqueKey *uk)
It adds a unique key constraint to the dataset.
void add(const std::string &datasetName, te::da::DataSet *d, const std::map< std::string, std::string > &options, std::size_t limit=0, bool enableProgress=true)
It adds data items to the dataset in the data source.
std::vector< std::string > getTL4Rasters()
void addForeignKey(const std::string &datasetName, te::da::ForeignKey *fk)
It adds a foreign key constraint to a dataset.
void commit()
It commits the transaction.
std::map< int, TeAbstractTheme * > & m_themeMap
Definition: Transactor.h:278
std::vector< std::string > getCheckConstraintNames(const std::string &datasetName)
It gets the check constraint names of the given dataset.
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.
std::unique_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....
std::unique_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.
Transactor(DataSource *ds, TeDatabase *db)
void dropPrimaryKey(const std::string &datasetName)
It removes the primary key constraint from the dataset schema.
std::vector< std::string > getIndexNames(const std::string &datasetName)
It gets the index names of the given dataset.
void dropUniqueKey(const std::string &datasetName, const std::string &name)
It removes the unique key constraint from the dataset.
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.
std::unique_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,...
std::unique_ptr< te::da::PrimaryKey > getPrimaryKey(const std::string &datasetName)
It retrieves the primary key of the dataset.
std::vector< std::string > getTL4Tables()
std::string escape(const std::string &value)
It escapes a string for using in commands and queries.
void execute(const te::da::Query &command)
It executes the specified command using a generic query representation.
std::map< int, TeLayer * > & m_layerMap
Definition: Transactor.h:276
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)
void dropProperty(const std::string &datasetName, const std::string &name)
It removes a property from the given dataset.
void dropCheckConstraint(const std::string &datasetName, const std::string &name)
It removes the check constraint from the dataset.
std::size_t getNumberOfProperties(const std::string &datasetName)
It gets the number of properties of the given dataset.
void rollBack()
It aborts the transaction. Any changes will be rolled-back.
std::unique_ptr< te::dt::Property > getProperty(const std::string &datasetName, const std::string &name)
It retrieves the property with the given name from the dataset.
std::unique_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 datas...
bool primaryKeyExists(const std::string &datasetName, const std::string &name)
It checks if a primary key exists in the dataset.
TraverseType
A dataset can be traversed in two ways:
Definition: Enums.h:54
@ FORWARDONLY
Definition: Enums.h:55
AccessPolicy
Supported data access policies (can be used as bitfield).
Definition: Enums.h:41
@ RAccess
Definition: Enums.h:43
SpatialRelation
Spatial relations between geometric objects.
Definition: Enums.h:128
TerraLib.
Definition: Band.h:35
#define TETERRALIB4EXPORT
You can use this macro in order to export/import classes and functions from this module.
Definition: Config.h:123
Proxy configuration file for TerraView (see terraview_config.h).
Data Source for WS OGC WMS.