org.gvsig.postgresql.dal

Class PostgreSQLBuilder

java.lang.Object

org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

org.gvsig.postgresql.dal.PostgreSQLBuilder

All Implemented Interfaces:

ExpressionBuilder.Visitable, SQLBuilder

public class PostgreSQLBuilder
extends JDBCSQLBuilderBase

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected class	PostgreSQLBuilder.PostgreSQLCreateIndexBuilder
protected class	PostgreSQLBuilder.PostgreSQLCreateTableBuilder
class	PostgreSQLBuilder.PostgreSQLSelectBuilderBase
class	PostgreSQLBuilder.PostgreSQLUpdateTableStatisticsBuilderBase
static class	PostgreSQLBuilder.Version

Nested classes/interfaces inherited from class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

SQLBuilderBase.AbstractStatement, SQLBuilderBase.AbstractStatementPart, SQLBuilderBase.AlterTableBuilderBase, SQLBuilderBase.ColumnBase, SQLBuilderBase.ColumnDescriptorBase, SQLBuilderBase.CountBuilderBase, SQLBuilderBase.CreateIndexBuilderBase, SQLBuilderBase.CreateTableBuilderBase, SQLBuilderBase.DeleteBuilderBase, SQLBuilderBase.DropIndexBuilderBase, SQLBuilderBase.DropTableBuilderBase, SQLBuilderBase.FromBuilderBase, SQLBuilderBase.GrantBuilderBase, SQLBuilderBase.GrantRoleBuilderBase, SQLBuilderBase.InsertBuilderBase, SQLBuilderBase.InsertColumnBuilderBase, SQLBuilderBase.JoinBase, SQLBuilderBase.MergeBuilderBase, SQLBuilderBase.OrderByBuilderBase, SQLBuilderBase.SelectBuilderBase, SQLBuilderBase.SelectColumnBuilderBase, SQLBuilderBase.TableNameBuilderBase, SQLBuilderBase.UpdateBuilderBase, SQLBuilderBase.UpdateColumnBuilderBase, SQLBuilderBase.UpdateTableStatisticsBuilderBase

Nested classes/interfaces inherited from interface org.gvsig.fmap.dal.SQLBuilder

SQLBuilder.AlterTableBuilder, SQLBuilder.Column, SQLBuilder.ColumnDescriptor, SQLBuilder.CountBuilder, SQLBuilder.CreateIndexBuilder, SQLBuilder.CreateTableBuilder, SQLBuilder.DeleteBuilder, SQLBuilder.DropIndexBuilder, SQLBuilder.DropTableBuilder, SQLBuilder.FromBuilder, SQLBuilder.GrantBuilder, SQLBuilder.GrantRoleBuilder, SQLBuilder.InsertBuilder, SQLBuilder.InsertColumnBuilder, SQLBuilder.JoinBuilder, SQLBuilder.MergeBuilder, SQLBuilder.OrderByBuilder, SQLBuilder.Privilege, SQLBuilder.SelectBuilder, SQLBuilder.SelectColumnBuilder, SQLBuilder.Statement, SQLBuilder.StatementPart, SQLBuilder.TableNameBuilder, SQLBuilder.UpdateBuilder, SQLBuilder.UpdateColumnBuilder, SQLBuilder.UpdateTableStatisticsBuilder

Field Summary

Fields

Modifier and Type	Field and Description
protected Formatter	formatter

Fields inherited from class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

helper

Fields inherited from class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

aggregateFunctionNames, allowAutomaticValues, alter_table, constant_false, constant_true, create_index, create_table, defaultSchema, delete, drop_index, drop_table, expressionBuilder, geometrySupportType, grant, hasSpatialFunctions, insert, LOGGER, merge, select, STMT_DELETE_FROM_table, STMT_DELETE_FROM_table_WHERE_expresion, STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_schema_table, STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_table, STMT_DROP_TABLE_table, STMT_GRANT_privileges_ON_table_TO_role, STMT_INSERT_INTO_table_columns_VALUES_values, STMT_MERGE_INTO_table_KEY_column_columns_VALUES_values, STMT_UPDATE_table_SET_columnsAndValues, STMT_UPDATE_table_SET_columnsAndValues_WHERE_expresion, STMT_UPDATE_TABLE_STATISTICS_table, supportSchemas, table_name, type_boolean, type_byte, type_bytearray, type_char, type_date, type_decimal_p, type_decimal_ps, type_double, type_FILE, type_float, type_FOLDER, type_geometry, type_int, type_long, type_string, type_string_0, type_string_p, type_time, type_timestamp, type_URI, type_URL, type_version, update, update_table_statistics

