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 
39 class TeView;
40 class TeAbstractTheme;
41 class TeLayer;
42 
43 namespace te
44 {
45  namespace dt { class Property; }
46  namespace gm { class Envelope; class Geometry; }
47 }
48 
49 namespace 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,
80  const te::common::AccessPolicy accessPolicy = te::common::RAccess);
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,
88  const te::common::AccessPolicy accessPolicy = te::common::RAccess);
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,
96  const te::common::AccessPolicy accessPolicy = te::common::RAccess);
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 
213  void addSequence(te::da::Sequence* sequence);
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 
225  bool hasDataSets();
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,
240  te::da::DataSet* d,
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.
std::unique_ptr< te::da::ForeignKey > getForeignKey(const std::string &datasetName, const std::string &name)
It retrieves the foreign key from the given dataset.
TeTheme * getTL4Theme(const ::terralib4::ThemeInfo &theme)
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::vector< std::string > getPropertyNames(const std::string &datasetName)
It gets the property names of the given dataset.
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.
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 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.
void dropIndex(const std::string &datasetName, const std::string &idxName)
It removes the index from the dataset schema.
std::vector< std::string > getSequenceNames()
It gets the sequence names available in the data source.
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....
bool hasDataSets()
It checks if the data source has any 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<::terralib4::ThemeInfo > getTL4Themes()
boost::ptr_vector< te::dt::Property > getProperties(const std::string &datasetName)
It retrieves the properties of the dataset.
std::vector< std::string > getIndexNames(const std::string &datasetName)
It gets the index names of the given dataset.
std::size_t getNumberOfDataSets()
It retrieves the number of data sets available in the data source.
DataSource * m_ds
Definition: Transactor.h:272
std::vector< std::pair< std::string, std::string > > getTL4RasterFiles()
boost::int64_t getLastGeneratedId()
It returns the last id generated by an insertion command.
TeDatabase * m_db
Definition: Transactor.h:273
bool indexExists(const std::string &datasetName, const std::string &name)
It checks if an index with the given name exists in the dataset.
std::unique_ptr< te::da::Sequence > getSequence(const std::string &name)
It gets the sequence with the given name in the data source.
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...
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.
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.
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.
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::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.
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)
std::vector< std::string > getDataSetNames()
It It gets the dataset names available in the data source.
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.
std::unique_ptr< te::da::BatchExecutor > getBatchExecutor()
It creates a batch command executor.
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
te::da::DataSource * getDataSource() const
It returns the parent data source of the transactor.
void renameDataSet(const std::string &name, const std::string &newName)
It renames a dataset.
std::vector< std::string > getTL4Layers()
bool isPropertyNameValid(const std::string &propertyName)
It checks if the given property name is valid.
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::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...
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::PreparedQuery > getPrepared(const std::string &qName=std::string(""))
It creates a prepared query object that may be used for query commands (select, insert,...
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::vector< std::string > getUniqueKeyNames(const std::string &datasetName)
It gets the unique key names of the given dataset.
std::vector< std::string > getTL4Tables()
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.
std::vector< std::string > getCheckConstraintNames(const std::string &datasetName)
It gets the check constraint names of the given dataset.
std::map< int, TeAbstractTheme * > & m_themeMap
Definition: Transactor.h:278
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.
Transactor(DataSource *ds, TeDatabase *db)
void dropPrimaryKey(const std::string &datasetName)
It removes the primary key constraint from the dataset schema.
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::gm::Envelope > getExtent(const std::string &datasetName, const std::string &propertyName)
It retrieves the bounding rectangle of the spatial property for 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::vector< std::string > getTL4Rasters()
std::string escape(const std::string &value)
It escapes a string for using in commands and queries.
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.
std::vector< std::string > getForeignKeyNames(const std::string &datasetName)
It gets the foreign key names of the given dataset.
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
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.
std::unique_ptr< te::da::DataSetType > getDataSetType(const std::string &name)
It gets information about the given dataset.
void rollBack()
It aborts the transaction. Any changes will be rolled-back.
std::unique_ptr< te::da::PrimaryKey > getPrimaryKey(const std::string &datasetName)
It retrieves the primary key of the dataset.
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.