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(); }
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 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); }
String columnName = info.getColumnName(); String columnType = info.getTypeName(); int columnSize = info.getColumnSize(); int decimalDigits = info.getDecimalDigits(); boolean nullable = "YES".equalsIgnoreCase(info.isNullable());
CaseInsensitiveString cistr = new CaseInsensitiveString(mc.getColumnName()); if (customDialog.getMergeColumns().contains(cistr)) s_log.debug("Schema: " + mc.getSchemaName()); new TableColumnInfo( mc.getCatalogName(), mc.getSchemaName(), destinationTable, mc.getColumnName(), mc.getDataType(), JDBCTypeMapper.getJdbcTypeName(mc.getDataType()), mc.getColumnSize(), mc.getDecimalDigits(), mc.getRadix(), mc.isNullAllowed(), mc.getRemarks(), mc.getDefaultValue(), mc.getOctetLength(), mc.getOrdinalPosition(), "YES", md);
if (info.getColumnName().equals(_customDialog.getSourceColumn())) String sourceTableName = sourceColumn.getTableName(); String sourceColumnName = sourceColumn.getColumnName(); new TableColumnInfo( catalog, schema, lookupTableName, lookupPrimaryKey, sourceColumn.getDataType(), sourceColumn.getTypeName(), sourceColumn.getColumnSize(), sourceColumn.getDecimalDigits(), sourceColumn.getRadix(), sourceColumn.isNullAllowed(), new TableColumnInfo( catalog, schema, lookupTableName, new TableColumnInfo( catalog, schema, lookupTableName, _customDialog.getLookupSecondColumn(), sourceColumn.getDataType(), sourceColumn.getTypeName(), sourceColumn.getColumnSize(), sourceColumn.getDecimalDigits(), sourceColumn.getRadix(),
private void setLocalColumnBox() { for (TableColumnInfo column : _localTableColumns) { localColumBox.addItem(column.getColumnName()); } }
private boolean isNumericValueCheck(TableColumnInfo tableColumnInfo) { int dataType = getUsedDataType(); return (getUsedGroup() == STDataType.GROUP_NUMERIC && (dataType == tableColumnInfo.getDataType() || (dataType == STDataType.USE_WHOLE_GROUP && SmarttoolsHelper.isDataTypeNumeric(tableColumnInfo.getDataType()))) && isValidColumnName(tableColumnInfo.getColumnName())); }
/** * 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(); }
/** * @see net.sourceforge.squirrel_sql.plugins.refactoring.commands.AbstractRefactoringCommand#generateSQLStatements() */ @Override protected String[] generateSQLStatements() throws UserCancelledOperationException { String[] result = new String[0]; if (_dialect.supportsAutoIncrement()) { DatabaseObjectQualifier qualifier = new DatabaseObjectQualifier(columnToModify.getCatalogName(), columnToModify.getSchemaName()); // TODO: Allow the user to specify the sequence name for dialects that don't natively support // auto-increment columns without using sequence/trigger combo. final StringBuilder sequenceName = new StringBuilder(); sequenceName.append(columnToModify.getTableName().toUpperCase()).append("_"); sequenceName.append(columnToModify.getColumnName().toUpperCase()).append("_SEQ"); result = _dialect.getAddAutoIncrementSQL(columnToModify, sequenceName.toString(), qualifier, _sqlPrefs); } else { _session.showMessage(s_stringMgr.getString("AddAutoIncrementCommand.unsupportedOperationMsg", _dialect.getDisplayName())); } return result; }
DialectFactory.SOURCE_TYPE, sourceSession.getApplication().getMainFrame(), sourceSession.getMetaData()); String lengthFunction = dialect.getLengthFunction(colInfo.getDataType()); if (lengthFunction == null) result.append(lengthFunction); result.append("("); result.append(colInfo.getColumnName()); result.append(")) from "); String table = tableName; sourceSession, colInfo.getCatalogName(), colInfo.getSchemaName(), tableName, DialectFactory.SOURCE_TYPE);
private void updateControlStatus() _dataTypesCmb.setSelectedItem(_dataTypesByTypeName.get(tci.getTypeName().toUpperCase())); _columnLengthField.setInt(tci.getColumnSize()); _defaultvalue.setText(tci.getDefaultValue());
throws UserCancelledOperationException, MappingException int colJdbcType = colInfo.getDataType(); if (colInfo.getDecimalDigits() == 0) { colJdbcType = Types.BIGINT; "ColTypeMapper.mapColType: using dialect type: "+ destDialect.getClass().getName()+" to find name for column "+ colInfo.getColumnName()+" in table "+destTableName+ " with type id="+colJdbcType+" ("+ JDBCTypeMapper.getJdbcTypeName(colJdbcType)+")"); precision = destDialect.getMaxPrecision(colJdbcType); int scale = colInfo.getDecimalDigits(); if (scale > destDialect.getMaxScale(colJdbcType)) { scale = destDialect.getMaxScale(colJdbcType);
String colName = infos[idx].getColumnName(); String defValue = infos[idx].getDefaultValue();
int colJdbcType = colInfo.getDataType(); if (colJdbcType == java.sql.Types.OTHER) String typeName = colInfo.getTypeName().toUpperCase(); int parenIndex = typeName.indexOf("("); if (parenIndex != -1) colJdbcType = dialect.getJavaTypeForNativeType(colInfo.getTypeName()); } catch (Exception e)
/** * Returns a boolean value indicating whether or not the specified TableColumnInfo represents a database * column that holds binary type data. * * @param columnInfo * the TableColumnInfo to examine * @return true if binary; false otherwise. */ public static boolean isBinaryType(TableColumnInfo columnInfo) { boolean result = false; int type = columnInfo.getDataType(); if (type == Types.BINARY || type == Types.BLOB || type == Types.LONGVARBINARY || type == Types.VARBINARY) { result = true; } return result; }
if (colInfo.getSchemaName() != null) pstmt.setString(1, colInfo.getColumnName()); if (colInfo.getSchemaName() != null) pstmt.setString(2, colInfo.getSchemaName());
String sql = null; if (tableColumnInfo.isNullAllowed() == 0) { sql = "SELECT COUNT(*) FROM " + tableInfo.getSimpleName() + " WHERE " + tableColumnInfo.getColumnName() + " IS NULL"; if (resultFound > 0) { addTableEntry(tableInfo.getSimpleName(), tableColumnInfo.getColumnName(), SmarttoolsHelper.getDataTypeForDisplay(tableColumnInfo), resultFound + ""); + tableInfo.getSimpleName() + "] " + i18n.GLOBAL_COLUMN + " [" + tableColumnInfo.getColumnName() + "] :" + e.getLocalizedMessage(); addTableEntry(tableInfo.getSimpleName(), tableColumnInfo.getColumnName(), SmarttoolsHelper.getDataTypeForDisplay(tableColumnInfo), i18n.ERROR_ON_TABLE);
public static String[] getNullAlterSQL(TableColumnInfo from, TableColumnInfo to, HibernateDialect dialect, DatabaseObjectQualifier qualifier, SqlGenerationPreferences prefs) { if (from.isNullable().equalsIgnoreCase(to.isNullable())) { return null; } return dialect.getColumnNullableAlterSQL(to, qualifier, prefs); }
/** * @see net.sourceforge.squirrel_sql.plugins.refactoring.commands.AbstractRefactoringCommand#generateSQLStatements() */ @Override protected String[] generateSQLStatements() throws Exception { TableColumnInfo info = customDialog.getColumnInfo(); String[] result = null; DatabaseObjectQualifier qualifier = new DatabaseObjectQualifier(info.getCatalogName(), info.getSchemaName()); try { result = _dialect.getAddColumnSQL(info, qualifier, _sqlPrefs); } catch (HibernateException e1) { String dataType = customDialog.getSelectedTypeName(); JOptionPane.showMessageDialog(customDialog, s_stringMgr.getString("AbstractRefactoringCommand.unsupportedTypeMsg", _dialect.getDisplayName(), dataType), AbstractRefactoringCommand.i18n.UNSUPPORTED_TYPE_TITLE, JOptionPane.ERROR_MESSAGE); } catch (UnsupportedOperationException e2) { _session.showMessage(s_stringMgr.getString("AddColumnCommand.unsupportedOperationMsg", _dialect.getDisplayName())); } return result; }