@Override
public void appendModifier(
OBJECT_TYPE column, StringBuilder sql, DBECommandAbstract<OBJECT_TYPE> command) {
if (column.isRequired()) {
sql.append(" NOT NULL"); // $NON-NLS-1$
}
}
@Override
public void appendModifier(
OBJECT_TYPE column, StringBuilder sql, DBECommandAbstract<OBJECT_TYPE> command) {
String defaultValue = CommonUtils.toString(column.getDefaultValue());
if (!CommonUtils.isEmpty(defaultValue)) {
boolean useQuotes =
column.getDataKind() == DBPDataKind.STRING
|| column.getDataKind() == DBPDataKind.DATETIME;
if (useQuotes && defaultValue.trim().startsWith(QUOTE)) {
useQuotes = false;
}
sql.append(" DEFAULT "); // $NON-NLS-1$
if (useQuotes) sql.append(QUOTE);
sql.append(defaultValue);
if (useQuotes) sql.append(QUOTE);
}
}
@Override
public void appendModifier(
OBJECT_TYPE column, StringBuilder sql, DBECommandAbstract<OBJECT_TYPE> command) {
final String typeName = column.getTypeName();
DBPDataKind dataKind = column.getDataKind();
final DBSDataType dataType = findDataType(column.getDataSource(), typeName);
sql.append(' ').append(typeName);
if (dataType == null) {
log.debug(
"Type name '"
+ typeName
+ "' is not supported by driver"); //$NON-NLS-1$ //$NON-NLS-2$
} else {
dataKind = dataType.getDataKind();
}
String modifiers = SQLUtils.getColumnTypeModifiers(column, typeName, dataKind);
if (modifiers != null) {
sql.append(modifiers);
}
}
@Override
protected StringBuilder getNestedDeclaration(
TABLE_TYPE owner, DBECommandAbstract<OBJECT_TYPE> command) {
OBJECT_TYPE column = command.getObject();
// Create column
String columnName = DBUtils.getQuotedIdentifier(column.getDataSource(), column.getName());
if (command instanceof SQLObjectEditor.ObjectRenameCommand) {
columnName = ((ObjectRenameCommand) command).getNewName();
}
StringBuilder decl = new StringBuilder(40);
decl.append(columnName);
for (ColumnModifier modifier : getSupportedModifiers()) {
modifier.appendModifier(column, decl, command);
}
return decl;
}
@Override
public void appendModifier(
OBJECT_TYPE column, StringBuilder sql, DBECommandAbstract<OBJECT_TYPE> command) {
sql.append(column.isRequired() ? " NOT NULL" : " NULL");
}
@Override
public boolean canEditObject(OBJECT_TYPE object) {
TABLE_TYPE table = object.getParentObject();
return table != null && !table.isView();
}
