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:

java.lang.Cloneable, ExpressionBuilder.Value, ExpressionBuilder.Visitable, SQLBuilder.AlterTableBuilder, SQLBuilder.Statement, SQLBuilder.StatementPart, PropertiesSupport

Direct Known Subclasses:

H2SpatialSQLBuilder.H2SpatialAlterTableBuilderBase, MDBSQLBuilder.MDBAlterTableBuilderBase, SQLiteSQLBuilder.SQLiteAlterTableBuilder

Enclosing class:

SQLBuilderBase

public class SQLBuilderBase.AlterTableBuilderBase
extends SQLBuilderBase.AbstractStatement
implements SQLBuilder.AlterTableBuilder

Field Summary

Fields

Modifier and Type	Field and Description
protected java.util.List<SQLBuilder.ColumnDescriptor>	adds
protected java.util.List<SQLBuilder.ColumnDescriptor>	alters Deprecated.
protected java.lang.String	drop_primary_key_column
protected java.util.List<java.lang.String>	drops
protected java.util.List<<any>>	operations
protected java.util.List<<any>>	renames
protected SQLBuilderBase	sqlbuilder
protected 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 and Description
AlterTableBuilderBase(SQLBuilderBase sqlbuilder)

Method Summary

Modifier and Type	Method and Description
void	accept(ExpressionBuilder.Visitor visitor, ExpressionBuilder.VisitorFilter filter)
SQLBuilder.AlterTableBuilder	add_column(FeatureAttributeDescriptor fad)
SQLBuilder.AlterTableBuilder	add_column(java.lang.String columnName, int type, int size, int precision, int scale, boolean isPk, boolean isIndexed, boolean allowNulls, boolean isAutomatic, java.lang.Object defaultValue, boolean allowIndexDuplicateds)
SQLBuilder.AlterTableBuilder	add_geometry_column(java.lang.String columnName, int type, int subtype, IProjection proj, boolean isIndexed, boolean allowNulls)
SQLBuilder.AlterTableBuilder	add_geometry_column(java.lang.String columnName, int type, int subtype, java.lang.Object srsdbcode, boolean isIndexed, boolean allowNulls)
protected java.util.List<java.lang.String>	alter_column_add_geometry_constraint_sqls(Formatter<ExpressionBuilder.Value> formatter, SQLBuilder.ColumnDescriptor column)
SQLBuilder.AlterTableBuilder	alter_column(Bitmask operation, FeatureAttributeDescriptor fad)
SQLBuilder.AlterTableBuilder	alter_column(Bitmask operation, java.lang.String columnName, int type, int size, int precision, int scale, boolean isPk, boolean isIndexed, boolean allowNulls, boolean isAutomatic, java.lang.Object defaultValue, boolean allowIndexDuplicateds)
SQLBuilder.AlterTableBuilder	alter_geometry_column(Bitmask operation, java.lang.String columnName, int type, int subtype, IProjection proj, boolean isIndexed, boolean allowNulls)
SQLBuilder.AlterTableBuilder	alter_geometry_column(Bitmask operation, java.lang.String columnName, int type, int subtype, java.lang.Object srsdbcode, boolean isIndexed, boolean allowNulls)
protected java.util.List<java.lang.String>	alter_table_add_column_sqls(Formatter<ExpressionBuilder.Value> formatter, SQLBuilder.ColumnDescriptor column)
protected java.util.List<java.lang.String>	alter_table_add_primarykey_sqls(Formatter<ExpressionBuilder.Value> formatter, SQLBuilder.ColumnDescriptor column)
protected java.util.List<java.lang.String>	alter_table_alter_column_rename_sqls(Formatter<ExpressionBuilder.Value> formatter, java.lang.String oldName, java.lang.String newName)
protected java.util.List<java.lang.String>	alter_table_alter_column_set_data_type_sqls(Formatter<ExpressionBuilder.Value> formatter, SQLBuilder.ColumnDescriptor column)
protected java.util.List<java.lang.String>	alter_table_alter_column_set_default_sqls(Formatter<ExpressionBuilder.Value> formatter, SQLBuilder.ColumnDescriptor column)
protected java.util.List<java.lang.String>	alter_table_alter_column_set_null_sqls(Formatter<ExpressionBuilder.Value> formatter, SQLBuilder.ColumnDescriptor column)
protected java.util.List<java.lang.String>	alter_table_drop_column_sqls(Formatter<ExpressionBuilder.Value> formatter, java.lang.String columnName)
protected java.util.List<java.lang.String>	alter_table_drop_primarykey_sqls(Formatter<ExpressionBuilder.Value> formatter, SQLBuilder.ColumnDescriptor column)
protected java.util.List<java.lang.String>	create_index_sqls(Formatter<ExpressionBuilder.Value> formatter, SQLBuilder.ColumnDescriptor column)
SQLBuilder.AlterTableBuilder	drop_column(java.lang.String columnName)
protected java.util.List<java.lang.String>	drop_index_sqls(Formatter<ExpressionBuilder.Value> formatter, SQLBuilder.ColumnDescriptor column)
SQLBuilder.AlterTableBuilder	drop_primary_key(java.lang.String columnName)
protected java.lang.String	getConstrainName(java.lang.String constrainType, java.lang.String columnName)
java.util.List<<any>>	getOperations()
boolean	isEmpty()
SQLBuilder.AlterTableBuilder	rename_column(java.lang.String source, java.lang.String target)
SQLBuilder.TableNameBuilder	table()
java.lang.String	toString()
java.lang.String	toString(Formatter<ExpressionBuilder.Value> formatter)
java.util.List<java.lang.String>	toStrings()
java.util.List<java.lang.String>	toStrings(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

Methods inherited from interface org.gvsig.tools.lang.Cloneable

cloneQuietly, cloneQuietly

Field Detail

table

protected SQLBuilder.TableNameBuilder table

drops

protected java.util.List<java.lang.String> drops

adds

protected java.util.List<SQLBuilder.ColumnDescriptor> adds

alters

@Deprecated
protected java.util.List<SQLBuilder.ColumnDescriptor> alters

Deprecated.

operations

protected java.util.List<<any>> operations

renames

protected java.util.List<<any>> renames

drop_primary_key_column

protected java.lang.String drop_primary_key_column

sqlbuilder

protected final SQLBuilderBase sqlbuilder

Constructor Detail

AlterTableBuilderBase

public AlterTableBuilderBase(SQLBuilderBase sqlbuilder)

Method Detail

getOperations

public java.util.List<<any>> getOperations()

isEmpty

public boolean isEmpty()

Specified by:

isEmpty in interface SQLBuilder.AlterTableBuilder

accept

public void accept(ExpressionBuilder.Visitor visitor,
                   ExpressionBuilder.VisitorFilter filter)

Specified by:

accept in interface ExpressionBuilder.Visitable

Overrides:

accept in class ExpressionBuilder.AbstractValue

table

public SQLBuilder.TableNameBuilder table()

Specified by:

table in interface SQLBuilder.AlterTableBuilder

drop_column

public SQLBuilder.AlterTableBuilder drop_column(java.lang.String columnName)

Specified by:

drop_column in interface SQLBuilder.AlterTableBuilder

drop_primary_key

public SQLBuilder.AlterTableBuilder drop_primary_key(java.lang.String columnName)

Specified by:

drop_primary_key in interface SQLBuilder.AlterTableBuilder

add_column

public SQLBuilder.AlterTableBuilder add_column(FeatureAttributeDescriptor fad)

Specified by:

add_column in interface SQLBuilder.AlterTableBuilder

add_column

public SQLBuilder.AlterTableBuilder add_column(java.lang.String columnName,
                                               int type,
                                               int size,
                                               int precision,
                                               int scale,
                                               boolean isPk,
                                               boolean isIndexed,
                                               boolean allowNulls,
                                               boolean isAutomatic,
                                               java.lang.Object defaultValue,
                                               boolean allowIndexDuplicateds)

Specified by:

add_column in interface SQLBuilder.AlterTableBuilder

add_geometry_column

public SQLBuilder.AlterTableBuilder add_geometry_column(java.lang.String columnName,
                                                        int type,
                                                        int subtype,
                                                        IProjection proj,
                                                        boolean isIndexed,
                                                        boolean allowNulls)

Specified by:

add_geometry_column in interface SQLBuilder.AlterTableBuilder

add_geometry_column

public SQLBuilder.AlterTableBuilder add_geometry_column(java.lang.String columnName,
                                                        int type,
                                                        int subtype,
                                                        java.lang.Object srsdbcode,
                                                        boolean isIndexed,
                                                        boolean allowNulls)

Specified by:

add_geometry_column in interface SQLBuilder.AlterTableBuilder

update_or_add_alters

protected void update_or_add_alters(SQLBuilderBase.ColumnDescriptorBase column)

alter_column

public SQLBuilder.AlterTableBuilder alter_column(Bitmask operation,
                                                 FeatureAttributeDescriptor fad)

Specified by:

alter_column in interface SQLBuilder.AlterTableBuilder

alter_column

public SQLBuilder.AlterTableBuilder alter_column(Bitmask operation,
                                                 java.lang.String columnName,
                                                 int type,
                                                 int size,
                                                 int precision,
                                                 int scale,
                                                 boolean isPk,
                                                 boolean isIndexed,
                                                 boolean allowNulls,
                                                 boolean isAutomatic,
                                                 java.lang.Object defaultValue,
                                                 boolean allowIndexDuplicateds)

Specified by:

alter_column in interface SQLBuilder.AlterTableBuilder

alter_geometry_column

public SQLBuilder.AlterTableBuilder alter_geometry_column(Bitmask operation,
                                                          java.lang.String columnName,
                                                          int type,
                                                          int subtype,
                                                          IProjection proj,
                                                          boolean isIndexed,
                                                          boolean allowNulls)

Specified by:

alter_geometry_column in interface SQLBuilder.AlterTableBuilder

alter_geometry_column

public SQLBuilder.AlterTableBuilder alter_geometry_column(Bitmask operation,
                                                          java.lang.String columnName,
                                                          int type,
                                                          int subtype,
                                                          java.lang.Object srsdbcode,
                                                          boolean isIndexed,
                                                          boolean allowNulls)

Specified by:

alter_geometry_column in interface SQLBuilder.AlterTableBuilder

rename_column

public SQLBuilder.AlterTableBuilder rename_column(java.lang.String source,
                                                  java.lang.String target)

Specified by:

rename_column in interface SQLBuilder.AlterTableBuilder

getConstrainName

protected java.lang.String getConstrainName(java.lang.String constrainType,
                                            java.lang.String columnName)

alter_table_add_primarykey_sqls

protected java.util.List<java.lang.String> alter_table_add_primarykey_sqls(Formatter<ExpressionBuilder.Value> formatter,
                                                                           SQLBuilder.ColumnDescriptor column)

alter_table_drop_primarykey_sqls

protected java.util.List<java.lang.String> alter_table_drop_primarykey_sqls(Formatter<ExpressionBuilder.Value> formatter,
                                                                            SQLBuilder.ColumnDescriptor column)

create_index_sqls

protected java.util.List<java.lang.String> create_index_sqls(Formatter<ExpressionBuilder.Value> formatter,
                                                             SQLBuilder.ColumnDescriptor column)

drop_index_sqls

protected java.util.List<java.lang.String> drop_index_sqls(Formatter<ExpressionBuilder.Value> formatter,
                                                           SQLBuilder.ColumnDescriptor column)

alter_table_alter_column_set_data_type_sqls

protected java.util.List<java.lang.String> alter_table_alter_column_set_data_type_sqls(Formatter<ExpressionBuilder.Value> formatter,
                                                                                       SQLBuilder.ColumnDescriptor column)

alter_table_alter_column_set_default_sqls

protected java.util.List<java.lang.String> alter_table_alter_column_set_default_sqls(Formatter<ExpressionBuilder.Value> formatter,
                                                                                     SQLBuilder.ColumnDescriptor column)

alter_table_alter_column_set_null_sqls

protected java.util.List<java.lang.String> alter_table_alter_column_set_null_sqls(Formatter<ExpressionBuilder.Value> formatter,
                                                                                  SQLBuilder.ColumnDescriptor column)

alter_table_drop_column_sqls

protected java.util.List<java.lang.String> alter_table_drop_column_sqls(Formatter<ExpressionBuilder.Value> formatter,
                                                                        java.lang.String columnName)

alter_table_add_column_sqls

protected java.util.List<java.lang.String> alter_table_add_column_sqls(Formatter<ExpressionBuilder.Value> formatter,
                                                                       SQLBuilder.ColumnDescriptor column)

alter_table_alter_column_rename_sqls

protected java.util.List<java.lang.String> alter_table_alter_column_rename_sqls(Formatter<ExpressionBuilder.Value> formatter,
                                                                                java.lang.String oldName,
                                                                                java.lang.String newName)

alter_column_add_geometry_constraint_sqls

protected java.util.List<java.lang.String> alter_column_add_geometry_constraint_sqls(Formatter<ExpressionBuilder.Value> formatter,
                                                                                     SQLBuilder.ColumnDescriptor column)

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

toString

public java.lang.String toString(Formatter<ExpressionBuilder.Value> formatter)

Specified by:

toString in interface ExpressionBuilder.Value

toStrings

public java.util.List<java.lang.String> toStrings()

Specified by:

toStrings in interface SQLBuilder.AlterTableBuilder

toStrings

public java.util.List<java.lang.String> toStrings(Formatter formatter)

Specified by:

toStrings in interface SQLBuilder.AlterTableBuilder