Package org.gvsig.oracle.dal

Class SpatialIndexUtils

java.lang.Object

org.gvsig.oracle.dal.SpatialIndexUtils

public class SpatialIndexUtils
extends Object

Author:

fdiaz

Constructor Summary

Constructors

Constructor	Description
SpatialIndexUtils()

Method Summary

Modifier and Type	Method	Description
static String	getSpatialIndex(org.gvsig.fmap.dal.store.jdbc2.JDBCConnection connection, String schema, String table, String geomColumnName)
static String	getSpatialIndexName(String table, String geomColumn)
static String	getSQLCreateSpatialIndex(String table, String geomColumn, int geomType, int geomsubtype)
static String	getSQLDeleteUserMetadata(String schema, String table, String geomColumnName)
static String	getSQLInsertUserMetadata(String table, List<OracleDimensionMetadata> dimensions, String geomColumnName, int srid)
static String	getSQLInsertUserMetadata(String table, org.gvsig.fmap.geom.primitive.Envelope bbox, String geomColumnName, int srid)
static String	getSQLRebuildSpatialIndex(String table, String geomColumn, int geomType, int geomsubtype)
static String	getSQLUpdateUserMetadata(List<OracleDimensionMetadata> dimensions, String geomColumnName, int srid)
static boolean	isValidSpatialIndex(org.gvsig.fmap.dal.store.jdbc2.JDBCConnection connection, String table)
static void	setUpdateUserMetadata(PreparedStatement st, String table, List<OracleDimensionMetadata> dimensions, String geomColumnName, int srid)
static boolean	updateSpatialIndexAndMetadata(org.gvsig.fmap.dal.store.jdbc2.JDBCHelper helper, org.gvsig.fmap.dal.store.jdbc2.OperationsFactory.TableReference table, org.gvsig.fmap.dal.feature.FeatureType type)

Methods inherited from class java.lang.Object

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

Constructor Details

SpatialIndexUtils

public SpatialIndexUtils()

Method Details

getSpatialIndexName

public static String getSpatialIndexName(String table,
 String geomColumn)

getSpatialIndex

public static String getSpatialIndex(org.gvsig.fmap.dal.store.jdbc2.JDBCConnection connection,
 String schema,
 String table,
 String geomColumnName)

isValidSpatialIndex

public static boolean isValidSpatialIndex(org.gvsig.fmap.dal.store.jdbc2.JDBCConnection connection,
 String table)

updateSpatialIndexAndMetadata

public static boolean updateSpatialIndexAndMetadata(org.gvsig.fmap.dal.store.jdbc2.JDBCHelper helper,
 org.gvsig.fmap.dal.store.jdbc2.OperationsFactory.TableReference table,
 org.gvsig.fmap.dal.feature.FeatureType type)

getSQLInsertUserMetadata

public static String getSQLInsertUserMetadata(String table,
 org.gvsig.fmap.geom.primitive.Envelope bbox,
 String geomColumnName,
 int srid)

getSQLDeleteUserMetadata

public static String getSQLDeleteUserMetadata(String schema,
 String table,
 String geomColumnName)

getSQLInsertUserMetadata

public static String getSQLInsertUserMetadata(String table,
 List<OracleDimensionMetadata> dimensions,
 String geomColumnName,
 int srid)

getSQLCreateSpatialIndex

public static String getSQLCreateSpatialIndex(String table,
 String geomColumn,
 int geomType,
 int geomsubtype)

getSQLRebuildSpatialIndex

public static String getSQLRebuildSpatialIndex(String table,
 String geomColumn,
 int geomType,
 int geomsubtype)

getSQLUpdateUserMetadata

public static String getSQLUpdateUserMetadata(List<OracleDimensionMetadata> dimensions,
 String geomColumnName,
 int srid)

setUpdateUserMetadata

public static void setUpdateUserMetadata(PreparedStatement st,
 String table,
 List<OracleDimensionMetadata> dimensions,
 String geomColumnName,
 int srid)
                                  throws SQLException

Throws:

SQLException