Package com.kheops.jmap.server.datasources.egdb

Class PostgreServerHandler

java.lang.Object

com.kheops.jmap.server.datasources.egdb.EgdbHandler

com.kheops.jmap.server.datasources.egdb.PostgreServerHandler

public class PostgreServerHandler
extends EgdbHandler

Implements all needed methods to handle an Postgre database.

Field Summary

Fields inherited from class com.kheops.jmap.server.datasources.egdb.EgdbHandler

requestFID, requestOID

Constructor Summary

Constructors

Constructor	Description
PostgreServerHandler(EgdbDataSourceInfo egdbDataSourceInfo)

Method Summary

Modifier and Type	Method	Description
void	appendAttributeFilter(AttributeFilter filter, StringBuffer filterBuffer)	Append to the filter buffer a new condition using the attribute's name and attribute's value.
void	appendGeometryTypesFilter(GeometryTypesFilter filter, StringBuffer filterBuffer)	Append to the filter buffer a new condition using the geometry type.
void	appendSpatialFilter(SpatialQueryFilter filter, StringBuffer filterBuffer)	Append to the filter buffer a new condition using the method to determine relationship between geometries.
void	appendSqlFilter(SQLQueryFilter filter, StringBuffer queryBuffer, StringBuffer orderByBuffer)	Append to the filter buffer a new condition using the boundaries.
StringBuffer	buildGeometrySelectStatement(Attribute[] attributes)	Build the select statement for geometry storage type.
Geometry	decode(Object spatialData, int numofpts, int geometryType)	Method to decode a geometry
void	determineBinaryInformation(EgdbFeatureConfig featureConfig)	Set feature geometry table, indexes and spatial column name where the geometry is stored.
Object	encode(Geometry geometry)	Method to encode a JMap geometry
int	extractSridFromSpatialReference()	Extract the srid form the spatial reference table
protected String	filterExcludeRemovedElementsFromBase10()	For versioned layer, this method establishes the restriction to exclude elements that have been removed.
int	getAttributeCount(String attributeName, String queryFilter)	Method for attribute statistics.
Domain[]	getAvailableCodedValueDomains()	Return the available coded value domains if they exist, otherwise return an empty array.
String	getAvailableGeometryType()	Gets the geometry type name of the layer: ST_POINT, ST_POLYGON,...
String[]	getAvailableLayerNames()	Get all available name of the existing layers
Domain[]	getAvailableRangeDomains()	Return the available range domains if they exist, otherwise return and empty array All available domains will be returned even if they are used or not
ColumnDefinition[]	getColumnDefinition()	Method to return the definition of the all columns of the ESRI Data base.
protected String	getDbInstance(String urlConnection)	To return the instance's name of the ESRI database
String	getDefaultsStorageType()	Return an String with the defaults storage type inside the DBTUNE table.
String	getDeltaTableAdds()	The name of Delta table A (adds)
String	getDeltaTableDeletes()	The name of Delta table D (deletes)
int	getElementCount()	Return the total amount of spatial elements
Rectangle	getFeatureExtent(String queryFilter)	Return the extend of the filtered features when the storage type is SDEBINAY and as consequence a feature table must exists
EgdbFeatureProperties	getFeatureProperties()	Properties of the feature falseX, falseY, minX, minY, maxX, maxY, gSize, xyUnits, dbName
String	getFeatureTableName()	Return the name of the feature table
Rectangle	getGeometryExtent(String filter)	Return the extend of the filtered features when the storage type is GEOMETRY
String	getGeometrySpatialColumn()	To get the geometry column name of the layer.
String	getGeometrySpatialDataColumn()	When the storage type is binary then the spatial data is saved in the feature table and its attributes remain in the base table.
String	getGeometryStorageType(String key_config)
String	getIdColumn()	To get the name of the geometry identifier column name.
String	getIdentifierManagerTableName()	Return the name of the table which register the last object id value of the layer.
String	getIndexTableName()	Return the name of the spatial index table
int	getJMapAvailableGeometryType(String geometryType)	Gets the JMap geometry type of the layer
String	getLayerConfig()	Return a String with the layer configuration keyword that was specified when the layer was created e.g.
int	getLayerGeometryTypeCode(Geometry geometry)	Get the SDE geometry type code.
int	getLayerId()	Return the layer id from the layers table
int	getLayerSrid()	This method is deprecated, use extractSridFromSpatialReference() instead Return the srid from sde_spatial_references table.
long	getNextId(int requestId)	Used during the insert transaction, to generate the identifier of the new record to insert
AttributeStat	getNumericStats(String attributeName, String queryFilter)	Calculate MIN, MAX, AVG, STDEV for numeric attribute
String	getRelatedDomainName(String attributeName)	Return the domain name related to an attribute if both are related.
protected String[]	getSystemTables()	Return an array with the names of the default systems tables
int	getTableRegistryId()	Return the identifier of the base table in the SDE_table_registry table.
Hashtable<Object,Object>	getUniqueValues(String attributeName, String queryFilter)	Return the unique values to storing them
String	getVersion()	Return the version of the Enterprise GeoDataBase e.g 10.0.0 or 10.2.1
protected String	getVersionedElements10()	For versioned layer, this method establishes the restriction to exclude elements that have been removed or those elements that correspond to an old version.
void	insertElement(JMapGeoElement geoElement, EditionResult result, Attribute[] attributes)	Execute the insertion of the new geoElement.
boolean	isVersioned()	The feature is versioned or not
void	loadRelationships(Attribute attribute)	Find possible relationShips with the given attribute
EditionResult	processDeleteStatement(long elementsIds)	Delete elements from base table.
EditionResult[]	processUpdateStatement(JMapGeoElement[] elements, Attribute[] attributes)	Update elements for unversioned layers.
EditionResult	processVersionedDeleteStatement(long elementsIds)	Insert elements in delete delta tables.
EditionResult[]	processVersionedUpdateStatement(JMapGeoElement[] elements, Attribute[] attributes)	Update elements for versioned layers.
String	setupQueryFilters(QueryFilter[] queryFilters)	Build the SQL condition to apply the query filters.
protected int	toSqlType(String egdbType)	Convert an EGDB domain type to SQL type

