org.geotools.gce.imagemosaic.jdbc
Class PostgisDialect

java.lang.Object
  extended by org.geotools.gce.imagemosaic.jdbc.DBDialect
      extended by org.geotools.gce.imagemosaic.jdbc.PostgisDialect

public class PostgisDialect
extends DBDialect

This class implements the db dialect for postgis

Author:
mcr

Field Summary
 
Fields inherited from class org.geotools.gce.imagemosaic.jdbc.DBDialect
config, dataSource
 
Constructor Summary
PostgisDialect(Config config)
           
 
Method Summary
protected  java.lang.String getBLOBSQLType()
           
protected  java.lang.String getCreateIndexStatement(java.lang.String tn)
           
protected  java.lang.String getCreateSpatialTableStatement(java.lang.String tableName)
           
protected  java.lang.String getCreateSpatialTableStatementJoined(java.lang.String tableName)
           
protected  java.lang.String getDoubleSQLType()
           
protected  java.lang.String getMultiPolygonSQLType()
           
protected  java.lang.String getRegisterSpatialStatement(java.lang.String tn, java.lang.String srs)
           
protected  java.lang.String getUnregisterSpatialStatement(java.lang.String tn)
           
 
Methods inherited from class org.geotools.gce.imagemosaic.jdbc.DBDialect
getConfig, getConnection, getDBDialect
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

PostgisDialect

public PostgisDialect(Config config)
Method Detail

getRegisterSpatialStatement

protected java.lang.String getRegisterSpatialStatement(java.lang.String tn,
                                                       java.lang.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 java.lang.String getUnregisterSpatialStatement(java.lang.String tn)
Overrides:
getUnregisterSpatialStatement in class DBDialect
Parameters:
tn - sql table name
Returns:
sql unregister spatial column statement for nt

getCreateSpatialTableStatement

protected java.lang.String getCreateSpatialTableStatement(java.lang.String tableName)
                                                   throws java.lang.Exception
Overrides:
getCreateSpatialTableStatement in class DBDialect
Returns:
the sql create table statement for a spatial table
Throws:
java.lang.Exception

getCreateSpatialTableStatementJoined

protected java.lang.String getCreateSpatialTableStatementJoined(java.lang.String tableName)
                                                         throws java.lang.Exception
Overrides:
getCreateSpatialTableStatementJoined in class DBDialect
Returns:
the sql create table statement for a combined spatial/tile table named tableName
Throws:
java.lang.Exception

getBLOBSQLType

protected java.lang.String getBLOBSQLType()
Specified by:
getBLOBSQLType in class DBDialect
Returns:
the sql type name for a blob (Binary Large Object)

getMultiPolygonSQLType

protected java.lang.String getMultiPolygonSQLType()
Specified by:
getMultiPolygonSQLType in class DBDialect
Returns:
the sql type name for a Multipolygon

getDoubleSQLType

protected java.lang.String getDoubleSQLType()
Overrides:
getDoubleSQLType in class DBDialect
Returns:
sql datatype for 8 byte floating point

getCreateIndexStatement

protected java.lang.String getCreateIndexStatement(java.lang.String tn)
                                            throws java.lang.Exception
Specified by:
getCreateIndexStatement in class DBDialect
Parameters:
tn - sql table name
Returns:
sql create spatial index statement for tn
Throws:
java.lang.Exception


Copyright © 1996-2010 Geotools. All Rights Reserved.