Package com.vividsolutions.jump.datastore.mariadb

Class MariadbSQLBuilder

java.lang.Object

com.vividsolutions.jump.datastore.spatialdatabases.SpatialDatabasesSQLBuilder

com.vividsolutions.jump.datastore.mariadb.MariadbSQLBuilder

public class MariadbSQLBuilder
extends SpatialDatabasesSQLBuilder

Creates SQL query strings for a Spatial database. To be overloaded by classes implementing a spatial database support.

Field Summary

Fields inherited from class com.vividsolutions.jump.datastore.spatialdatabases.SpatialDatabasesSQLBuilder

colNames, dbMetadata, defaultSRID

Constructor Summary

Constructors

Constructor	Description
MariadbSQLBuilder(SpatialDatabasesDSMetadata dsMetadata, SpatialReferenceSystemID defaultSRID, String[] colNames)

Method Summary

Modifier and Type	Method	Description
protected String	buildBoxFilter(FilterQuery query)
String	getCheckSQL(DataStoreLayer dsLayer)	Returns the query allowing to test a DataStoreLayer: builds a query with where clause and limit 0 to check where clause.
protected String	getColumnListSpecifier(String[] colNames, String geomColName)	Returns the string representing a SQL column definition.
String	getSQL(FilterQuery query)	Builds a valid SQL spatial query with the given spatial filter.

Methods inherited from class com.vividsolutions.jump.datastore.spatialdatabases.SpatialDatabasesSQLBuilder

getDbMetadata, getSRID

Methods inherited from class java.lang.Object

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

Constructor Detail

MariadbSQLBuilder

public MariadbSQLBuilder(SpatialDatabasesDSMetadata dsMetadata,
                         SpatialReferenceSystemID defaultSRID,
                         String[] colNames)

Method Detail

getSQL

public String getSQL(FilterQuery query)

Builds a valid SQL spatial query with the given spatial filter.

Overrides:

getSQL in class SpatialDatabasesSQLBuilder

Parameters:

query - a spatial filter

Returns:

the SQL query string for this spatial filter

getCheckSQL

public String getCheckSQL(DataStoreLayer dsLayer)

Returns the query allowing to test a DataStoreLayer: builds a query with where clause and limit 0 to check where clause.

Overrides:

getCheckSQL in class SpatialDatabasesSQLBuilder

Parameters:

dsLayer - a DataStoreLayer

Returns:

a SQL query forced to limit 0 to test the layer source

getColumnListSpecifier

protected String getColumnListSpecifier(String[] colNames,
                                        String geomColName)

Returns the string representing a SQL column definition. Implementors should take care of column names (case, quotes)

Overrides:

getColumnListSpecifier in class SpatialDatabasesSQLBuilder

Parameters:

colNames - array of column names

geomColName - geometry column name

Returns:

column list

buildBoxFilter

protected String buildBoxFilter(FilterQuery query)

Overrides:

buildBoxFilter in class SpatialDatabasesSQLBuilder