Methods inherited from class com.kheops.jmap.server.datasources.egdb.EgdbHandler

availableSchemaNames, buildBinarySqlQuery, buildGeometrySqlQuery, buildQuery, buildVersionedGeometrySqlQuery, bytesToHex, calculateGeometryArea, calculateGeometryLength, calculateNumOfPts, checkGeodatabaseFromSchema, convertCodedValues, convertComparisonClauses, databaseSchema, existsAdditionalSystemTables, extractAttributeName, extractAttributeValues, extractLayerGeometries, filterExcludeRemovedElementsFromBase, getAttributes, getAvailableDomains, getDefaultVersionState, getEgdbDataSourceInfo, getEgdbDialect, getElementsCount, getStorageType, getVersionedElements, isGeodatabase, queryStatesFromVersion, setEgdbDataSourceInfo, setEgdbDialect, systemSchema, updateEgdbDataSourceInfo

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

PostgreServerHandler

public PostgreServerHandler(EgdbDataSourceInfo egdbDataSourceInfo)

Method Details

encode

public Object encode(Geometry geometry)
              throws SQLException

Description copied from class: EgdbHandler

Method to encode a JMap geometry

Specified by:

encode in class EgdbHandler

Throws:

SQLException

decode

public Geometry decode(Object spatialData,
 int numofpts,
 int geometryType)
                throws Exception

Description copied from class: EgdbHandler

Method to decode a geometry

Specified by:

decode in class EgdbHandler

Parameters:

spatialData - Spatial data to decode

numofpts - Valid for OGCWKB and SDEBINARY storage type. Useful only for SDEBINARY storage type. For the other storage type is null

Returns:

The decoded JMap geometry

Throws:

Exception

appendSqlFilter

