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