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

Class SQLBuilderBase.AlterTableBuilderBase

java.lang.Object
org.gvsig.expressionevaluator.ExpressionBuilder.AbstractValue
org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AbstractStatementPart
org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AbstractStatement
org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AlterTableBuilderBase
All Implemented Interfaces:
Cloneable, org.gvsig.expressionevaluator.ExpressionBuilder.Value, org.gvsig.expressionevaluator.ExpressionBuilder.Visitable, org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder, org.gvsig.fmap.dal.SQLBuilder.Statement, org.gvsig.fmap.dal.SQLBuilder.StatementPart, org.gvsig.tools.lang.Cloneable, org.gvsig.tools.util.PropertiesSupport
Enclosing class:
SQLBuilderBase
public class SQLBuilderBase.AlterTableBuilderBase extends SQLBuilderBase.AbstractStatement implements org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder

  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    protected List<org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor>
    adds
     
    protected List<org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor>
    alters
    Deprecated.
    protected String
    drop_primary_key_column
     
    protected List<String>
    drops
     
    protected List<org.apache.commons.lang3.tuple.Pair<org.gvsig.tools.util.Bitmask,org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor>>
    operations
     
    protected List<org.apache.commons.lang3.tuple.Pair<String,String>>
    renames
     
    protected final SQLBuilderBase
    sqlbuilder
     
    protected org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder
    table
     

    Fields inherited from class org.gvsig.expressionevaluator.ExpressionBuilder.AbstractValue

    properties

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

    ALTER_COLUMN_ADD_COLUMN, ALTER_COLUMN_ADD_PRIMARY_KEY, ALTER_COLUMN_ALL, ALTER_COLUMN_CREATE_INDEX, ALTER_COLUMN_DROP_COLUMN, ALTER_COLUMN_DROP_INDEX, ALTER_COLUMN_DROP_PRIMARY_KEY, ALTER_COLUMN_GEOMETRY, ALTER_COLUMN_SET_DATA_TYPE, ALTER_COLUMN_SET_DEFAULT, ALTER_COLUMN_SET_NULL

  • Constructor Summary

    Constructors
    Constructor
    Description
    AlterTableBuilderBase(SQLBuilderBase sqlbuilder)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    void
    accept(org.gvsig.expressionevaluator.ExpressionBuilder.Visitor visitor, org.gvsig.expressionevaluator.ExpressionBuilder.VisitorFilter filter)
     
    org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder
    add_column(String columnName, int type, int size, int precision, int scale, boolean isPk, boolean isIndexed, boolean allowNulls, boolean isAutomatic, Object defaultValue, boolean allowIndexDuplicateds)
     
    org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder
    add_column(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor fad)
     
    org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder
    add_geometry_column(String columnName, int type, int subtype, Object srsdbcode, boolean isIndexed, boolean allowNulls)
     
    org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder
    add_geometry_column(String columnName, int type, int subtype, org.gvsig.crs.projection.lib.Projection proj, boolean isIndexed, boolean allowNulls)
     
    org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder
    alter_column(org.gvsig.tools.util.Bitmask operation, String columnName, int type, int size, int precision, int scale, boolean isPk, boolean isIndexed, boolean allowNulls, boolean isAutomatic, Object defaultValue, boolean allowIndexDuplicateds)
     
    org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder
    alter_column(org.gvsig.tools.util.Bitmask operation, org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor fad)
     
    protected List<String>
    alter_column_add_geometry_constraint_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)
     
    org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder
    alter_geometry_column(org.gvsig.tools.util.Bitmask operation, String columnName, int type, int subtype, Object srsdbcode, boolean isIndexed, boolean allowNulls)
     
    org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder
    alter_geometry_column(org.gvsig.tools.util.Bitmask operation, String columnName, int type, int subtype, org.gvsig.crs.projection.lib.Projection proj, boolean isIndexed, boolean allowNulls)
     
    protected List<String>
    alter_table_add_column_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)
     
    protected List<String>
    alter_table_add_primarykey_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)
     
    protected List<String>
    alter_table_alter_column_rename_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, String oldName, String newName)
     
    protected List<String>
    alter_table_alter_column_set_data_type_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)
     
    protected List<String>
    alter_table_alter_column_set_default_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)
     
    protected List<String>
    alter_table_alter_column_set_null_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)
     
    protected List<String>
    alter_table_drop_column_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, String columnName)
     
    protected List<String>
    alter_table_drop_primarykey_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)
     
    protected List<String>
    create_index_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)
     
    org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder
    drop_column(String columnName)
     
    protected List<String>
    drop_index_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)
     
    org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder
    drop_primary_key(String columnName)
     
    protected String
    getConstrainName(String constrainType, String columnName)
     
    List<org.apache.commons.lang3.tuple.Pair<org.gvsig.tools.util.Bitmask,org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor>>
    getOperations()
     
    boolean
    isEmpty()
     
    org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder
    rename_column(String source, String target)
     
    org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder
    table()
     
    String
    toString()
     
    String
    toString(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter)
     
    List<String>
    toStrings()
     
    List<String>
    toStrings(org.gvsig.expressionevaluator.Formatter formatter)
     
    protected void
    update_or_add_alters(SQLBuilderBase.ColumnDescriptorBase column)
     

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

    clone

    Methods inherited from class org.gvsig.expressionevaluator.ExpressionBuilder.AbstractValue

    copyPropertiesFrom, getProperties, getProperty, replace, setProperty

    Methods inherited from class java.lang.Object

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

    Methods inherited from interface org.gvsig.expressionevaluator.ExpressionBuilder.Value

    clone, copyPropertiesFrom, replace

    Methods inherited from interface org.gvsig.tools.util.PropertiesSupport

    getProperties, getProperty, setProperty

  • Field Details

    • table

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

    • drops

      protected List<String> drops

    • adds

      protected List<org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor> adds

    • alters

      @Deprecated protected List<org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor> alters
      Deprecated.

    • operations

      protected List<org.apache.commons.lang3.tuple.Pair<org.gvsig.tools.util.Bitmask,org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor>> operations

    • renames

      protected List<org.apache.commons.lang3.tuple.Pair<String,String>> renames

    • drop_primary_key_column

      protected String drop_primary_key_column

    • sqlbuilder

      protected final SQLBuilderBase sqlbuilder

  • Constructor Details

    • AlterTableBuilderBase

      public AlterTableBuilderBase(SQLBuilderBase sqlbuilder)

  • Method Details

    • getOperations

      public List<org.apache.commons.lang3.tuple.Pair<org.gvsig.tools.util.Bitmask,org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor>> getOperations()

    • isEmpty

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

    • 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
      Overrides:
      accept in class org.gvsig.expressionevaluator.ExpressionBuilder.AbstractValue

    • table

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

    • drop_column

      public org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder drop_column(String columnName)
      Specified by:
      drop_column in interface org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder

    • drop_primary_key

      public org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder drop_primary_key(String columnName)
      Specified by:
      drop_primary_key in interface org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder

    • add_column

      public org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder add_column(org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor fad)
      Specified by:
      add_column in interface org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder

    • add_column

      public org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder add_column(String columnName, int type, int size, int precision, int scale, boolean isPk, boolean isIndexed, boolean allowNulls, boolean isAutomatic, Object defaultValue, boolean allowIndexDuplicateds)
      Specified by:
      add_column in interface org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder

    • add_geometry_column

      public org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder add_geometry_column(String columnName, int type, int subtype, org.gvsig.crs.projection.lib.Projection proj, boolean isIndexed, boolean allowNulls)
      Specified by:
      add_geometry_column in interface org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder

    • add_geometry_column

      public org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder add_geometry_column(String columnName, int type, int subtype, Object srsdbcode, boolean isIndexed, boolean allowNulls)
      Specified by:
      add_geometry_column in interface org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder

    • update_or_add_alters

      protected void update_or_add_alters(SQLBuilderBase.ColumnDescriptorBase column)

    • alter_column

      public org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder alter_column(org.gvsig.tools.util.Bitmask operation, org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor fad)
      Specified by:
      alter_column in interface org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder

    • alter_column

      public org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder alter_column(org.gvsig.tools.util.Bitmask operation, String columnName, int type, int size, int precision, int scale, boolean isPk, boolean isIndexed, boolean allowNulls, boolean isAutomatic, Object defaultValue, boolean allowIndexDuplicateds)
      Specified by:
      alter_column in interface org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder

    • alter_geometry_column

      public org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder alter_geometry_column(org.gvsig.tools.util.Bitmask operation, String columnName, int type, int subtype, org.gvsig.crs.projection.lib.Projection proj, boolean isIndexed, boolean allowNulls)
      Specified by:
      alter_geometry_column in interface org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder

    • alter_geometry_column

      public org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder alter_geometry_column(org.gvsig.tools.util.Bitmask operation, String columnName, int type, int subtype, Object srsdbcode, boolean isIndexed, boolean allowNulls)
      Specified by:
      alter_geometry_column in interface org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder

    • rename_column

      public org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder rename_column(String source, String target)
      Specified by:
      rename_column in interface org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder

    • getConstrainName

      protected String getConstrainName(String constrainType, String columnName)

    • alter_table_add_primarykey_sqls

      protected List<String> alter_table_add_primarykey_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)

    • alter_table_drop_primarykey_sqls

      protected List<String> alter_table_drop_primarykey_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)

    • create_index_sqls

      protected List<String> create_index_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)

    • drop_index_sqls

      protected List<String> drop_index_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)

    • alter_table_alter_column_set_data_type_sqls

      protected List<String> alter_table_alter_column_set_data_type_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)

    • alter_table_alter_column_set_default_sqls

      protected List<String> alter_table_alter_column_set_default_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)

    • alter_table_alter_column_set_null_sqls

      protected List<String> alter_table_alter_column_set_null_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)

    • alter_table_drop_column_sqls

      protected List<String> alter_table_drop_column_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, String columnName)

    • alter_table_add_column_sqls

      protected List<String> alter_table_add_column_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)

    • alter_table_alter_column_rename_sqls

      protected List<String> alter_table_alter_column_rename_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, String oldName, String newName)

    • alter_column_add_geometry_constraint_sqls

      protected List<String> alter_column_add_geometry_constraint_sqls(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor column)

    • toString

      public String toString()
      Overrides:
      toString in class Object

    • toString

      public String toString(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter)
      Specified by:
      toString in interface org.gvsig.expressionevaluator.ExpressionBuilder.Value

    • toStrings

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

    • toStrings

      public List<String> toStrings(org.gvsig.expressionevaluator.Formatter formatter)
      Specified by:
      toStrings in interface org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder