org.gvsig.fmap.dal.store.h2.h2gis.functions

Class ColumnSRID

java.lang.Object

org.gvsig.fmap.dal.store.h2.functions.AbstractH2Function

org.gvsig.fmap.dal.store.h2.h2gis.functions.ColumnSRID

All Implemented Interfaces:

H2Function

public class ColumnSRID
extends AbstractH2Function
implements H2Function

Get the column SRID from constraints and data.

Author:

Nicolas Fortin

Constructor Summary

Constructors

Constructor and Description
ColumnSRID()

Method Summary

Modifier and Type	Method and Description
static java.lang.String	fetchConstraint(java.sql.Connection connection, java.lang.String catalogName, java.lang.String schemaName, java.lang.String tableName) Read table constraints from database metadata.
java.lang.String	getName()
static int	getSRID(java.sql.Connection connection, java.lang.String catalogName, java.lang.String schemaName, java.lang.String tableName, java.lang.String columnName, java.lang.String constraint)
static int	getSRIDFromConstraint(java.lang.String constraint, java.lang.String columnName)

Methods inherited from class org.gvsig.fmap.dal.store.h2.functions.AbstractH2Function

getCreateFunctionSQL, getFullname, isDeterministic

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.gvsig.fmap.dal.store.h2.functions.H2Function

getCreateFunctionSQL, getFullname, isDeterministic

Constructor Detail

ColumnSRID

public ColumnSRID()

Method Detail

fetchConstraint

public static java.lang.String fetchConstraint(java.sql.Connection connection,
                                               java.lang.String catalogName,
                                               java.lang.String schemaName,
                                               java.lang.String tableName)
                                        throws java.sql.SQLException

Read table constraints from database metadata.

Parameters:

connection - Active connection

catalogName - Catalog name or empty string

schemaName - Schema name or empty string

tableName - table name

Returns:

Found table constraints

Throws:

java.sql.SQLException

getName

public java.lang.String getName()

Specified by:

getName in interface H2Function

Overrides:

getName in class AbstractH2Function

getSRID

public static int getSRID(java.sql.Connection connection,
                          java.lang.String catalogName,
                          java.lang.String schemaName,
                          java.lang.String tableName,
                          java.lang.String columnName,
                          java.lang.String constraint)

Parameters:

connection - Active connection

tableName - Target table name

columnName - Spatial field name

constraint - Column constraint

Returns:

The column SRID from constraints and data.

getSRIDFromConstraint

public static int getSRIDFromConstraint(java.lang.String constraint,
                                        java.lang.String columnName)

Parameters:

constraint - Constraint expression ex:"ST_SRID(the_geom) = 27572"

Returns:

The SRID or 0 if no constraint are found or constraint on other column