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

Class TableLocation

java.lang.Object

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

public class TableLocation
extends java.lang.Object

Just a class used to split Catalog Schema and Table. Theses components are a unique table identifier.

Author:

Nicolas Fortin

Constructor Summary

Constructors

Constructor and Description
TableLocation(java.sql.ResultSet rs)
TableLocation(java.lang.String table)
TableLocation(java.lang.String schema, java.lang.String table)
TableLocation(java.lang.String catalog, java.lang.String schema, java.lang.String table)

Method Summary

Modifier and Type	Method and Description
static java.lang.String	capsIdentifier(java.lang.String identifier, java.lang.Boolean isH2Database) Change case of parameters to make it more user-friendly.
boolean	equals(java.lang.Object o)
java.lang.String	getCatalog()
java.lang.String	getCatalog(java.lang.String defaultValue)
java.lang.String	getSchema()
java.lang.String	getSchema(java.lang.String defaultValue)
java.lang.String	getTable()
int	hashCode()
static TableLocation	parse(java.lang.String concatenatedTableLocation) Convert catalog.schema.table, schema.table or table into a TableLocation instance.
static TableLocation	parse(java.lang.String concatenatedTableLocation, java.lang.Boolean isH2Database) Convert catalog.schema.table, schema.table or table into a TableLocation instance.
static java.lang.String	quoteIdentifier(java.lang.String identifier) Always Quote string for both H2 and Postgre compatibility
static java.lang.String	quoteIdentifier(java.lang.String identifier, boolean isH2DataBase) Quote identifier only if necessary.
void	setDefaultSchema(java.lang.String defaultSchema)
java.lang.String	toString()
java.lang.String	toString(boolean isH2) String representation of Table location, for insertion in SQL statement.

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Detail

TableLocation

public TableLocation(java.sql.ResultSet rs)
              throws java.sql.SQLException

Parameters:

rs - result set obtained through DatabaseMetaData.getTables(String, String, String, String[])

Throws:

java.sql.SQLException

TableLocation

public TableLocation(java.lang.String table)

Parameters:

table - Table name without quotes

TableLocation

public TableLocation(java.lang.String schema,
                     java.lang.String table)

Parameters:

schema - Schema name without quotes

table - Table name without quotes

TableLocation

public TableLocation(java.lang.String catalog,
                     java.lang.String schema,
                     java.lang.String table)

Parameters:

catalog - Catalog name without quotes

schema - Schema name without quotes

table - Table name without quotes

Method Detail

capsIdentifier

public static java.lang.String capsIdentifier(java.lang.String identifier,
                                              java.lang.Boolean isH2Database)

Change case of parameters to make it more user-friendly.

Parameters:

identifier - Table, Catalog, Schema, or column name

isH2Database - True if H2, False if PostGreSQL, null if unknown

Returns:

Upper or lower case version of identifier

equals

public boolean equals(java.lang.Object o)

Overrides:

equals in class java.lang.Object

getCatalog

public java.lang.String getCatalog()

Returns:

Table catalog name (database)

getCatalog

public java.lang.String getCatalog(java.lang.String defaultValue)

Parameters:

defaultValue - Return this value if this attribute is not defined.

Returns:

Table catalog name (database)

getSchema

public java.lang.String getSchema()

Returns:

Table schema name

getSchema

public java.lang.String getSchema(java.lang.String defaultValue)

Parameters:

defaultValue - Return this value if this attribute is not defined.

Returns:

Table schema name

getTable

public java.lang.String getTable()

Returns:

Table name

hashCode

public int hashCode()

Overrides:

hashCode in class java.lang.Object

parse

public static TableLocation parse(java.lang.String concatenatedTableLocation)

Convert catalog.schema.table, schema.table or table into a TableLocation instance. Non-specified schema or catalogs are converted to the empty string.

Parameters:

concatenatedTableLocation - Table location [[Catalog.]Schema.]Table

Returns:

Java beans for table location

parse

public static TableLocation parse(java.lang.String concatenatedTableLocation,
                                  java.lang.Boolean isH2Database)

Convert catalog.schema.table, schema.table or table into a TableLocation instance. Non-specified schema or catalogs are converted to the empty string.

Parameters:

concatenatedTableLocation - Table location [[Catalog.]Schema.]Table

isH2Database - True if H2, False if PostGreSQL, null if unknown

Returns:

Java beans for table location

quoteIdentifier

public static java.lang.String quoteIdentifier(java.lang.String identifier)

Always Quote string for both H2 and Postgre compatibility

Parameters:

identifier - Catalog,Schema,Table or Field name

Returns:

Quoted Identifier

quoteIdentifier

public static java.lang.String quoteIdentifier(java.lang.String identifier,
                                               boolean isH2DataBase)

Quote identifier only if necessary. Require database knowledge.

Parameters:

identifier - Catalog,Schema,Table or Field name

isH2DataBase - True if the quote is for H2, false if for POSTGRE

Returns:

Quoted Identifier

setDefaultSchema

public void setDefaultSchema(java.lang.String defaultSchema)

Parameters:

defaultSchema - Default connection schema, used for table location equality test.

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

toString

public java.lang.String toString(boolean isH2)

String representation of Table location, for insertion in SQL statement. This function try to do not quote unnecessary components; require database type.

Parameters:

isH2 - True if H2, false if

Returns:

String representation of Table location