public void appendSqlFilter(SQLQueryFilter filter,
 StringBuffer queryBuffer,
 StringBuffer orderByBuffer)
                     throws Exception

Description copied from class: EgdbHandler

Append to the filter buffer a new condition using the boundaries.

Specified by:

appendSqlFilter in class EgdbHandler

Throws:

Exception

appendSpatialFilter

public void appendSpatialFilter(SpatialQueryFilter filter,
 StringBuffer filterBuffer)

Description copied from class: EgdbHandler

Append to the filter buffer a new condition using the method to determine relationship between geometries.

Specified by:

appendSpatialFilter in class EgdbHandler

Parameters:

filter - Spatial relationship method between geometries.

filterBuffer - String buffer which value is the query which the filter is going to append

appendGeometryTypesFilter

public void appendGeometryTypesFilter(GeometryTypesFilter filter,
 StringBuffer filterBuffer)

Description copied from class: EgdbHandler

Append to the filter buffer a new condition using the geometry type.

Specified by:

appendGeometryTypesFilter in class EgdbHandler

Parameters:

filter - Available geometry type

filterBuffer - String buffer which value is the query which the filter is going to append.

appendAttributeFilter

public void appendAttributeFilter(AttributeFilter filter,
 StringBuffer filterBuffer)

Description copied from class: EgdbHandler

Append to the filter buffer a new condition using the attribute's name and attribute's value. The statement is build taking into account the attribute's value data type.

Specified by:

appendAttributeFilter in class EgdbHandler

Parameters:

filter - Attribute used in the condition.

filterBuffer - String buffer which value is the query which the filter is going to append.

getIdColumn

public String getIdColumn()
                   throws SQLException

Description copied from class: EgdbHandler

To get the name of the geometry identifier column name.

Specified by:

getIdColumn in class EgdbHandler

Returns:

The name of the ID column in the base table

Throws:

SQLException

getGeometrySpatialColumn

public String getGeometrySpatialColumn()
                                throws Exception

Description copied from class: EgdbHandler

To get the geometry column name of the layer.

Specified by:

getGeometrySpatialColumn in class EgdbHandler

Returns:

The name of the Geometry column in the base table

Throws:

Exception

getColumnDefinition

public ColumnDefinition[] getColumnDefinition()
                                       throws SQLException

Description copied from class: EgdbHandler

Method to return the definition of the all columns of the ESRI Data base. Every particular handler need to implement the way to get it. In the return array is included the OBJECT_ID and the SHAPE columns

Specified by:

getColumnDefinition in class EgdbHandler

Throws:

SQLException

getVersion

public String getVersion()
                  throws SQLException

Description copied from class: EgdbHandler

Return the version of the Enterprise GeoDataBase e.g 10.0.0 or 10.2.1

Specified by:

getVersion in class EgdbHandler

Throws:

SQLException - Error occurred while retrieving the version of the Enterprise GeoDatabase

getLayerConfig

public String getLayerConfig()
                      throws SQLException

Description copied from class: EgdbHandler

Return a String with the layer configuration keyword that was specified when the layer was created e.g. DEFAULTS, GEOMETRY, WKB_GEOMETRY. Other values need to be explored

Specified by:

getLayerConfig in class EgdbHandler

Throws:

SQLException - Error raised extracting the configuration of a layer

getDefaultsStorageType

public String getDefaultsStorageType()
                              throws SQLException

Description copied from class: EgdbHandler

Return an String with the defaults storage type inside the DBTUNE table. The result depends of the DBMS e.g. SQLServer: Geometry, Geography, SDEBinary, OGCWKB

Specified by:

getDefaultsStorageType in class EgdbHandler

Throws:

SQLException - Error raised extracting the default storage type

getGeometryStorageType

public String getGeometryStorageType(String key_config)
                              throws SQLException

Specified by:

getGeometryStorageType in class EgdbHandler

Throws:

SQLException - Error raised extracting the geometry storage type

getAvailableLayerNames

public String[] getAvailableLayerNames()
                                throws SQLException

Description copied from class: EgdbHandler

Get all available name of the existing layers

Specified by:

getAvailableLayerNames in class EgdbHandler

Throws:

SQLException

getDbInstance

protected String getDbInstance(String urlConnection)

Description copied from class: EgdbHandler

To return the instance's name of the ESRI database

Specified by:

getDbInstance in class EgdbHandler

getLayerId

public int getLayerId()

Description copied from class: EgdbHandler

Return the layer id from the layers table

Specified by:

getLayerId in class EgdbHandler

getFeatureTableName

public String getFeatureTableName()

Description copied from class: EgdbHandler

Return the name of the feature table

Specified by:

getFeatureTableName in class EgdbHandler

getIndexTableName

public String getIndexTableName()

Description copied from class: EgdbHandler

Return the name of the spatial index table

Specified by:

getIndexTableName in class EgdbHandler

getDeltaTableAdds

public String getDeltaTableAdds()
                         throws SQLException

Description copied from class: EgdbHandler

The name of Delta table A (adds)

Specified by:

getDeltaTableAdds in class EgdbHandler

Throws:

SQLException

getDeltaTableDeletes

public String getDeltaTableDeletes()
                            throws SQLException

Description copied from class: EgdbHandler

The name of Delta table D (deletes)

Specified by:

getDeltaTableDeletes in class EgdbHandler

Throws:

SQLException

getFeatureProperties

public EgdbFeatureProperties getFeatureProperties()
                                           throws SQLException

Description copied from class: EgdbHandler

Properties of the feature falseX, falseY, minX, minY, maxX, maxY, gSize, xyUnits, dbName

Specified by:

getFeatureProperties in class EgdbHandler

Throws:

SQLException - Raised when an exception occurs retrieving the properties of the feature

getAvailableCodedValueDomains

public Domain[] getAvailableCodedValueDomains()
                                       throws Exception

Description copied from class: EgdbHandler

Return the available coded value domains if they exist, otherwise return an empty array. All available domains will be returned even if they are used or not

Specified by:

getAvailableCodedValueDomains in class EgdbHandler

Throws:

Exception - Raised while loading the coded value domains

getAvailableRangeDomains

public Domain[] getAvailableRangeDomains()
                                  throws Exception

Description copied from class: EgdbHandler

Return the available range domains if they exist, otherwise return and empty array All available domains will be returned even if they are used or not

Specified by:

getAvailableRangeDomains in class EgdbHandler

Throws:

Exception - Raised while loading the range domains

getRelatedDomainName

public String getRelatedDomainName(String attributeName)
                            throws SQLException

Description copied from class: EgdbHandler

Return the domain name related to an attribute if both are related. Otherwise return null

Specified by:

getRelatedDomainName in class EgdbHandler

Throws:

SQLException

isVersioned

public boolean isVersioned()
                    throws SQLException

Description copied from class: EgdbHandler

The feature is versioned or not

Specified by:

isVersioned in class EgdbHandler

Throws:

SQLException - raised while retrieving the definition column of the layer

setupQueryFilters

public String setupQueryFilters(QueryFilter[] queryFilters)
                         throws Exception

Description copied from class: EgdbHandler

Build the SQL condition to apply the query filters. The method also reduce the search when storage type is SDEBinary

Specified by:

setupQueryFilters in class EgdbHandler

Throws:

Exception

getAvailableGeometryType

public String getAvailableGeometryType()
                                throws SQLException

Description copied from class: EgdbHandler

Gets the geometry type name of the layer: ST_POINT, ST_POLYGON,...

Specified by:

getAvailableGeometryType in class EgdbHandler

Returns:

ST_GEOMETRY type

Throws:

SQLException

getTableRegistryId

public int getTableRegistryId()
                       throws SQLException

Description copied from class: EgdbHandler

Return the identifier of the base table in the SDE_table_registry table. This identifier is used to find the delta tables when the layer is versioned

Specified by:

getTableRegistryId in class EgdbHandler

Throws:

