column.setTypeCode(((Integer) values.get("DATA_TYPE")).intValue()); column.setTypeCode(Types.TIMESTAMP); column.setTypeCode(Types.SMALLINT); break; case Types.SMALLINT: column.setTypeCode(Types.INTEGER); break; case Types.INTEGER: column.setTypeCode(Types.BIGINT); break; case Types.BIGINT: column.setTypeCode(Types.DECIMAL); break; default:
column.setTypeCode(((Integer) values.get("DATA_TYPE")).intValue()); column.setTypeCode(Types.TIMESTAMP); column.setTypeCode(Types.SMALLINT); break; case Types.SMALLINT: column.setTypeCode(Types.INTEGER); break; case Types.INTEGER: column.setTypeCode(Types.BIGINT); break; case Types.BIGINT: column.setTypeCode(Types.DECIMAL); break; default:
typeCode = 12;//特殊处理,如果typeCode是-9(nvarchar类型),将typeCode转换为12(varchar),因为apache ddlutils不支持nvarchar类型 column.setTypeCode(typeCode); column.setTypeCode(Types.TIMESTAMP); column.setTypeCode(Types.SMALLINT); break; case Types.SMALLINT: column.setTypeCode(Types.INTEGER); break; case Types.INTEGER: column.setTypeCode(Types.BIGINT); break; case Types.BIGINT: column.setTypeCode(Types.BIGINT); break; default:
column.setTypeCode(((Integer)values.get("DATA_TYPE")).intValue());
column.setTypeCode(Types.BIGINT);
column.setTypeCode(Types.CLOB);
private Column createTagColumn(String tagName){ Column tagColumn = new Column(); tagColumn.setName(tagName); tagColumn.setTypeCode(Types.VARCHAR); tagColumn.setJavaName(tagName); // tagColumn.setScale(1024); tagColumn.setSize(String.valueOf(JdbcConstants.DEFAULT_TAG_VARCHAR_SIZE)); tagColumn.setDefaultValue(null); tagColumn.setDescription("eagle entity tag column for "+tagName); return tagColumn; }
private Column createTagColumn(String tagName){ Column tagColumn = new Column(); tagColumn.setName(tagName); tagColumn.setTypeCode(Types.VARCHAR); tagColumn.setJavaName(tagName); // tagColumn.setScale(1024); tagColumn.setSize(String.valueOf(JdbcConstants.DEFAULT_FIELD_VARCHAR_SIZE)); tagColumn.setDefaultValue(null); tagColumn.setDescription("eagle entity tag column for "+tagName); return tagColumn; }
private void buildTable(Table table) { Column id = new Column(); id.setName("id"); id.setPrimaryKey(true); id.setRequired(true); id.setTypeCode(Types.VARCHAR); id.setSize("50"); table.addColumn(id); Column value = new Column(); value.setName("value"); value.setTypeCode(Types.CLOB); table.addColumn(value); } }
column.setTypeCode(Types.BIGINT);
Column metricColumn = new Column(); metricColumn.setName(JdbcConstants.METRIC_NAME_COLUMN_NAME); metricColumn.setTypeCode(Types.VARCHAR); pkColumn.setPrimaryKey(true); pkColumn.setRequired(true); pkColumn.setTypeCode(Types.VARCHAR); tsColumn.setTypeCode(Types.BIGINT); tsColumn.setDescription("eagle entity timestamp column"); table.addColumn(tsColumn); typeCode = typeCode == null? Types.VARCHAR:typeCode; if(typeCode == Types.VARCHAR) fieldColumn.setSize(String.valueOf(JdbcConstants.DEFAULT_FIELD_VARCHAR_SIZE)); fieldColumn.setTypeCode(typeCode); fieldColumn.setDescription("eagle field column "+entry.getKey()+":"+entityDefinition.getColumnTypeOrNull(entry.getKey())); table.addColumn(fieldColumn);
/** * {@inheritDoc} */ protected Column readColumn(DatabaseMetaDataWrapper metaData, Map values) throws SQLException { Column column = super.readColumn(metaData, values); if (column.getDefaultValue() != null) { // SapDb pads the default value with spaces column.setDefaultValue(column.getDefaultValue().trim()); // SapDb uses the default value for the auto-increment specification if (column.getDefaultValue().startsWith("DEFAULT SERIAL")) { column.setAutoIncrement(true); column.setDefaultValue(null); } } if (column.getTypeCode() == Types.DECIMAL) { // We also perform back-mapping to BIGINT if ((column.getSizeAsInt() == 38) && (column.getScale() == 0)) { column.setTypeCode(Types.BIGINT); } } return column; } }
/** * {@inheritDoc} */ protected Column readColumn(DatabaseMetaDataWrapper metaData, Map values) throws SQLException { Column column = super.readColumn(metaData, values); if (column.getTypeCode() == Types.FLOAT) { column.setTypeCode(Types.REAL); } else if (TypeMap.isTextType(column.getTypeCode())) { column.setDefaultValue(unescape(column.getDefaultValue(), "'", "''")); } return column; }
column.setTypeCode(Types.LONGVARBINARY); column.setTypeCode(Types.LONGVARCHAR); if (column.getTypeCode() == Types.VARCHAR) column.setTypeCode(Types.LONGVARCHAR); column.setTypeCode(Types.LONGVARBINARY);
Column metricColumn = new Column(); metricColumn.setName(JdbcConstants.METRIC_NAME_COLUMN_NAME); metricColumn.setTypeCode(Types.VARCHAR); pkColumn.setPrimaryKey(true); pkColumn.setRequired(true); pkColumn.setTypeCode(Types.VARCHAR); tsColumn.setTypeCode(Types.BIGINT); tsColumn.setDescription("eagle entity timestamp column"); table.addColumn(tsColumn); typeCode = typeCode == null? Types.VARCHAR:typeCode; if(typeCode == Types.VARCHAR) fieldColumn.setSize(String.valueOf(JdbcConstants.DEFAULT_VARCHAR_SIZE)); fieldColumn.setTypeCode(typeCode); fieldColumn.setDescription("eagle field column "+entry.getKey()+":"+entityDefinition.getColumnTypeOrNull(entry.getKey())); table.addColumn(fieldColumn);
/** * Adjusts the columns in the table by fixing types and default values. * * @param table The table */ protected void adjustColumns(Table table) { Column[] columns = table.getColumns(); for (int idx = 0; idx < columns.length; idx++) { if (columns[idx].getTypeCode() == Types.FLOAT) { columns[idx].setTypeCode(Types.REAL); } else if ((columns[idx].getTypeCode() == Types.NUMERIC) || (columns[idx].getTypeCode() == Types.DECIMAL)) { if ((columns[idx].getTypeCode() == Types.NUMERIC) && (columns[idx].getSizeAsInt() == 18) && (columns[idx].getScale() == 0)) { columns[idx].setTypeCode(Types.BIGINT); } } else if (TypeMap.isTextType(columns[idx].getTypeCode())) { columns[idx].setDefaultValue(unescape(columns[idx].getDefaultValue(), "'", "''")); } } }
column.setTypeCode(Types.BIGINT);
/** * {@inheritDoc} */ public void apply(Database model, boolean caseSensitive) { Column column = findChangedColumn(model, caseSensitive); column.setTypeCode(_newColumnDef.getTypeCode()); column.setSize(_newColumnDef.getSize()); column.setAutoIncrement(_newColumnDef.isAutoIncrement()); column.setRequired(_newColumnDef.isRequired()); column.setDescription(_newColumnDef.getDescription()); column.setDefaultValue(_newColumnDef.getDefaultValue()); } }
/** * Returns a clone of the given source column. * * @param source The source column * @param clonePrimaryKeyStatus Whether to clone the column's primary key status; if <code>false</code> * then the clone will not be a primary key column * @return The clone */ public Column clone(Column source, boolean clonePrimaryKeyStatus) { Column result = new Column(); result.setName(source.getName()); result.setJavaName(source.getJavaName()); result.setPrimaryKey(clonePrimaryKeyStatus ? source.isPrimaryKey() : false); result.setRequired(source.isRequired()); result.setAutoIncrement(source.isAutoIncrement()); result.setTypeCode(source.getTypeCode()); result.setSize(source.getSize()); result.setDefaultValue(source.getDefaultValue()); return result; }
boolean scaleMatters = _platformInfo.hasPrecisionAndScale(targetTypeCode); newColumnDef.setTypeCode(targetColumn.getTypeCode()); newColumnDef.setSize(sizeMatters || scaleMatters ? targetColumn.getSize() : null); newColumnDef.setAutoIncrement(targetColumn.isAutoIncrement());