@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(); }