public class ColumnAdder extends AuditedSchemaUpdaterStepBase
includeAudTable, isAuditing, tableName
stepName
Modifier | Constructor and Description |
---|---|
protected |
ColumnAdder(java.util.List<? extends ISchemaUpdaterStep> stepList,
java.lang.String stepName,
java.lang.String tableName,
java.lang.String newColumnName,
Datatype columnType,
java.lang.Integer size,
boolean includeAudTable,
java.lang.Object defaultValue,
boolean notNull,
java.lang.String referencedTable) |
Modifier and Type | Method and Description |
---|---|
static java.lang.String |
getAddColumnSeperator(ICdmDataSource datasource)
Returns the sql keywords for adding a column.
|
java.lang.String |
getNewColumnName() |
java.lang.String |
getReferencedTable() |
java.lang.String |
getUpdateQueryString(java.lang.String tableName,
ICdmDataSource datasource,
IProgressMonitor monitor)
Returns the update query string.
|
protected void |
invokeOnTable(java.lang.String tableName,
ICdmDataSource datasource,
IProgressMonitor monitor,
CaseType caseType,
SchemaUpdateResult result)
Invoke the update on the given table of name tableName.
|
static ColumnAdder |
NewBooleanInstance(java.util.List<? extends ISchemaUpdaterStep> stepList,
java.lang.String stepName,
java.lang.String tableName,
java.lang.String newColumnName,
boolean includeAudTable,
java.lang.Boolean defaultValue) |
static ColumnAdder |
NewClobInstance(java.util.List<? extends ISchemaUpdaterStep> stepList,
java.lang.String stepName,
java.lang.String tableName,
java.lang.String newColumnName,
boolean includeAudTable) |
static ColumnAdder |
NewDateTimeInstance(java.util.List<? extends ISchemaUpdaterStep> stepList,
java.lang.String stepName,
java.lang.String tableName,
java.lang.String newColumnName,
boolean includeAudTable,
boolean notNull) |
static ColumnAdder |
NewDoubleInstance(java.util.List<? extends ISchemaUpdaterStep> stepList,
java.lang.String stepName,
java.lang.String tableName,
java.lang.String newColumnName,
boolean includeAudTable,
boolean notNull) |
static ColumnAdder |
NewDTYPEInstance(java.util.List<? extends ISchemaUpdaterStep> stepList,
java.lang.String stepName,
java.lang.String tableName,
java.lang.String defaultValue,
boolean includeAudTable) |
static ColumnAdder |
NewIntegerInstance(java.util.List<? extends ISchemaUpdaterStep> stepList,
java.lang.String stepName,
java.lang.String tableName,
java.lang.String newColumnName,
boolean includeAudTable,
boolean notNull,
java.lang.String referencedTable)
Add ForeignKey.
|
static ColumnAdder |
NewIntegerInstance(java.util.List<? extends ISchemaUpdaterStep> stepList,
java.lang.String stepName,
java.lang.String tableName,
java.lang.String newColumnName,
boolean includeAudTable,
java.lang.Integer defaultValue,
boolean notNull) |
static ColumnAdder |
NewStringInstance(java.util.List<? extends ISchemaUpdaterStep> stepList,
java.lang.String stepName,
java.lang.String tableName,
java.lang.String newColumnName,
boolean includeAudTable)
Adds a string column with length 255 and default value
null |
static ColumnAdder |
NewStringInstance(java.util.List<? extends ISchemaUpdaterStep> stepList,
java.lang.String stepName,
java.lang.String tableName,
java.lang.String newColumnName,
int length,
boolean includeAudTable)
Adds a string column with the given length and default value
null |
static ColumnAdder |
NewStringInstance(java.util.List<? extends ISchemaUpdaterStep> stepList,
java.lang.String stepName,
java.lang.String tableName,
java.lang.String newColumnName,
int length,
java.lang.String defaultValue,
boolean includeAudTable)
Adds a string column with the given length and the given default value
|
static ColumnAdder |
NewTinyIntegerInstance(java.util.List<? extends ISchemaUpdaterStep> stepList,
java.lang.String stepName,
java.lang.String tableName,
java.lang.String newColumnName,
boolean includeAudTable,
boolean notNull) |
ColumnAdder |
setNotNull(boolean isNotNull) |
invoke
getBoolean, getEnglishLanguageId, getInnerSteps, getLanguageId, getNowString, getStepName, isIgnoreErrors, setIgnoreErrors, setStepName, toString
protected ColumnAdder(java.util.List<? extends ISchemaUpdaterStep> stepList, java.lang.String stepName, java.lang.String tableName, java.lang.String newColumnName, Datatype columnType, java.lang.Integer size, boolean includeAudTable, java.lang.Object defaultValue, boolean notNull, java.lang.String referencedTable)
public static final ColumnAdder NewIntegerInstance(java.util.List<? extends ISchemaUpdaterStep> stepList, java.lang.String stepName, java.lang.String tableName, java.lang.String newColumnName, boolean includeAudTable, boolean notNull, java.lang.String referencedTable)
referencedTable
- public static final ColumnAdder NewIntegerInstance(java.util.List<? extends ISchemaUpdaterStep> stepList, java.lang.String stepName, java.lang.String tableName, java.lang.String newColumnName, boolean includeAudTable, java.lang.Integer defaultValue, boolean notNull)
public static final ColumnAdder NewTinyIntegerInstance(java.util.List<? extends ISchemaUpdaterStep> stepList, java.lang.String stepName, java.lang.String tableName, java.lang.String newColumnName, boolean includeAudTable, boolean notNull)
public static final ColumnAdder NewDoubleInstance(java.util.List<? extends ISchemaUpdaterStep> stepList, java.lang.String stepName, java.lang.String tableName, java.lang.String newColumnName, boolean includeAudTable, boolean notNull)
public static final ColumnAdder NewBooleanInstance(java.util.List<? extends ISchemaUpdaterStep> stepList, java.lang.String stepName, java.lang.String tableName, java.lang.String newColumnName, boolean includeAudTable, java.lang.Boolean defaultValue)
public static final ColumnAdder NewStringInstance(java.util.List<? extends ISchemaUpdaterStep> stepList, java.lang.String stepName, java.lang.String tableName, java.lang.String newColumnName, boolean includeAudTable)
null
public static final ColumnAdder NewDTYPEInstance(java.util.List<? extends ISchemaUpdaterStep> stepList, java.lang.String stepName, java.lang.String tableName, java.lang.String defaultValue, boolean includeAudTable)
public static final ColumnAdder NewStringInstance(java.util.List<? extends ISchemaUpdaterStep> stepList, java.lang.String stepName, java.lang.String tableName, java.lang.String newColumnName, int length, boolean includeAudTable)
null
public static final ColumnAdder NewStringInstance(java.util.List<? extends ISchemaUpdaterStep> stepList, java.lang.String stepName, java.lang.String tableName, java.lang.String newColumnName, int length, java.lang.String defaultValue, boolean includeAudTable)
public static final ColumnAdder NewClobInstance(java.util.List<? extends ISchemaUpdaterStep> stepList, java.lang.String stepName, java.lang.String tableName, java.lang.String newColumnName, boolean includeAudTable)
public static final ColumnAdder NewDateTimeInstance(java.util.List<? extends ISchemaUpdaterStep> stepList, java.lang.String stepName, java.lang.String tableName, java.lang.String newColumnName, boolean includeAudTable, boolean notNull)
public ColumnAdder setNotNull(boolean isNotNull)
protected void invokeOnTable(java.lang.String tableName, ICdmDataSource datasource, IProgressMonitor monitor, CaseType caseType, SchemaUpdateResult result)
AuditedSchemaUpdaterStepBase
invokeOnTable
in class AuditedSchemaUpdaterStepBase
tableName
- the tableName, already in the correct casedatasource
- the data sourcemonitor
- the monitorcaseType
- the caseType (in case other tables are also affectedpublic java.lang.String getUpdateQueryString(java.lang.String tableName, ICdmDataSource datasource, IProgressMonitor monitor) throws DatabaseTypeNotSupportedException
CaseType
.tableName
- correctly cased table namedatasource
- data sourcemonitor
- monitorDatabaseTypeNotSupportedException
public static java.lang.String getAddColumnSeperator(ICdmDataSource datasource) throws DatabaseTypeNotSupportedException
datasource
- DatabaseTypeNotSupportedException
public java.lang.String getReferencedTable()
public java.lang.String getNewColumnName()
Copyright © 2007-2020 EDIT. All Rights Reserved.