SQLException - Raised when an error occurs retrieving the registry id of the layer

getGeometrySpatialDataColumn

public String getGeometrySpatialDataColumn()
                                    throws SQLException

Description copied from class: EgdbHandler

When the storage type is binary then the spatial data is saved in the feature table and its attributes remain in the base table. So it is necessary to know where to look for the geometry spatial data to extract the layer's elements.

Specified by:

getGeometrySpatialDataColumn in class EgdbHandler

Throws:

SQLException

getFeatureExtent

public Rectangle getFeatureExtent(String queryFilter)

Description copied from class: EgdbHandler

Return the extend of the filtered features when the storage type is SDEBINAY and as consequence a feature table must exists

Specified by:

getFeatureExtent in class EgdbHandler

getJMapAvailableGeometryType

public int getJMapAvailableGeometryType(String geometryType)

Description copied from class: EgdbHandler

Gets the JMap geometry type of the layer

Specified by:

getJMapAvailableGeometryType in class EgdbHandler

Returns:

ST_GEOMETRY type

getAttributeCount

public int getAttributeCount(String attributeName,
 String queryFilter)
                      throws Exception

Description copied from class: EgdbHandler

Method for attribute statistics. Calculate the distinct count of a attribute

Specified by:

getAttributeCount in class EgdbHandler

Throws:

Exception

getUniqueValues

public Hashtable<Object,Object> getUniqueValues(String attributeName,
 String queryFilter)
                                         throws Exception

Description copied from class: EgdbHandler

Return the unique values to storing them

Specified by:

getUniqueValues in class EgdbHandler

Throws:

Exception

getNumericStats

public AttributeStat getNumericStats(String attributeName,
 String queryFilter)
                              throws Exception

Description copied from class: EgdbHandler

Calculate MIN, MAX, AVG, STDEV for numeric attribute

Specified by:

getNumericStats in class EgdbHandler

Throws:

Exception

getElementCount

public int getElementCount()
                    throws SQLException

Description copied from class: EgdbHandler

Return the total amount of spatial elements

Specified by:

getElementCount in class EgdbHandler

Throws:

SQLException

getSystemTables

protected String[] getSystemTables()

Description copied from class: EgdbHandler

Return an array with the names of the default systems tables

Specified by:

getSystemTables in class EgdbHandler

determineBinaryInformation

public void determineBinaryInformation(EgdbFeatureConfig featureConfig)
                                throws SQLException

Description copied from class: EgdbHandler

Set feature geometry table, indexes and spatial column name where the geometry is stored.

Specified by:

determineBinaryInformation in class EgdbHandler

Throws:

SQLException - Raised when an error occurs extracting feature geometry table, indexes or spatial column name

extractSridFromSpatialReference

public int extractSridFromSpatialReference()
                                    throws SQLException

Description copied from class: EgdbHandler

Extract the srid form the spatial reference table

Specified by:

extractSridFromSpatialReference in class EgdbHandler

Throws:

SQLException - Error occurred while retrieving the srid of the layer

getLayerSrid

public int getLayerSrid()
                 throws Exception

Description copied from class: EgdbHandler

This method is deprecated, use extractSridFromSpatialReference() instead Return the srid from sde_spatial_references table. This value is used to work with SQLServer geo-database to extract and insert elements

Specified by:

getLayerSrid in class EgdbHandler

Throws:

Exception

getGeometryExtent

public Rectangle getGeometryExtent(String filter)
                            throws Exception

Description copied from class: EgdbHandler

Return the extend of the filtered features when the storage type is GEOMETRY

Specified by:

getGeometryExtent in class EgdbHandler

Throws:

Exception

insertElement

public void insertElement(JMapGeoElement geoElement,
 EditionResult result,
 Attribute[] attributes)
                   throws Exception

Description copied from class: EgdbHandler

Execute the insertion of the new geoElement. Prepare insertion query statement.

Specified by:

insertElement in class EgdbHandler

Parameters:

geoElement - New element to be inserted

result - Out parameter with the operation's result

