31 #ifndef OGR_GENSQL_H_INCLUDED
32 #define OGR_GENSQL_H_INCLUDED
43 #define GEOM_FIELD_INDEX_TO_ALL_FIELD_INDEX(poFDefn, iGeom) \
44 ((poFDefn)->GetFieldCount() + SPECIAL_FIELD_COUNT + (iGeom))
46 #define IS_GEOM_FIELD_INDEX(poFDefn, idx) \
47 (((idx) >= (poFDefn)->GetFieldCount() + SPECIAL_FIELD_COUNT) && \
48 ((idx) < (poFDefn)->GetFieldCount() + SPECIAL_FIELD_COUNT + (poFDefn)->GetGeomFieldCount()))
50 #define ALL_FIELD_INDEX_TO_GEOM_FIELD_INDEX(poFDefn, idx) \
51 ((idx) - ((poFDefn)->GetFieldCount() + SPECIAL_FIELD_COUNT))
57 class OGRGenSQLResultsLayer final:
public OGRLayer
70 int *panGeomFieldToSrcGeomField;
82 GDALDataset **papoExtraDS;
85 std::vector<CPLString> m_oDistinctList;
90 void CreateOrderByIndex();
94 void SortIndexSection(
const OGRField *pasIndexFields,
96 size_t nStart,
size_t nEntries );
97 void FreeIndexFields(
OGRField *pasIndexFields,
99 bool bFreeArray =
true);
103 void ApplyFiltersToSource();
105 void FindAndSetIgnoredFields();
106 void ExploreExprForIgnoredFields(swq_expr_node* expr,
CPLHashSet* hSet);
107 void AddFieldDefnToSet(
int iTable,
int iColumn,
CPLHashSet* hSet);
109 int ContainGeomSpecialField(swq_expr_node* expr);
111 void InvalidateOrderByIndex();
113 int MustEvaluateSpatialFilterOnGenSQL();
118 OGRGenSQLResultsLayer( GDALDataset *poSrcDS,
121 const char *pszWHERE,
122 const char *pszDialect );
123 virtual ~OGRGenSQLResultsLayer();
135 virtual OGRErr GetExtent(OGREnvelope *psExtent,
int bForce = TRUE)
override {
return GetExtent(0, psExtent, bForce); }
136 virtual OGRErr GetExtent(
int iGeomField, OGREnvelope *psExtent,
int bForce = TRUE)
override;
void SetAxisMappingStrategy(OSRAxisMappingStrategy)
Set the data axis to CRS axis mapping strategy.
Definition: ogrspatialreference.cpp:10635
double GetPrimeMeridian(char **) const CPL_WARN_DEPRECATED("Use GetPrimeMeridian( const char**) instead")
Fetch prime meridian info.
Definition: ogrspatialreference.cpp:2765
void DestroyChild(int)
Definition: ogr_srsnode.cpp:322
#define SRS_PP_CENTRAL_MERIDIAN
Definition: ogr_srs_api.h:247
unsigned long CPLHashSetHashPointer(const void *elt)
Definition: cpl_hash_set.cpp:514
int GetEPSGGeogCS() const
Definition: ogr_fromepsg.cpp:301
const char * CPLGetLastErrorMsg(void)
Definition: cpl_error.cpp:866
virtual OGRErr SetFID(GIntBig nFIDIn)
Set the feature identifier.
Definition: ogrfeature.cpp:5440
int OGR_RawField_IsNull(const OGRField *)
Returns whether a raw field is null.
Definition: ogrfeature.cpp:6963
void SetNativeMediaType(const char *pszNativeMediaType)
Sets the native media type for the feature.
Definition: ogrfeature.cpp:6890
void Release()
Decrements the reference count by one, and destroy if zero.
Definition: ogrspatialreference.cpp:931
char * CPLEscapeString(const char *pszString, int nLength, int nScheme)
Definition: cpl_string.cpp:2036
virtual OGRFeature * GetNextFeature() CPL_WARN_UNUSED_RESULT=0
Fetch the next available feature from this layer.
virtual void ResetReading()=0
Reset feature reading to start on the first feature.
@ OFSTBoolean
Definition: ogr_core.h:626
CPLSTRING_METHOD_DLL CPLString & Printf(const char *pszFormat,...)
Definition: cplstring.cpp:59
const char * GetAuthorityCode(const char *pszTargetKey) const
Get the authority code for a node.
Definition: ogrspatialreference.cpp:7381
#define VSI_REALLOC_VERBOSE(pOldPtr, nNewSize)
Definition: cpl_vsi.h:288
CPLHashSet * CPLHashSetNew(CPLHashSetHashFunc fnHashFunc, CPLHashSetEqualFunc fnEqualFunc, CPLHashSetFreeEltFunc fnFreeEltFunc)
Definition: cpl_hash_set.cpp:91
@ wkbMultiPolygon
Definition: ogr_core.h:329
const char * GetAttrValue(const char *, int=0) const
Fetch indicated attribute of named node.
Definition: ogrspatialreference.cpp:1099
void * CPLCalloc(size_t, size_t)
Definition: cpl_conv.cpp:138
static OGRGeometry * FromHandle(OGRGeometryH hGeom)
Definition: ogr_geometry.h:517
int GetWidth() const
Get the formatting width for this field.
Definition: ogr_feature.h:127
OGRGeometryH OGR_G_ForceToMultiLineString(OGRGeometryH) CPL_WARN_UNUSED_RESULT
Convert to multilinestring.
Definition: ogrgeometryfactory.cpp:1295
Definition: ogr_spatialref.h:156
virtual GIntBig GetFeatureCount(int bForce=TRUE)
Fetch the feature count in this layer.
Definition: ogrlayer.cpp:173
OGRErr OSRAutoIdentifyEPSG(OGRSpatialReferenceH hSRS)
Set EPSG authority info if possible.
Definition: ogr_fromepsg.cpp:514
const char * GetFieldAsString(int i) const
Fetch field value as a string.
Definition: ogrfeature.cpp:2297
@ OFTDateTime
Definition: ogr_core.h:607
double GetNormProjParm(const char *, double=0.0, OGRErr *=nullptr) const
Fetch a normalized projection parameter value.
Definition: ogrspatialreference.cpp:4952
Definition: ogr_geometry.h:286
OGRErr SetLinearUnits(const char *pszName, double dfInMeters)
Set the linear units for the projection.
Definition: ogrspatialreference.cpp:2255
OGRGeomFieldDefn * GetGeomFieldDefnRef(int iField)
Fetch definition for this geometry field.
Definition: ogr_feature.h:582
Definition: ogrsf_frmts.h:70
Convenient string class based on std::string.
Definition: cpl_string.h:329
int IsProjected() const
Check if projected coordinate system.
Definition: ogrspatialreference.cpp:7642
int GetPrecision() const
Get the formatting precision for this field. This should normally be zero for fields of types other t...
Definition: ogr_feature.h:130
virtual OGRGeometry * GetSpatialFilter()
This method returns the current spatial filter for this layer.
Definition: ogrlayer.cpp:1085
void SetNativeData(const char *pszNativeData)
Sets the native data for the feature.
Definition: ogrfeature.cpp:6834
void * CPLRealloc(void *, size_t)
Definition: cpl_conv.cpp:225
virtual void SetSpatialFilter(OGRGeometry *)
Set a new spatial filter.
Definition: ogrlayer.cpp:1113
const char * GetNameRef() const
Fetch name of this field.
Definition: ogr_feature.h:203
#define OLCFastFeatureCount
Definition: ogr_core.h:756
int GetUTMZone(int *pbNorth=nullptr) const
Get utm zone information.
Definition: ogrspatialreference.cpp:7024
#define CPL_FRMT_GIB
Definition: cpl_port.h:316
#define EQUAL(a, b)
Definition: cpl_port.h:569
const char * GetNameRef() const
Fetch name of this field.
Definition: ogr_feature.h:113
virtual OGRFeatureDefn * GetLayerDefn()=0
Fetch the schema information for this layer.
virtual OGRFieldDefn * GetFieldDefn(int i)
Fetch field definition.
Definition: ogrfeaturedefn.cpp:330
OGRErr SetStatePlane(int nZone, int bNAD83=TRUE, const char *pszOverrideUnitName=nullptr, double dfOverrideUnit=0.0)
Set State Plane projection definition.
Definition: ogr_fromepsg.cpp:151
#define wkbFlatten(x)
Definition: ogr_core.h:440
const char * GetAuthorityName(const char *pszTargetKey) const
Get the authority name for a node.
Definition: ogrspatialreference.cpp:7465
int OGR_RawField_IsUnset(const OGRField *)
Returns whether a raw field is unset.
Definition: ogrfeature.cpp:6942
#define CPLAssert(expr)
Definition: cpl_error.h:186
int CPLHashSetInsert(CPLHashSet *set, void *elt)
Definition: cpl_hash_set.cpp:355
void SetField(int i, int nValue)
Set field to integer value.
Definition: ogrfeature.cpp:3415
#define OGRERR_UNSUPPORTED_SRS
Definition: ogr_core.h:299
#define SRS_PP_SCALE_FACTOR
Definition: ogr_srs_api.h:249
#define CPLES_SQL
Definition: cpl_string.h:173
void * OGRSpatialReferenceH
Definition: ogr_api.h:74
virtual OGRSpatialReference * GetSpatialRef() const
Fetch spatial reference system of this field.
Definition: ogrgeomfielddefn.cpp:438
virtual OGRFeature * GetFeature(GIntBig nFID) CPL_WARN_UNUSED_RESULT
Fetch a feature by its identifier.
Definition: ogrlayer.cpp:447
Definition: ogr_core.h:683
OGRFeatureDefn * GetDefnRef()
Fetch feature definition.
Definition: ogr_feature.h:571
virtual OGRGeomFieldDefn * GetGeomFieldDefn(int i)
Fetch geometry field definition.
Definition: ogrfeaturedefn.cpp:681
@ OAMS_TRADITIONAL_GIS_ORDER
Definition: ogr_srs_api.h:653
virtual const char * GetStyleString() const
Fetch style string for this feature.
Definition: ogrfeature.cpp:6117
virtual int GetFieldCount() const
Fetch number of fields on this feature.
Definition: ogrfeaturedefn.cpp:286
unsigned long long GUIntBig
Definition: cpl_port.h:251
void CPLHashSetDestroy(CPLHashSet *set)
Definition: cpl_hash_set.cpp:207
#define SRS_PP_LATITUDE_OF_ORIGIN
Definition: ogr_srs_api.h:263
#define CPLE_OpenFailed
Definition: cpl_error.h:105
#define VALIDATE_POINTER1(ptr, func, rc)
Definition: cpl_error.h:276
#define OGRERR_FAILURE
Definition: ogr_core.h:298
@ OFTString
Definition: ogr_core.h:600
void Clear()
Wipe current definition.
Definition: ogrspatialreference.cpp:790
void CPLDebug(const char *, const char *,...)
Definition: cpl_error.cpp:602
virtual OGRErr GetExtent(OGREnvelope *psExtent, int bForce=TRUE) CPL_WARN_UNUSED_RESULT
Fetch the extent of this layer.
Definition: ogrlayer.cpp:211
Definition: ogr_feature.h:92
virtual void SetStyleString(const char *)
Set feature style string.
Definition: ogrfeature.cpp:6169
@ OFTInteger
Definition: ogr_core.h:596
double GetFieldAsDouble(int i) const
Fetch field value as a double.
Definition: ogrfeature.cpp:2116
#define OLMD_FID64
Definition: ogr_core.h:791
void * CPLMalloc(size_t)
Definition: cpl_conv.cpp:168
#define SRS_PT_POLAR_STEREOGRAPHIC
Definition: ogr_srs_api.h:164
@ wkbNone
Definition: ogr_core.h:349
int CPLHashSetEqualPointer(const void *elt1, const void *elt2)
Definition: cpl_hash_set.cpp:533
OGRGeometryH OGR_G_ForceToLineString(OGRGeometryH) CPL_WARN_UNUSED_RESULT
Convert to line string.
Definition: ogrgeometryfactory.cpp:4214
@ wkbPolygon
Definition: ogr_core.h:324
#define SRS_UL_METER
Definition: ogr_srs_api.h:314
const char * CPLSPrintf(const char *fmt,...)
Definition: cpl_string.cpp:977
@ OFSTNone
Definition: ogr_core.h:624
OGRErr importFromEPSG(int)
Initialize SRS based on EPSG geographic, projected or vertical CRS code.
Definition: ogrspatialreference.cpp:10220
void CPLError(CPLErr eErrClass, CPLErrorNum err_no, const char *fmt,...)
Definition: cpl_error.cpp:308
Definition: ogr_feature.h:182
void VSIFree(void *)
Definition: cpl_vsisimple.cpp:827
double GetLinearUnits(char **) const CPL_WARN_DEPRECATED("Use GetLinearUnits( const char**) instead")
Fetch linear projection units.
Definition: ogrspatialreference.cpp:2430
@ OFTTime
Definition: ogr_core.h:606
OGRFieldType GetType() const
Fetch type of this field.
Definition: ogr_feature.h:115
bool IsFieldSetAndNotNull(int iField) const
Test if a field is set and not null.
Definition: ogrfeature.cpp:1583
int OGRErr
Definition: ogr_core.h:290
OGRErr SetAuthority(const char *pszTargetKey, const char *pszAuthority, int nCode)
Set the authority for a node.
Definition: ogrspatialreference.cpp:7245
Definition: cpl_hash_set.cpp:40
void CSLDestroy(char **papszStrList)
Definition: cpl_string.cpp:200
long long GIntBig
Definition: cpl_port.h:248
const OGRFieldDefn * GetFieldDefnRef(int iField) const
Fetch definition for this field.
Definition: ogr_feature.h:602
#define VSI_MALLOC_VERBOSE(size)
Definition: cpl_vsi.h:268
OGRwkbGeometryType
Definition: ogr_core.h:317
#define SRS_PP_FALSE_EASTING
Definition: ogr_srs_api.h:265
OGRField * GetRawFieldRef(int i)
Fetch a pointer to the internal field value given the index.
Definition: ogr_feature.h:619
#define OLCRandomRead
Definition: ogr_core.h:752
@ OFTDate
Definition: ogr_core.h:605
Definition: ogr_feature.h:354
OGRwkbGeometryType GetType() const
Fetch geometry type of this field.
Definition: ogr_feature.h:205
const char * GetNativeMediaType() const
Returns the native media type for the feature.
Definition: ogr_feature.h:746
OGRErr SetGeomField(int iField, const OGRGeometry *)
Set feature geometry of a specified geometry field.
Definition: ogrfeature.cpp:880
#define OLCFastGetExtent
Definition: ogr_core.h:757
int FindChild(const char *) const
Definition: ogr_srsnode.cpp:354
#define SRS_UL_US_FOOT_CONV
Definition: ogr_srs_api.h:322
@ wkbGeometryCollection
Definition: ogr_core.h:330
OGRFieldType
Definition: ogr_core.h:594
virtual int GetGeomFieldCount() const
Fetch number of geometry fields on this feature.
Definition: ogrfeaturedefn.cpp:632
OGRGeometryH OGR_G_ForceToMultiPolygon(OGRGeometryH) CPL_WARN_UNUSED_RESULT
Convert to multipolygon.
Definition: ogrgeometryfactory.cpp:963
virtual OGRErr SetNextByIndex(GIntBig nIndex)
Move read cursor to the nIndex'th feature in the current resultset.
Definition: ogrlayer.cpp:499
OGR_SRSNode * GetAttrNode(const char *)
Find named node in tree.
Definition: ogrspatialreference.cpp:1019
virtual OGRErr SetIgnoredFields(const char **papszFields)
Set which fields can be omitted when retrieving features from the layer.
Definition: ogrlayer.cpp:1792
char ** CSLAddString(char **papszStrList, const char *pszNewString)
Definition: cpl_string.cpp:83
@ OFTInteger64
Definition: ogr_core.h:608
GIntBig GetFieldAsInteger64(int i) const
Fetch field value as integer 64 bit.
Definition: ogrfeature.cpp:1998
int GetFieldAsInteger(int i) const
Fetch field value as integer.
Definition: ogrfeature.cpp:1859
#define OGRERR_NONE
Definition: ogr_core.h:292
char * CPLStrdup(const char *)
Definition: cpl_conv.cpp:293
Definition: ogr_feature.h:259
double CPLAtof(const char *)
Definition: cpl_strtod.cpp:117
Definition: ogr_spatialref.h:66
virtual OGRErr SetAttributeFilter(const char *)
Set a new attribute query.
Definition: ogrlayer.cpp:338
#define OLCFastSetNextByIndex
Definition: ogr_core.h:764
@ wkbLineString
Definition: ogr_core.h:322
OGRGeometry * GetGeomFieldRef(int iField)
Fetch pointer to feature geometry.
Definition: ogrfeature.cpp:666
@ wkbMultiLineString
Definition: ogr_core.h:328
OGRErr OSRSetStatePlaneWithUnits(OGRSpatialReferenceH hSRS, int nZone, int bNAD83, const char *pszOverrideUnitName, double dfOverrideUnit)
Set State Plane projection definition.
Definition: ogr_fromepsg.cpp:275
virtual int TestCapability(const char *)=0
Test if this layer supported the named capability.
OGRErr AutoIdentifyEPSG()
Set EPSG authority info if possible.
Definition: ogr_fromepsg.cpp:398
#define SRS_PP_FALSE_NORTHING
Definition: ogr_srs_api.h:267
@ OFTReal
Definition: ogr_core.h:598
OGRErr SetLocalCS(const char *)
Set the user visible LOCAL_CS name.
Definition: ogrspatialreference.cpp:4305
OGRFieldSubType GetSubType() const
Fetch subtype of this field.
Definition: ogr_feature.h:119
double GetProjParm(const char *, double=0.0, OGRErr *=nullptr) const
Fetch a projection parameter value.
Definition: ogrspatialreference.cpp:4879
OGRErr OSRSetStatePlane(OGRSpatialReferenceH hSRS, int nZone, int bNAD83)
Set State Plane projection definition.
Definition: ogr_fromepsg.cpp:256
int IsGeographic() const
Check if geographic coordinate system.
Definition: ogrspatialreference.cpp:7760
#define CPLFree
Definition: cpl_conv.h:81
@ wkbUnknown
Definition: ogr_core.h:319
#define CPL_DISALLOW_COPY_ASSIGN(ClassName)
Definition: cpl_port.h:997
OGRErr SetNormProjParm(const char *, double)
Set a projection parameter with a normalized value.
Definition: ogrspatialreference.cpp:5018
const char * GetNativeData() const
Returns the native data for the feature.
Definition: ogr_feature.h:745
void * CPLHashSetLookup(CPLHashSet *set, const void *elt)
Definition: cpl_hash_set.cpp:405
GIntBig GetFID() const
Get feature identifier.
Definition: ogr_feature.h:712
OGRGeometryH OGR_G_ForceToPolygon(OGRGeometryH) CPL_WARN_UNUSED_RESULT
Convert to polygon.
Definition: ogrgeometryfactory.cpp:793
static OGRGeometryH ToHandle(OGRGeometry *poGeom)
Definition: ogr_geometry.h:511
#define CPLE_AppDefined
Definition: cpl_error.h:99
#define SRS_UL_US_FOOT
Definition: ogr_srs_api.h:320
Generated for GDAL by
1.8.17.