GDAL
ogr_gensql.h
1/******************************************************************************
2 * $Id$
3 *
4 * Project: OpenGIS Simple Features Reference Implementation
5 * Purpose: Classes related to generic implementation of ExecuteSQL().
6 * Author: Frank Warmerdam, warmerdam@pobox.com
7 *
8 ******************************************************************************
9 * Copyright (c) 2002, Frank Warmerdam
10 * Copyright (c) 2010-2013, Even Rouault <even dot rouault at spatialys.com>
11 *
12 * Permission is hereby granted, free of charge, to any person obtaining a
13 * copy of this software and associated documentation files (the "Software"),
14 * to deal in the Software without restriction, including without limitation
15 * the rights to use, copy, modify, merge, publish, distribute, sublicense,
16 * and/or sell copies of the Software, and to permit persons to whom the
17 * Software is furnished to do so, subject to the following conditions:
18 *
19 * The above copyright notice and this permission notice shall be included
20 * in all copies or substantial portions of the Software.
21 *
22 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS
23 * OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
24 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL
25 * THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
26 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
27 * FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
28 * DEALINGS IN THE SOFTWARE.
29 ****************************************************************************/
30
31#ifndef OGR_GENSQL_H_INCLUDED
32#define OGR_GENSQL_H_INCLUDED
33
34#include "ogrsf_frmts.h"
35#include "ogr_swq.h"
36#include "cpl_hash_set.h"
37#include "cpl_string.h"
38
39#include <vector>
40
43#define GEOM_FIELD_INDEX_TO_ALL_FIELD_INDEX(poFDefn, iGeom) \
44 ((poFDefn)->GetFieldCount() + SPECIAL_FIELD_COUNT + (iGeom))
45
46#define IS_GEOM_FIELD_INDEX(poFDefn, idx) \
47 (((idx) >= (poFDefn)->GetFieldCount() + SPECIAL_FIELD_COUNT) && \
48 ((idx) < (poFDefn)->GetFieldCount() + SPECIAL_FIELD_COUNT + \
49 (poFDefn)->GetGeomFieldCount()))
50
51#define ALL_FIELD_INDEX_TO_GEOM_FIELD_INDEX(poFDefn, idx) \
52 ((idx) - ((poFDefn)->GetFieldCount() + SPECIAL_FIELD_COUNT))
53
54/************************************************************************/
55/* OGRGenSQLResultsLayer */
56/************************************************************************/
57
58class OGRGenSQLResultsLayer final : public OGRLayer
59{
60 private:
61 GDALDataset *poSrcDS;
62 OGRLayer *poSrcLayer;
63 void *pSelectInfo;
64
65 char *pszWHERE;
66
67 OGRLayer **papoTableLayers;
68
69 OGRFeatureDefn *poDefn;
70
71 int *panGeomFieldToSrcGeomField;
72
73 size_t nIndexSize;
74 GIntBig *panFIDIndex;
75 int bOrderByValid;
76
77 GIntBig nNextIndexFID;
78 OGRFeature *poSummaryFeature;
79
80 int iFIDFieldIndex;
81
82 int nExtraDSCount;
83 GDALDataset **papoExtraDS;
84
85 GIntBig nIteratedFeatures;
86 std::vector<CPLString> m_oDistinctList;
87
88 int PrepareSummary();
89
90 OGRFeature *TranslateFeature(OGRFeature *);
91 void CreateOrderByIndex();
92 void ReadIndexFields(OGRFeature *poSrcFeat, int nOrderItems,
93 OGRField *pasIndexFields);
94 void SortIndexSection(const OGRField *pasIndexFields, GIntBig *panMerged,
95 size_t nStart, size_t nEntries);
96 void FreeIndexFields(OGRField *pasIndexFields, size_t l_nIndexSize,
97 bool bFreeArray = true);
98 int Compare(const OGRField *pasFirst, const OGRField *pasSecond);
99
100 void ClearFilters();
101 void ApplyFiltersToSource();
102
103 void FindAndSetIgnoredFields();
104 void ExploreExprForIgnoredFields(swq_expr_node *expr, CPLHashSet *hSet);
105 void AddFieldDefnToSet(int iTable, int iColumn, CPLHashSet *hSet);
106
107 int ContainGeomSpecialField(swq_expr_node *expr);
108
109 void InvalidateOrderByIndex();
110
111 int MustEvaluateSpatialFilterOnGenSQL();
112
113 CPL_DISALLOW_COPY_ASSIGN(OGRGenSQLResultsLayer)
114
115 public:
116 OGRGenSQLResultsLayer(GDALDataset *poSrcDS, void *pSelectInfo,
117 OGRGeometry *poSpatFilter, const char *pszWHERE,
118 const char *pszDialect);
119 virtual ~OGRGenSQLResultsLayer();
120
121 virtual OGRGeometry *GetSpatialFilter() override;
122
123 virtual void ResetReading() override;
124 virtual OGRFeature *GetNextFeature() override;
125 virtual OGRErr SetNextByIndex(GIntBig nIndex) override;
126 virtual OGRFeature *GetFeature(GIntBig nFID) override;
127
128 virtual OGRFeatureDefn *GetLayerDefn() override;
129
130 virtual GIntBig GetFeatureCount(int bForce = TRUE) override;
131 virtual OGRErr GetExtent(OGREnvelope *psExtent, int bForce = TRUE) override
132 {
133 return GetExtent(0, psExtent, bForce);
134 }
135 virtual OGRErr GetExtent(int iGeomField, OGREnvelope *psExtent,
136 int bForce = TRUE) override;
137
138 virtual int TestCapability(const char *) override;
139
140 virtual void SetSpatialFilter(OGRGeometry *poGeom) override
141 {
142 SetSpatialFilter(0, poGeom);
143 }
144 virtual void SetSpatialFilter(int iGeomField, OGRGeometry *) override;
145 virtual OGRErr SetAttributeFilter(const char *) override;
146};
147
150#endif /* ndef OGR_GENSQL_H_INCLUDED */
A set of associated raster bands, usually from one file.
Definition gdal_priv.h:348
Simple container for a bounding region (rectangle)
Definition ogr_core.h:58
Definition of a feature class or feature layer.
Definition ogr_feature.h:364
A simple feature, including geometry and attributes.
Definition ogr_feature.h:497
Abstract base class for all geometry classes.
Definition ogr_geometry.h:335
This class represents a layer of simple features, with access methods.
Definition ogrsf_frmts.h:73
virtual void SetSpatialFilter(OGRGeometry *)
Set a new spatial filter.
Definition ogrlayer.cpp:1204
virtual GIntBig GetFeatureCount(int bForce=TRUE)
Fetch the feature count in this layer.
Definition ogrlayer.cpp:178
virtual OGRErr GetExtent(OGREnvelope *psExtent, int bForce=TRUE)
Fetch the extent of this layer.
Definition ogrlayer.cpp:216
virtual OGRFeature * GetNextFeature()=0
Fetch the next available feature from this layer.
virtual OGRFeatureDefn * GetLayerDefn()=0
Fetch the schema information for this layer.
virtual void ResetReading()=0
Reset feature reading to start on the first feature.
virtual OGRErr SetNextByIndex(GIntBig nIndex)
Move read cursor to the nIndex'th feature in the current resultset.
Definition ogrlayer.cpp:506
virtual OGRErr SetAttributeFilter(const char *)
Set a new attribute query.
Definition ogrlayer.cpp:345
virtual OGRFeature * GetFeature(GIntBig nFID)
Fetch a feature by its identifier.
Definition ogrlayer.cpp:452
virtual OGRGeometry * GetSpatialFilter()
This method returns the current spatial filter for this layer.
Definition ogrlayer.cpp:1176
virtual int TestCapability(const char *)=0
Test if this layer supported the named capability.
Hash set implementation.
struct _CPLHashSet CPLHashSet
Opaque type for a hash set.
Definition cpl_hash_set.h:52
#define CPL_DISALLOW_COPY_ASSIGN(ClassName)
Helper to remove the copy and assignment constructors so that the compiler will not generate the defa...
Definition cpl_port.h:1049
long long GIntBig
Large signed integer type (generally 64-bit integer type).
Definition cpl_port.h:233
Various convenience functions for working with strings and string lists.
int OGRErr
Type for a OGR error.
Definition ogr_core.h:378
Classes related to registration of format support, and opening datasets.
OGRFeature field attribute value union.
Definition ogr_core.h:866