Throws:

Exception

getIdentifierManagerTableName

public String getIdentifierManagerTableName()
                                     throws SQLException

Description copied from class: EgdbHandler

Return the name of the table which register the last object id value of the layer. This name is useful to identify the store procedure's name to execute and return the next objectId value. This value is going to be use into an insert statement.

Specified by:

getIdentifierManagerTableName in class EgdbHandler

Throws:

SQLException

getNextId

public long getNextId(int requestId)
               throws Exception

Description copied from class: EgdbHandler

Used during the insert transaction, to generate the identifier of the new record to insert

Specified by:

getNextId in class EgdbHandler

Returns:

The next ID available or 0 if none exists

Throws:

Exception

processDeleteStatement

public EditionResult processDeleteStatement(long elementsIds)

Description copied from class: EgdbHandler

Delete elements from base table. This method is used to delete element for unversioned layers

Specified by:

processDeleteStatement in class EgdbHandler

processVersionedDeleteStatement

public EditionResult processVersionedDeleteStatement(long elementsIds)
                                              throws Exception

Description copied from class: EgdbHandler

Insert elements in delete delta tables. This method is used to delete elements for versioned layers.

Specified by:

processVersionedDeleteStatement in class EgdbHandler

Throws:

Exception

processUpdateStatement

public EditionResult[] processUpdateStatement(JMapGeoElement[] elements,
 Attribute[] attributes)

Description copied from class: EgdbHandler

Update elements for unversioned layers.

Specified by:

processUpdateStatement in class EgdbHandler

processVersionedUpdateStatement

public EditionResult[] processVersionedUpdateStatement(JMapGeoElement[] elements,
 Attribute[] attributes)
                                                throws Exception

Description copied from class: EgdbHandler

Update elements for versioned layers.

Specified by:

processVersionedUpdateStatement in class EgdbHandler

Throws:

Exception

getLayerGeometryTypeCode

public int getLayerGeometryTypeCode(Geometry geometry)

Description copied from class: EgdbHandler

Get the SDE geometry type code. This is the code inserted in entity column when a geometry is inserted in F# table. POINT_SHAPE 1 LINE_SHAPE 2 AREA_SHAPE 8

Specified by:

getLayerGeometryTypeCode in class EgdbHandler

toSqlType

protected int toSqlType(String egdbType)

Description copied from class: EgdbHandler

Convert an EGDB domain type to SQL type

Specified by:

toSqlType in class EgdbHandler

loadRelationships

public void loadRelationships(Attribute attribute)
                       throws SQLException

Description copied from class: EgdbHandler

Find possible relationShips with the given attribute

Specified by:

loadRelationships in class EgdbHandler

Throws:

SQLException

buildGeometrySelectStatement

public StringBuffer buildGeometrySelectStatement(Attribute[] attributes)

Description copied from class: EgdbHandler

Build the select statement for geometry storage type.

Specified by:

buildGeometrySelectStatement in class EgdbHandler

getVersionedElements10

protected String getVersionedElements10()

Description copied from class: EgdbHandler

For versioned layer, this method establishes the restriction to exclude elements that have been removed or those elements that correspond to an old version. Elements from delta table 'A' which are in delta table 'D' are not included in the result. This method may change depending on DMBS because it call the function SDE_get_view_state() included on ArcGIS 10.x

Specified by:

getVersionedElements10 in class EgdbHandler

Returns:

Sql query to be used into a sql condition.

filterExcludeRemovedElementsFromBase10

protected String filterExcludeRemovedElementsFromBase10()
                                                 throws SQLException

Description copied from class: EgdbHandler

For versioned layer, this method establishes the restriction to exclude elements that have been removed. Elements from base table which are in delta table 'D' are not included in the result. This method may change depending on DMBS because it call the function SDE_get_view_state() included on ArcGIS 10.x

Specified by:

filterExcludeRemovedElementsFromBase10 in class EgdbHandler

Returns:

Sql query to be used into a sql condition.

Throws:

SQLException