public static List<String> getTypeAlterSQL(TableColumnInfo from, TableColumnInfo to, HibernateDialect dialect, DatabaseObjectQualifier qualifier, SqlGenerationPreferences prefs) { if (from.getDataType() == to.getDataType() && from.getColumnSize() == to.getColumnSize()) { return null; } return dialect.getColumnTypeAlterSQL(from, to, qualifier, prefs); }
public void setExistingColumnInfo(TableColumnInfo info) { tableNameTextField.setText(info.getTableName()); columnNameTextField.setText(info.getColumnName()); String dataType = JDBCTypeMapper.getJdbcTypeName(info.getDataType()); typeList.setSelectedItem(dataType); nullableCheckBox.setSelected(info.isNullable().equals("YES")); if (JDBCTypeMapper.isNumberType(info.getDataType())) { precisionSpinner.setValue(Integer.valueOf(info.getColumnSize())); } else { lengthSpinner.setValue(Integer.valueOf(info.getColumnSize())); } commentTextArea.setText(info.getRemarks()); defaultTextField.setText(info.getDefaultValue()); }
public void setExistingColumnInfo(TableColumnInfo info) { tableNameTextField.setText(info.getTableName()); columnNameTextField.setText(info.getColumnName()); String dataType = JDBCTypeMapper.getJdbcTypeName(info.getDataType()); typeList.setSelectedItem(dataType); nullableCheckBox.setSelected(info.isNullable().equals("YES")); if (JDBCTypeMapper.isNumberType(info.getDataType())) { precisionSpinner.setValue(Integer.valueOf(info.getColumnSize())); } else { lengthSpinner.setValue(Integer.valueOf(info.getColumnSize())); } commentTextArea.setText(info.getRemarks()); defaultTextField.setText(info.getDefaultValue()); }
/** * Returns the readable data type for the given tableColumnInfo * * @param tableColumnInfo * data to generate the readable data type info * @return readable data type info */ public static String getDataTypeForDisplay(TableColumnInfo tableColumnInfo) { StringBuilder buf = new StringBuilder(); buf.append(tableColumnInfo.getTypeName()); if (SmarttoolsHelper.isDataTypeString(tableColumnInfo.getDataType())) { buf.append(" (" + tableColumnInfo.getColumnSize() + ")"); } else if (SmarttoolsHelper.isDataTypeNumeric(tableColumnInfo.getDataType())) { buf.append(" (" + tableColumnInfo.getColumnSize() + "," + tableColumnInfo.getDecimalDigits() + ")"); } return buf.toString(); }
public void setColumn2(TableColumnInfo c2) { col2Type = c2.getDataType(); col2Length = c2.getColumnSize(); col2IsNullable = c2.isNullable().equalsIgnoreCase("NO") ? false : true; tableName = c2.getTableName(); columnName = c2.getColumnName(); col2remarks = c2.getRemarks(); col2default = c2.getDefaultValue(); }
_columnLengthField.setInt(tci.getColumnSize()); _defaultvalue.setText(tci.getDefaultValue());
public void setColumn1(TableColumnInfo c1) { col1Type = c1.getDataType(); col1Length = c1.getColumnSize(); col1IsNullable = c1.isNullable().equalsIgnoreCase("NO") ? false : true; tableName = c1.getTableName(); columnName = c1.getColumnName(); col1remarks = c1.getRemarks(); col1default = c1.getDefaultValue(); }
String columnName = info.getColumnName(); String columnType = info.getTypeName(); int columnSize = info.getColumnSize(); int decimalDigits = info.getDecimalDigits(); boolean nullable = "YES".equalsIgnoreCase(info.isNullable());
private static int getColumnLength(ISession sourceSession, TableColumnInfo colInfo) throws UserCancelledOperationException { HibernateDialect dialect = DialectFactory.getDialect(DialectFactory.SOURCE_TYPE, sourceSession.getApplication().getMainFrame(), sourceSession.getMetaData()); int length = colInfo.getColumnSize(); int type = colInfo.getDataType(); length = dialect.getColumnLength(length, type); return length; }
public ExtendedColumnInfo(TableColumnInfo info, String simpleTableName) { _columnName = info.getColumnName(); _columnType = info.getTypeName(); _columnTypeID = info.getDataType(); _columnSize = info.getColumnSize(); _decimalDigits = info.getDecimalDigits(); _remarks = info.getRemarks(); if ("YES".equals(info.isNullable())) { _nullable = true; } else { _nullable = false; } _cat = info.getCatalogName(); _schem = info.getSchemaName(); _simpleTableName = simpleTableName; _qualifiedName = _cat + "." + _schem + "." + _simpleTableName + "." +_columnName; }
public ExtendedColumnInfo(TableColumnInfo info, String simpleTableName) { _columnName = info.getColumnName(); _columnType = info.getTypeName(); _columnTypeID = info.getDataType(); _columnSize = info.getColumnSize(); _decimalDigits = info.getDecimalDigits(); _remarks = info.getRemarks(); if ("YES".equals(info.isNullable())) { _nullable = true; } else { _nullable = false; } _cat = info.getCatalogName(); _schem = info.getSchemaName(); _simpleTableName = simpleTableName; _qualifiedName = _cat + "." + _schem + "." + _simpleTableName + "." +_columnName; }
for(int x = 0; x < ti.length; x++) CodeCompletionColumnInfo buf = new CodeCompletionColumnInfo(ti[x].getColumnName(), ti[x].getRemarks(), ti[x].getTypeName(), ti[x].getColumnSize(), ti[x].getDecimalDigits(), (ti[x].isNullable().equals("NO")) ? false : true, _useCompletionPrefs, _prefs.isShowRemarksInColumnCompletion()); String bufStr = buf.toString(); if (!uniqCols.contains(bufStr))
columnDefinitionString = SQLUtilities.createColumnDefinitionString(columnName, typeName, colInfo.getColumnSize(), colInfo.getDecimalDigits());
sourceColumn.getDataType(), sourceColumn.getTypeName(), sourceColumn.getColumnSize(), sourceColumn.getDecimalDigits(), sourceColumn.getRadix(), sourceColumn.getDataType(), sourceColumn.getTypeName(), sourceColumn.getColumnSize(), sourceColumn.getDecimalDigits(), sourceColumn.getRadix(), sourceColumn.getDataType(), sourceColumn.getTypeName(), sourceColumn.getColumnSize(), sourceColumn.getDecimalDigits(), sourceColumn.getRadix(), newColumn.getDataType(), newColumn.getTypeName(), newColumn.getColumnSize(), newColumn.getDecimalDigits(), newColumn.getRadix(),
mc.getDataType(), JDBCTypeMapper.getJdbcTypeName(mc.getDataType()), mc.getColumnSize(), mc.getDecimalDigits(), mc.getRadix(),