org.gvsig.fmap.dal

Interface SQLBuilder.AlterTableBuilder

All Superinterfaces:

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

All Known Implementing Classes:

H2SpatialSQLBuilder.H2SpatialAlterTableBuilderBase, MDBSQLBuilder.MDBAlterTableBuilderBase, SQLBuilderBase.AlterTableBuilderBase, SQLiteSQLBuilder.SQLiteAlterTableBuilder

Enclosing interface:

SQLBuilder

public static interface SQLBuilder.AlterTableBuilder
extends SQLBuilder.Statement

Field Summary

Fields

Modifier and Type	Field and Description
static int	ALTER_COLUMN_ADD_COLUMN
static int	ALTER_COLUMN_ADD_PRIMARY_KEY
static int	ALTER_COLUMN_ALL
static int	ALTER_COLUMN_CREATE_INDEX
static int	ALTER_COLUMN_DROP_COLUMN
static int	ALTER_COLUMN_DROP_INDEX
static int	ALTER_COLUMN_DROP_PRIMARY_KEY
static int	ALTER_COLUMN_GEOMETRY
static int	ALTER_COLUMN_SET_DATA_TYPE
static int	ALTER_COLUMN_SET_DEFAULT
static int	ALTER_COLUMN_SET_NULL

Method Summary

Modifier and Type	Method and Description
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 geom_type, int geom_subtype, IProjection proj, boolean isIndexed, boolean allowNulls)
SQLBuilder.AlterTableBuilder	add_geometry_column(java.lang.String columnName, int geom_type, int geom_subtype, java.lang.Object srsdbcode, boolean isIndexed, boolean allowNulls)
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 geom_type, int geom_subtype, IProjection proj, boolean isIndexed, boolean allowNulls)
SQLBuilder.AlterTableBuilder	alter_geometry_column(Bitmask operation, java.lang.String columnName, int geom_type, int geom_subtype, java.lang.Object srsdbcode, boolean isIndexed, boolean allowNulls)
SQLBuilder.AlterTableBuilder	drop_column(java.lang.String columnName)
SQLBuilder.AlterTableBuilder	drop_primary_key(java.lang.String columnName)
boolean	isEmpty()
SQLBuilder.AlterTableBuilder	rename_column(java.lang.String source, java.lang.String target)
SQLBuilder.TableNameBuilder	table()
java.util.List<java.lang.String>	toStrings()
java.util.List<java.lang.String>	toStrings(Formatter formatter)

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

clone, copyPropertiesFrom, replace, toString

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

accept

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

ALTER_COLUMN_ALL

static final int ALTER_COLUMN_ALL

See Also:

Constant Field Values

ALTER_COLUMN_GEOMETRY

static final int ALTER_COLUMN_GEOMETRY

See Also:

Constant Field Values

ALTER_COLUMN_SET_DEFAULT

static final int ALTER_COLUMN_SET_DEFAULT

See Also:

Constant Field Values

ALTER_COLUMN_SET_NULL

static final int ALTER_COLUMN_SET_NULL

See Also:

Constant Field Values

ALTER_COLUMN_SET_DATA_TYPE

static final int ALTER_COLUMN_SET_DATA_TYPE

See Also:

Constant Field Values

ALTER_COLUMN_ADD_PRIMARY_KEY

static final int ALTER_COLUMN_ADD_PRIMARY_KEY

See Also:

Constant Field Values

ALTER_COLUMN_DROP_PRIMARY_KEY

static final int ALTER_COLUMN_DROP_PRIMARY_KEY

See Also:

Constant Field Values

ALTER_COLUMN_CREATE_INDEX

static final int ALTER_COLUMN_CREATE_INDEX

See Also:

Constant Field Values

ALTER_COLUMN_DROP_INDEX

static final int ALTER_COLUMN_DROP_INDEX

See Also:

Constant Field Values

ALTER_COLUMN_DROP_COLUMN

static final int ALTER_COLUMN_DROP_COLUMN

See Also:

Constant Field Values

ALTER_COLUMN_ADD_COLUMN

static final int ALTER_COLUMN_ADD_COLUMN

See Also:

Constant Field Values

Method Detail

table

SQLBuilder.TableNameBuilder table()

drop_column

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

drop_primary_key

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

add_column

SQLBuilder.AlterTableBuilder add_column(FeatureAttributeDescriptor fad)

add_column

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)

add_geometry_column

SQLBuilder.AlterTableBuilder add_geometry_column(java.lang.String columnName,
                                                 int geom_type,
                                                 int geom_subtype,
                                                 IProjection proj,
                                                 boolean isIndexed,
                                                 boolean allowNulls)

add_geometry_column

SQLBuilder.AlterTableBuilder add_geometry_column(java.lang.String columnName,
                                                 int geom_type,
                                                 int geom_subtype,
                                                 java.lang.Object srsdbcode,
                                                 boolean isIndexed,
                                                 boolean allowNulls)

alter_column

SQLBuilder.AlterTableBuilder alter_column(Bitmask operation,
                                          FeatureAttributeDescriptor fad)

alter_column

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)

alter_geometry_column

SQLBuilder.AlterTableBuilder alter_geometry_column(Bitmask operation,
                                                   java.lang.String columnName,
                                                   int geom_type,
                                                   int geom_subtype,
                                                   IProjection proj,
                                                   boolean isIndexed,
                                                   boolean allowNulls)

alter_geometry_column

SQLBuilder.AlterTableBuilder alter_geometry_column(Bitmask operation,
                                                   java.lang.String columnName,
                                                   int geom_type,
                                                   int geom_subtype,
                                                   java.lang.Object srsdbcode,
                                                   boolean isIndexed,
                                                   boolean allowNulls)

rename_column

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

isEmpty

boolean isEmpty()

toStrings

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

toStrings

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