org.geotools.gce.imagemosaic.jdbc

Class PostgisDialect

Object

DBDialect

PostgisDialect

public class PostgisDialect
extends DBDialect

This class implements the db dialect for postgis

Author:

mcr

Field Summary

Fields inherited from class DBDialect

config, dataSource

Constructor Summary

Constructors

Constructor and Description
PostgisDialect(Config config)

Method Summary

Modifier and Type	Method and Description
protected String	getBLOBSQLType()
protected String	getCreateIndexStatement(String tn)
protected String	getCreateSpatialTableStatement(String tableName)
protected String	getCreateSpatialTableStatementJoined(String tableName)
protected String	getDoubleSQLType()
protected String	getMultiPolygonSQLType()
protected String	getRegisterSpatialStatement(String tn, String srs)
protected String	getUnregisterSpatialStatement(String tn)

Methods inherited from class DBDialect

getConfig, getConnection, getDBDialect

Methods inherited from class Object

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

Constructor Detail

PostgisDialect

public PostgisDialect(Config config)

Method Detail

getRegisterSpatialStatement

protected String getRegisterSpatialStatement(String tn,
                                             String srs)

Overrides:

getRegisterSpatialStatement in class DBDialect

Parameters:

tn - sql table name

srs - name of spatial reference system to use

Returns:

sql unregister spatial column statement for nt

getUnregisterSpatialStatement

protected String getUnregisterSpatialStatement(String tn)

Overrides:

getUnregisterSpatialStatement in class DBDialect

Parameters:

tn - sql table name

Returns:

sql unregister spatial column statement for nt

getCreateSpatialTableStatement

protected String getCreateSpatialTableStatement(String tableName)
                                         throws Exception

Overrides:

getCreateSpatialTableStatement in class DBDialect

Returns:

the sql create table statement for a spatial table

Throws:

Exception

getCreateSpatialTableStatementJoined

protected String getCreateSpatialTableStatementJoined(String tableName)
                                               throws Exception

Overrides:

getCreateSpatialTableStatementJoined in class DBDialect

Returns:

the sql create table statement for a combined spatial/tile table named tableName

Throws:

Exception

getBLOBSQLType

protected String getBLOBSQLType()

Specified by:

getBLOBSQLType in class DBDialect

Returns:

the sql type name for a blob (Binary Large Object)

getMultiPolygonSQLType

protected String getMultiPolygonSQLType()

Specified by:

getMultiPolygonSQLType in class DBDialect

Returns:

the sql type name for a Multipolygon

getDoubleSQLType

protected String getDoubleSQLType()

Overrides:

getDoubleSQLType in class DBDialect

Returns:

sql datatype for 8 byte floating point

getCreateIndexStatement

protected String getCreateIndexStatement(String tn)
                                  throws Exception

Specified by:

getCreateIndexStatement in class DBDialect

Parameters:

tn - sql table name

Returns:

sql create spatial index statement for tn

Throws:

Exception