Package org.gvsig.fmap.dal

Interface SQLBuilder.AlterTableBuilder

All Superinterfaces:

Cloneable, org.gvsig.tools.lang.Cloneable, org.gvsig.expressionevaluator.ExpressionBuilder.Value, org.gvsig.expressionevaluator.ExpressionBuilder.Visitable, org.gvsig.tools.util.PropertiesSupport, SQLBuilder.Statement, SQLBuilder.StatementPart

Enclosing interface:

SQLBuilder

public static interface SQLBuilder.AlterTableBuilder
extends SQLBuilder.Statement

Field Summary

Fields

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

Method Summary

Modifier and Type	Method	Description
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)
SQLBuilder.AlterTableBuilder	add_column(FeatureAttributeDescriptor fad)
SQLBuilder.AlterTableBuilder	add_geometry_column(String columnName, int geom_type, int geom_subtype, Object srsdbcode, boolean isIndexed, boolean allowNulls)
SQLBuilder.AlterTableBuilder	add_geometry_column(String columnName, int geom_type, int geom_subtype, org.gvsig.crs.projection.lib.Projection proj, boolean isIndexed, boolean allowNulls)
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)
SQLBuilder.AlterTableBuilder	alter_column(org.gvsig.tools.util.Bitmask operation, FeatureAttributeDescriptor fad)
SQLBuilder.AlterTableBuilder	alter_geometry_column(org.gvsig.tools.util.Bitmask operation, String columnName, int geom_type, int geom_subtype, Object srsdbcode, boolean isIndexed, boolean allowNulls)
SQLBuilder.AlterTableBuilder	alter_geometry_column(org.gvsig.tools.util.Bitmask operation, String columnName, int geom_type, int geom_subtype, org.gvsig.crs.projection.lib.Projection proj, boolean isIndexed, boolean allowNulls)
SQLBuilder.AlterTableBuilder	drop_column(String columnName)
SQLBuilder.AlterTableBuilder	drop_primary_key(String columnName)
boolean	isEmpty()
SQLBuilder.AlterTableBuilder	rename_column(String source, String target)
SQLBuilder.TableNameBuilder	table()
List<String>	toStrings()
List<String>	toStrings(org.gvsig.expressionevaluator.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

Field Details

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 Details

table

SQLBuilder.TableNameBuilder table()

drop_column

SQLBuilder.AlterTableBuilder drop_column(String columnName)

drop_primary_key

SQLBuilder.AlterTableBuilder drop_primary_key(String columnName)

add_column

SQLBuilder.AlterTableBuilder add_column(FeatureAttributeDescriptor fad)

add_column

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)

add_geometry_column

SQLBuilder.AlterTableBuilder add_geometry_column(String columnName,
 int geom_type,
 int geom_subtype,
 org.gvsig.crs.projection.lib.Projection proj,
 boolean isIndexed,
 boolean allowNulls)

add_geometry_column

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

alter_column

SQLBuilder.AlterTableBuilder alter_column(org.gvsig.tools.util.Bitmask operation,
 FeatureAttributeDescriptor fad)

alter_column

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)

alter_geometry_column

SQLBuilder.AlterTableBuilder alter_geometry_column(org.gvsig.tools.util.Bitmask operation,
 String columnName,
 int geom_type,
 int geom_subtype,
 org.gvsig.crs.projection.lib.Projection proj,
 boolean isIndexed,
 boolean allowNulls)

alter_geometry_column

SQLBuilder.AlterTableBuilder alter_geometry_column(org.gvsig.tools.util.Bitmask operation,
 String columnName,
 int geom_type,
 int geom_subtype,
 Object srsdbcode,
 boolean isIndexed,
 boolean allowNulls)

rename_column

SQLBuilder.AlterTableBuilder rename_column(String source,
 String target)

isEmpty

boolean isEmpty()

toStrings

List<String> toStrings()

toStrings

List<String> toStrings(org.gvsig.expressionevaluator.Formatter formatter)