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 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 SpatialDatabasesSQLBuilder

getDbMetadata, getSRID

Methods inherited from class Object

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

Constructor Details

MariadbSQLBuilder

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

Method Details

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