Fields inherited from interface org.gvsig.fmap.dal.SQLBuilder

DEFAULT_RECOMENDED_SQL_LENGTH, FEATURE_ATTRIBUTE_DESCRIPTOR, PROP_ADD_TABLE_NAME_TO_COLUMNS, PROP_FEATURE_TYPE, PROP_JDBCHELPER, PROP_QUERY, PROP_SQLBUILDER, PROP_SYMBOLTABLE, PROP_TABLE, PROP_TABLENAME

Constructor Summary

Constructors

Constructor and Description
PostgreSQLBuilder(JDBCHelper helper)

Method Summary

Modifier and Type	Method and Description
java.lang.String	as_clob(java.lang.String s)
SQLBuilder.CreateIndexBuilder	createCreateIndexBuilder()
protected SQLBuilder.CreateTableBuilder	createCreateTableBuilder()
SQLBuilder.SelectBuilder	createSelectBuilder()
protected SQLBuilder.UpdateTableStatisticsBuilder	createUpdateTableStatisticsBuilder()
Formatter	formatter()
PostgreSQLBuilder.Version	getDatabaseVersion()
PostgreSQLHelper	getHelper()
int	getMaxRecomendedSQLLength()

Methods inherited from class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

debug_setStatementParameters, forceGeometryType, getGeometryManager, getNativeBytes, getParameters, getParameters, setParameters, setParameters, setParameters, setStatementParameters, setStatementParameters, setStatementValue, srs_id

Methods inherited from class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

accept, alter_table, as_identifier, as_string, as_string, as_string, as_string, as_string, column_from, column_from, column, column, column, count, create_index, create_table, createAlterTableBuilder, createDeleteBuilder, createDropIndexBuilder, createDropTableBuilder, createExpressionBuilder, createFromBuilder, createGrantBuilder, createGrantRoleBuilder, createInsertBuilder, createInsertColumnBuilder, createJoin, createMergeBuilder, createOrderByBuilder, createSelectColumnBuilder, createTableNameBuilder, createUpdateBuilder, createUpdateColumnBuilder, default_schema, delete, drop_index, drop_table, expression, geometry_support_type, getConstrainName, grant, has_spatial_functions, insert, isAggregateFunction, merge, parameters_names, parameters, quote_for_identifiers, quote_for_strings, select, setProperties, setProperties, sqlgeometrydimension, sqlgeometrytype, sqltype, support_schemas, table_name, toString, toString, update_table_statistics, update, variables_names, variables

Methods inherited from class java.lang.Object

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

Field Detail

formatter

protected Formatter formatter

Constructor Detail

PostgreSQLBuilder

public PostgreSQLBuilder(JDBCHelper helper)

Method Detail

getDatabaseVersion

public PostgreSQLBuilder.Version getDatabaseVersion()

formatter

public Formatter formatter()

Specified by:

formatter in interface SQLBuilder

Overrides:

formatter in class SQLBuilderBase

getHelper

public PostgreSQLHelper getHelper()

Overrides:

getHelper in class JDBCSQLBuilderBase

createCreateTableBuilder

protected SQLBuilder.CreateTableBuilder createCreateTableBuilder()

Overrides:

createCreateTableBuilder in class SQLBuilderBase

createCreateIndexBuilder

public SQLBuilder.CreateIndexBuilder createCreateIndexBuilder()

Overrides:

createCreateIndexBuilder in class SQLBuilderBase

createSelectBuilder

public SQLBuilder.SelectBuilder createSelectBuilder()

Specified by:

createSelectBuilder in interface SQLBuilder

Overrides:

createSelectBuilder in class SQLBuilderBase

createUpdateTableStatisticsBuilder

protected SQLBuilder.UpdateTableStatisticsBuilder createUpdateTableStatisticsBuilder()

Overrides:

createUpdateTableStatisticsBuilder in class SQLBuilderBase

getMaxRecomendedSQLLength

public int getMaxRecomendedSQLLength()

Specified by:

getMaxRecomendedSQLLength in interface SQLBuilder

Overrides:

getMaxRecomendedSQLLength in class SQLBuilderBase

as_clob

public java.lang.String as_clob(java.lang.String s)

Specified by:

as_clob in interface SQLBuilder

Overrides:

as_clob in class SQLBuilderBase