Package org.gvsig.fmap.dal.feature.spi

Class SQLBuilderBase

java.lang.Object
org.gvsig.fmap.dal.feature.spi.SQLBuilderBase
All Implemented Interfaces:
org.gvsig.expressionevaluator.ExpressionBuilder.Visitable, org.gvsig.fmap.dal.SQLBuilder
public class SQLBuilderBase extends Object implements org.gvsig.fmap.dal.SQLBuilder

  • Field Details

    • LOGGER

      protected static final org.slf4j.Logger LOGGER

    • select

      protected org.gvsig.fmap.dal.SQLBuilder.SelectBuilder select

    • update

      protected org.gvsig.fmap.dal.SQLBuilder.UpdateBuilder update

    • merge

      protected org.gvsig.fmap.dal.SQLBuilder.MergeBuilder merge

    • insert

      protected org.gvsig.fmap.dal.SQLBuilder.InsertBuilder insert

    • delete

      protected org.gvsig.fmap.dal.SQLBuilder.DeleteBuilder delete

    • alter_table

      protected org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder alter_table

    • create_table

      protected org.gvsig.fmap.dal.SQLBuilder.CreateTableBuilder create_table

    • grant

      protected org.gvsig.fmap.dal.SQLBuilder.GrantBuilder grant

    • drop_table

      protected org.gvsig.fmap.dal.SQLBuilder.DropTableBuilder drop_table

    • update_table_statistics

      protected org.gvsig.fmap.dal.SQLBuilder.UpdateTableStatisticsBuilder update_table_statistics

    • create_index

      protected org.gvsig.fmap.dal.SQLBuilder.CreateIndexBuilder create_index

    • drop_index

      protected org.gvsig.fmap.dal.SQLBuilder.DropIndexBuilder drop_index

    • table_name

      protected org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder table_name

    • expressionBuilder

      protected org.gvsig.expressionevaluator.GeometryExpressionBuilder expressionBuilder

    • defaultSchema

      protected String defaultSchema

    • supportSchemas

      protected boolean supportSchemas

    • hasSpatialFunctions

      protected boolean hasSpatialFunctions

    • geometrySupportType

      protected org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType geometrySupportType

    • allowAutomaticValues

      protected boolean allowAutomaticValues

    • constant_true

      protected String constant_true

    • constant_false

      protected String constant_false

    • type_boolean

      protected String type_boolean

    • type_byte

      protected String type_byte

    • type_bytearray

      protected String type_bytearray

    • type_geometry

      protected String type_geometry

    • type_char

      protected String type_char

    • type_date

      protected String type_date

    • type_double

      protected String type_double

    • type_decimal_ps

      protected String type_decimal_ps

    • type_decimal_p

      protected String type_decimal_p

    • type_float

      protected String type_float

    • type_int

      protected String type_int

    • type_long

      protected String type_long

    • type_string

      protected String type_string

    • type_string_0

      protected String type_string_0

    • type_string_p

      protected String type_string_p

    • type_time

      protected String type_time

    • type_timestamp

      protected String type_timestamp

    • type_version

      protected String type_version

    • type_URI

      protected String type_URI

    • type_URL

      protected String type_URL

    • type_FILE

      protected String type_FILE

    • type_FOLDER

      protected String type_FOLDER

    • STMT_DELETE_FROM_table_WHERE_expresion

      protected String STMT_DELETE_FROM_table_WHERE_expresion

    • STMT_DELETE_FROM_table

      protected String STMT_DELETE_FROM_table

    • STMT_INSERT_INTO_table_columns_VALUES_values

      protected String STMT_INSERT_INTO_table_columns_VALUES_values

    • STMT_MERGE_INTO_table_KEY_column_columns_VALUES_values

      protected String STMT_MERGE_INTO_table_KEY_column_columns_VALUES_values

    • STMT_UPDATE_TABLE_STATISTICS_table

      protected String STMT_UPDATE_TABLE_STATISTICS_table

    • STMT_DROP_TABLE_table

      protected String STMT_DROP_TABLE_table

    • STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_schema_table

      protected String STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_schema_table

    • STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_table

      protected String STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_table

    • STMT_UPDATE_table_SET_columnsAndValues_WHERE_expresion

      protected String STMT_UPDATE_table_SET_columnsAndValues_WHERE_expresion

    • STMT_UPDATE_table_SET_columnsAndValues

      protected String STMT_UPDATE_table_SET_columnsAndValues

    • STMT_GRANT_privileges_ON_table_TO_role

      protected String STMT_GRANT_privileges_ON_table_TO_role

    • aggregateFunctionNames

      protected String[] aggregateFunctionNames

  • Constructor Details

    • SQLBuilderBase

      public SQLBuilderBase()

  • Method Details

    • setProperties

      public void setProperties(Class filter, Object... values)
      Specified by:
      setProperties in interface org.gvsig.fmap.dal.SQLBuilder

    • setProperties

      public void setProperties(org.gvsig.expressionevaluator.ExpressionBuilder.Visitable visitable, Class filter, Object... values)
      Specified by:
      setProperties in interface org.gvsig.fmap.dal.SQLBuilder

    • quote_for_identifiers

      public String quote_for_identifiers()

    • quote_for_strings

      public String quote_for_strings()

    • as_identifier

      public String as_identifier(String id)
      Specified by:
      as_identifier in interface org.gvsig.fmap.dal.SQLBuilder

    • as_clob

      public String as_clob(String s)
      Specified by:
      as_clob in interface org.gvsig.fmap.dal.SQLBuilder

    • as_string

      public String as_string(String s)
      Specified by:
      as_string in interface org.gvsig.fmap.dal.SQLBuilder

    • as_string

      public String as_string(byte[] data)
      Specified by:
      as_string in interface org.gvsig.fmap.dal.SQLBuilder

    • as_string

      public String as_string(boolean value)
      Specified by:
      as_string in interface org.gvsig.fmap.dal.SQLBuilder

    • as_string

      public String as_string(Number value)
      Specified by:
      as_string in interface org.gvsig.fmap.dal.SQLBuilder

    • as_string

      public String as_string(Object value)
      Specified by:
      as_string in interface org.gvsig.fmap.dal.SQLBuilder

    • expression

      public org.gvsig.expressionevaluator.GeometryExpressionBuilder expression()
      Specified by:
      expression in interface org.gvsig.fmap.dal.SQLBuilder

    • has_spatial_functions

      public boolean has_spatial_functions()
      Specified by:
      has_spatial_functions in interface org.gvsig.fmap.dal.SQLBuilder

    • geometry_support_type

      public org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType geometry_support_type()
      Specified by:
      geometry_support_type in interface org.gvsig.fmap.dal.SQLBuilder

    • createExpressionBuilder

      protected org.gvsig.expressionevaluator.GeometryExpressionBuilder createExpressionBuilder()

    • srs_id

      public Object srs_id(org.gvsig.crs.projection.lib.Projection projection)
      Specified by:
      srs_id in interface org.gvsig.fmap.dal.SQLBuilder

    • default_schema

      public String default_schema()
      Specified by:
      default_schema in interface org.gvsig.fmap.dal.SQLBuilder

    • support_schemas

      public boolean support_schemas()
      Specified by:
      support_schemas in interface org.gvsig.fmap.dal.SQLBuilder

    • sqltype

      public String sqltype(int type, int size, int precision, int scale, int geomType, int geomSubtype)
      Specified by:
      sqltype in interface org.gvsig.fmap.dal.SQLBuilder

    • sqlgeometrytype

      public Object sqlgeometrytype(int type, int subtype)
      Specified by:
      sqlgeometrytype in interface org.gvsig.fmap.dal.SQLBuilder

    • sqlgeometrydimension

      public Object sqlgeometrydimension(int type, int subtype)
      Specified by:
      sqlgeometrydimension in interface org.gvsig.fmap.dal.SQLBuilder

    • column

      public org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder column()
      Specified by:
      column in interface org.gvsig.fmap.dal.SQLBuilder

    • createTableNameBuilder

      public org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder createTableNameBuilder()
      Specified by:
      createTableNameBuilder in interface org.gvsig.fmap.dal.SQLBuilder

    • createSelectColumnBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder createSelectColumnBuilder()

    • createUpdateColumnBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.UpdateColumnBuilder createUpdateColumnBuilder()

    • createInsertColumnBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.InsertColumnBuilder createInsertColumnBuilder()

    • createOrderByBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.OrderByBuilder createOrderByBuilder()

    • createFromBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.FromBuilder createFromBuilder()

    • createSelectBuilder

      public org.gvsig.fmap.dal.SQLBuilder.SelectBuilder createSelectBuilder()
      Specified by:
      createSelectBuilder in interface org.gvsig.fmap.dal.SQLBuilder

    • createUpdateBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.UpdateBuilder createUpdateBuilder()

    • createDeleteBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.DeleteBuilder createDeleteBuilder()

    • createGrantBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.GrantBuilder createGrantBuilder()

    • createGrantRoleBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.GrantRoleBuilder createGrantRoleBuilder(org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder table, String role)

    • createDropTableBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.DropTableBuilder createDropTableBuilder()

    • createCreateTableBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.CreateTableBuilder createCreateTableBuilder()

    • createAlterTableBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder createAlterTableBuilder()

    • createInsertBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.InsertBuilder createInsertBuilder()

    • createMergeBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.MergeBuilder createMergeBuilder()

    • createUpdateTableStatisticsBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.UpdateTableStatisticsBuilder createUpdateTableStatisticsBuilder()

    • createCreateIndexBuilder

      public org.gvsig.fmap.dal.SQLBuilder.CreateIndexBuilder createCreateIndexBuilder()

    • createDropIndexBuilder

      public org.gvsig.fmap.dal.SQLBuilder.DropIndexBuilder createDropIndexBuilder()

    • select

      public org.gvsig.fmap.dal.SQLBuilder.SelectBuilder select()
      Specified by:
      select in interface org.gvsig.fmap.dal.SQLBuilder

    • update

      public org.gvsig.fmap.dal.SQLBuilder.UpdateBuilder update()
      Specified by:
      update in interface org.gvsig.fmap.dal.SQLBuilder

    • update_table_statistics

      public org.gvsig.fmap.dal.SQLBuilder.UpdateTableStatisticsBuilder update_table_statistics()
      Specified by:
      update_table_statistics in interface org.gvsig.fmap.dal.SQLBuilder

    • drop_table

      public org.gvsig.fmap.dal.SQLBuilder.DropTableBuilder drop_table()
      Specified by:
      drop_table in interface org.gvsig.fmap.dal.SQLBuilder

    • create_index

      public org.gvsig.fmap.dal.SQLBuilder.CreateIndexBuilder create_index()
      Specified by:
      create_index in interface org.gvsig.fmap.dal.SQLBuilder

    • drop_index

      public org.gvsig.fmap.dal.SQLBuilder.DropIndexBuilder drop_index()
      Specified by:
      drop_index in interface org.gvsig.fmap.dal.SQLBuilder

    • delete

      public org.gvsig.fmap.dal.SQLBuilder.DeleteBuilder delete()
      Specified by:
      delete in interface org.gvsig.fmap.dal.SQLBuilder

    • insert

      public org.gvsig.fmap.dal.SQLBuilder.InsertBuilder insert()
      Specified by:
      insert in interface org.gvsig.fmap.dal.SQLBuilder

    • merge

      public org.gvsig.fmap.dal.SQLBuilder.MergeBuilder merge()
      Specified by:
      merge in interface org.gvsig.fmap.dal.SQLBuilder

    • table_name

      public org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder table_name()
      Specified by:
      table_name in interface org.gvsig.fmap.dal.SQLBuilder

    • alter_table

      public org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder alter_table()
      Specified by:
      alter_table in interface org.gvsig.fmap.dal.SQLBuilder

    • create_table

      public org.gvsig.fmap.dal.SQLBuilder.CreateTableBuilder create_table()
      Specified by:
      create_table in interface org.gvsig.fmap.dal.SQLBuilder

    • grant

      public org.gvsig.fmap.dal.SQLBuilder.GrantBuilder grant()
      Specified by:
      grant in interface org.gvsig.fmap.dal.SQLBuilder

    • column

      public org.gvsig.fmap.dal.SQLBuilder.Column column(String name)
      Specified by:
      column in interface org.gvsig.fmap.dal.SQLBuilder

    • column

      public org.gvsig.fmap.dal.SQLBuilder.Column column(org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder table, String name)
      Specified by:
      column in interface org.gvsig.fmap.dal.SQLBuilder

    • column_from

      public org.gvsig.fmap.dal.SQLBuilder.Column column_from(org.gvsig.expressionevaluator.ExpressionBuilder.Variable variable)
      Specified by:
      column_from in interface org.gvsig.fmap.dal.SQLBuilder

    • column_from

      public org.gvsig.fmap.dal.SQLBuilder.Column column_from(org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder table, org.gvsig.expressionevaluator.ExpressionBuilder.Variable variable)
      Specified by:
      column_from in interface org.gvsig.fmap.dal.SQLBuilder

    • createJoin

      protected SQLBuilderBase.JoinBase createJoin(String type, org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder table, org.gvsig.expressionevaluator.ExpressionBuilder.Value expression)

    • accept

      public void accept(org.gvsig.expressionevaluator.ExpressionBuilder.Visitor visitor, org.gvsig.expressionevaluator.ExpressionBuilder.VisitorFilter filter)
      Specified by:
      accept in interface org.gvsig.expressionevaluator.ExpressionBuilder.Visitable

    • formatter

      public org.gvsig.expressionevaluator.Formatter formatter()
      Specified by:
      formatter in interface org.gvsig.fmap.dal.SQLBuilder

    • toString

      public String toString()
      Overrides:
      toString in class Object

    • toString

      public String toString(org.gvsig.expressionevaluator.Formatter formatter)
      Specified by:
      toString in interface org.gvsig.fmap.dal.SQLBuilder

    • count

      public org.gvsig.fmap.dal.SQLBuilder.CountBuilder count()
      Specified by:
      count in interface org.gvsig.fmap.dal.SQLBuilder

    • parameters

      public List<org.gvsig.expressionevaluator.ExpressionBuilder.Parameter> parameters()
      Specified by:
      parameters in interface org.gvsig.fmap.dal.SQLBuilder

    • variables

      public List<org.gvsig.expressionevaluator.ExpressionBuilder.Variable> variables()
      Specified by:
      variables in interface org.gvsig.fmap.dal.SQLBuilder

    • parameters_names

      public List<String> parameters_names()
      Specified by:
      parameters_names in interface org.gvsig.fmap.dal.SQLBuilder

    • variables_names

      public List<String> variables_names()
      Specified by:
      variables_names in interface org.gvsig.fmap.dal.SQLBuilder

    • isAggregateFunction

      public boolean isAggregateFunction(String funcname)
      Specified by:
      isAggregateFunction in interface org.gvsig.fmap.dal.SQLBuilder

    • getMaxRecomendedSQLLength

      public int getMaxRecomendedSQLLength()
      Specified by:
      getMaxRecomendedSQLLength in interface org.gvsig.fmap.dal.SQLBuilder

    • getConstrainName

      public String getConstrainName(org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder table, String columnName, String constrainType)
      Specified by:
      getConstrainName in interface org.gvsig.fmap.dal.SQLBuilder