org.geotools.gce.imagemosaic.jdbc
Class PostgisDialect

Object
  extended by DBDialect
      extended by PostgisDialect

public class PostgisDialect
extends DBDialect

This class implements the db dialect for postgis

Author:
mcr
Module:
modules/plugin/imagemosaic-jdbc (gt-imagemosaic-jdbc.jar)

Field Summary
 
Fields inherited from class DBDialect
config, dataSource
 
Constructor Summary
PostgisDialect(Config config)
           
 
Method Summary
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
 
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


Copyright © 1996-2009 Geotools. All Rights Reserved.