liquibase.ext.spatial.sqlgenerator

Class CreateSpatialIndexGeneratorOracle

java.lang.Object

liquibase.ext.spatial.sqlgenerator.AbstractCreateSpatialIndexGenerator

liquibase.ext.spatial.sqlgenerator.CreateSpatialIndexGeneratorOracle

public class CreateSpatialIndexGeneratorOracle
extends AbstractCreateSpatialIndexGenerator

CreateSpatialIndexGeneratorOracle generates the SQL for creating a spatial index in Oracle.

Constructor Summary

Constructors

Constructor and Description
CreateSpatialIndexGeneratorOracle()

Method Summary

Methods

Modifier and Type	Method and Description
protected String	generateCreateIndexSql(CreateSpatialIndexStatement statement, Database database) Generates the SQL for creating the spatial index.
protected String	generateDeleteMetadataSql(CreateSpatialIndexStatement statement, Database database) Generates the SQL for deleting any existing record from the USER_SDO_GEOM_METADATA table.
protected String	generateInsertMetadataSql(CreateSpatialIndexStatement statement, Database database) Generates the SQL for inserting the necessary record into the USER_SDO_GEOM_METADATA table.
Sql[]	generateSql(CreateSpatialIndexStatement statement, Database database, SqlGeneratorChain sqlGeneratorChain)
protected String	getGtype(String ogcGeometryType) Converts the OGC geometry type to Oracle's SDO_GTYPE.
protected Collection<String>	getParameters(CreateSpatialIndexStatement statement) Creates the parameters to the spatial index creation statement.
boolean	supports(CreateSpatialIndexStatement statement, Database database)

Methods inherited from class liquibase.ext.spatial.sqlgenerator.AbstractCreateSpatialIndexGenerator

getAffectedIndex, validate

Methods inherited from class java.lang.Object

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

Constructor Detail

CreateSpatialIndexGeneratorOracle

public CreateSpatialIndexGeneratorOracle()

Method Detail

supports

public boolean supports(CreateSpatialIndexStatement statement,
               Database database)

generateSql

public Sql[] generateSql(CreateSpatialIndexStatement statement,
                Database database,
                SqlGeneratorChain sqlGeneratorChain)

generateDeleteMetadataSql

protected String generateDeleteMetadataSql(CreateSpatialIndexStatement statement,
                               Database database)

Generates the SQL for deleting any existing record from the USER_SDO_GEOM_METADATA table. Typically this record shouldn't be present but we must ensure that it does not already exist.

Parameters:

statement - the create spatial index statement.

database - the database instance.

Returns:

the SQL to delete any existing metadata record.

generateInsertMetadataSql

protected String generateInsertMetadataSql(CreateSpatialIndexStatement statement,
                               Database database)

Generates the SQL for inserting the necessary record into the USER_SDO_GEOM_METADATA table. This record must be present prior to creating the spatial index.

Parameters:

statement - the create spatial index statement.

database - the database instance.

Returns:

the SQL to insert the metadata record.

generateCreateIndexSql

protected String generateCreateIndexSql(CreateSpatialIndexStatement statement,
                            Database database)

Generates the SQL for creating the spatial index.

Parameters:

statement - the create spatial index statement.

database - the database instance.

Returns:

the SQL to create a spatial index.

getParameters

protected Collection<String> getParameters(CreateSpatialIndexStatement statement)

Creates the parameters to the spatial index creation statement.

Parameters:

statement - the statement.

Returns:

the optional parameters for the CREATE INDEX statement.

getGtype

protected String getGtype(String ogcGeometryType)

Converts the OGC geometry type to Oracle's SDO_GTYPE.

Parameters:

ogcGeometryType - the OGC geometry type.

Returns:

the corresponding Oracle SDO_GTYPE.