Package 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:
org.gvsig.expressionevaluator.ExpressionBuilder.Visitable, org.gvsig.fmap.dal.SQLBuilder
public class PostgreSQLBuilder extends org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

  • Nested Class Summary

    Nested Classes
    Modifier and Type
    Class
    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

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

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

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

  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    protected org.gvsig.expressionevaluator.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
    Description
    PostgreSQLBuilder(org.gvsig.fmap.dal.store.jdbc2.JDBCHelper helper)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    String
    as_clob(String s)
     
    org.gvsig.fmap.dal.SQLBuilder.CreateIndexBuilder
    createCreateIndexBuilder()
     
    protected org.gvsig.fmap.dal.SQLBuilder.CreateTableBuilder
    createCreateTableBuilder()
     
    org.gvsig.fmap.dal.SQLBuilder.SelectBuilder
    createSelectBuilder()
     
    protected org.gvsig.fmap.dal.SQLBuilder.UpdateTableStatisticsBuilder
    createUpdateTableStatisticsBuilder()
     
    org.gvsig.expressionevaluator.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, column, column, column_from, column_from, 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, parameters_names, quote_for_identifiers, quote_for_strings, select, setProperties, setProperties, sqlgeometrydimension, sqlgeometrytype, sqltype, support_schemas, table_name, toString, toString, update, update_table_statistics, variables, variables_names

    Methods inherited from class java.lang.Object

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

  • Field Details

    • formatter

      protected org.gvsig.expressionevaluator.Formatter formatter

  • Constructor Details

    • PostgreSQLBuilder

      public PostgreSQLBuilder(org.gvsig.fmap.dal.store.jdbc2.JDBCHelper helper)

  • Method Details

    • getDatabaseVersion

      public PostgreSQLBuilder.Version getDatabaseVersion()

    • formatter

      public org.gvsig.expressionevaluator.Formatter formatter()
      Specified by:
      formatter in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      formatter in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • getHelper

      public PostgreSQLHelper getHelper()
      Overrides:
      getHelper in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

    • createCreateTableBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.CreateTableBuilder createCreateTableBuilder()
      Overrides:
      createCreateTableBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createCreateIndexBuilder

      public org.gvsig.fmap.dal.SQLBuilder.CreateIndexBuilder createCreateIndexBuilder()
      Overrides:
      createCreateIndexBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createSelectBuilder

      public org.gvsig.fmap.dal.SQLBuilder.SelectBuilder createSelectBuilder()
      Specified by:
      createSelectBuilder in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      createSelectBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createUpdateTableStatisticsBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.UpdateTableStatisticsBuilder createUpdateTableStatisticsBuilder()
      Overrides:
      createUpdateTableStatisticsBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • getMaxRecomendedSQLLength

      public int getMaxRecomendedSQLLength()
      Specified by:
      getMaxRecomendedSQLLength in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      getMaxRecomendedSQLLength in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • as_clob

      public String as_clob(String s)
      Specified by:
      as_clob in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      as_clob in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase