private static String getColumnsListAsString(final List<Column> columns, final boolean omitLargeObjectColumns, final Identifiers identifiers) { final List<String> columnsList = new ArrayList<>(); for (int i = 0; i < columns.size(); i++) { final Column column = columns.get(i); final JavaSqlTypeGroup javaSqlTypeGroup = column.getColumnDataType() .getJavaSqlType().getJavaSqlTypeGroup(); if (!(omitLargeObjectColumns && (javaSqlTypeGroup == JavaSqlTypeGroup.large_object || javaSqlTypeGroup == JavaSqlTypeGroup.object))) { columnsList.add(identifiers.quoteName(column.getName())); } } return String.join(", ", columnsList); }
private static String getColumnsListAsString(final List<Column> columns, final boolean omitLargeObjectColumns, final Identifiers identifiers) { final List<String> columnsList = new ArrayList<>(); for (int i = 0; i < columns.size(); i++) { final Column column = columns.get(i); final JavaSqlTypeGroup javaSqlTypeGroup = column.getColumnDataType() .getJavaSqlType().getJavaSqlTypeGroup(); if (!(omitLargeObjectColumns && (javaSqlTypeGroup == JavaSqlTypeGroup.large_object || javaSqlTypeGroup == JavaSqlTypeGroup.object))) { columnsList.add(identifiers.quoteName(column.getName())); } } return String.join(", ", columnsList); }
.getJavaSqlType().getVendorTypeNumber(); Object columnData; if (javaSqlType == Types.CLOB)
if (options.isShowStandardColumnTypeNames()) columnTypeName = column.getColumnDataType().getJavaSqlType().getName();
public boolean isValid() { final Column primaryKeyColumn = getPrimaryKeyColumn(); final Column foreignKeyColumn = getForeignKeyColumn(); final Table pkTable = primaryKeyColumn.getParent(); final Table fkTable = foreignKeyColumn.getParent(); if ((foreignKeyColumn.isPartOfPrimaryKey() || foreignKeyColumn.isPartOfUniqueIndex()) && pkTable.compareTo(fkTable) > 0) { return false; } final ColumnDataType fkColumnType = foreignKeyColumn.getColumnDataType(); final ColumnDataType pkColumnType = primaryKeyColumn.getColumnDataType(); final boolean isValid = fkColumnType.getJavaSqlType().getName() .equals(pkColumnType.getJavaSqlType().getName()); return isValid; }
+ columnDataType.getJavaSqlType().getName();
private JSONObject handleRoutineColumn(final RoutineColumn<?> column) { final JSONObject jsonColumn = new JSONObject(); try { jsonColumn.put("name", column.getName()); jsonColumn.put("dataType", column.getColumnDataType().getJavaSqlType().getName()); jsonColumn.put("databaseSpecificType", column.getColumnDataType().getDatabaseSpecificTypeName()); jsonColumn.put("width", column.getWidth()); jsonColumn.put("type", column.getColumnType().toString()); if (options.isShowOrdinalNumbers()) { jsonColumn.put("ordinal", column.getOrdinalPosition() + 1); } } catch (final JSONException e) { LOGGER.log(Level.FINER, new StringFormat("Error outputting routine column: %s", e.getMessage()), e); } return jsonColumn; }
if (options.isShowStandardColumnTypeNames()) columnTypeName = column.getColumnDataType().getJavaSqlType() .getName();
.getDatabaseSpecificTypeName()); out.println(" type: " + column.getColumnDataType().getJavaSqlType().getName());
out .println(" type: " + column.getColumnDataType().getJavaSqlType().getName());
if (options.isShowStandardColumnTypeNames()) columnTypeName = column.getColumnDataType().getJavaSqlType().getName();
private static String getColumnsListAsString(final List<Column> columns, boolean omitLargeObjectColumns) { final StringBuilder buffer = new StringBuilder(); for (int i = 0; i < columns.size(); i++) { final Column column = columns.get(i); final JavaSqlTypeGroup javaSqlTypeGroup = column.getColumnDataType() .getJavaSqlType().getJavaSqlTypeGroup(); if (!(omitLargeObjectColumns && javaSqlTypeGroup == JavaSqlTypeGroup.large_object)) { if (i > 0) { buffer.append(", "); } buffer.append(column.getName()); } } return buffer.toString(); }
private static String getColumnsListAsString(final List<Column> columns, final boolean omitLargeObjectColumns, final Identifiers identifiers) { final List<String> columnsList = new ArrayList<>(); for (int i = 0; i < columns.size(); i++) { final Column column = columns.get(i); final JavaSqlTypeGroup javaSqlTypeGroup = column.getColumnDataType() .getJavaSqlType().getJavaSqlTypeGroup(); if (!(omitLargeObjectColumns && (javaSqlTypeGroup == JavaSqlTypeGroup.large_object || javaSqlTypeGroup == JavaSqlTypeGroup.object))) { columnsList.add(identifiers.quoteName(column.getName())); } } return String.join(", ", columnsList); }
private static String getColumnsListAsString(final List<Column> columns, final boolean omitLargeObjectColumns, final Identifiers identifiers) { final List<String> columnsList = new ArrayList<>(); for (int i = 0; i < columns.size(); i++) { final Column column = columns.get(i); final JavaSqlTypeGroup javaSqlTypeGroup = column.getColumnDataType() .getJavaSqlType().getJavaSqlTypeGroup(); if (!(omitLargeObjectColumns && (javaSqlTypeGroup == JavaSqlTypeGroup.large_object || javaSqlTypeGroup == JavaSqlTypeGroup.object))) { columnsList.add(identifiers.quoteName(column.getName())); } } return String.join(", ", columnsList); }
protected JdbcType getNodeJdbcType(Column column) { switch(column.getColumnDataType().getJavaSqlType().getJavaSqlType()) { case Types.VARCHAR: return JdbcType.VARCHAR; case Types.INTEGER: return JdbcType.INT; case Types.BIGINT: return JdbcType.BIGINT; case Types.CHAR: return JdbcType.CHAR; case Types.DATE: return JdbcType.DATE; case Types.TIMESTAMP: return JdbcType.TIMESTAMP; case Types.DECIMAL: return JdbcType.DECIMAL; case Types.NUMERIC: return JdbcType.DECIMAL; case Types.SMALLINT: return JdbcType.SMALLINT; case Types.BIT: return JdbcType.SMALLINT; case Types.BLOB: return JdbcType.BLOB; case Types.CLOB: return JdbcType.CLOB; case 2147483647: { JdbcType jt = getJdbcTypeForUnknownJavaSqlType(column); if (jt != null) { return jt; } } } throw new IllegalArgumentException("Unsupported column type " + column.getColumnDataType().getJavaSqlType() + " (" + column.getColumnDataType().getJavaSqlType().getJavaSqlType() + ")"); }
column.getColumnDataType().getJavaSqlType().getName()); jsonColumn .put("databaseSpecificType",
public boolean isValid() { final Column primaryKeyColumn = getPrimaryKeyColumn(); final Column foreignKeyColumn = getForeignKeyColumn(); final Table pkTable = primaryKeyColumn.getParent(); final Table fkTable = foreignKeyColumn.getParent(); if ((foreignKeyColumn.isPartOfPrimaryKey() || foreignKeyColumn.isPartOfUniqueIndex()) && pkTable.compareTo(fkTable) > 0) { return false; } final ColumnDataType fkColumnType = foreignKeyColumn.getColumnDataType(); final ColumnDataType pkColumnType = primaryKeyColumn.getColumnDataType(); final boolean isValid = fkColumnType.getJavaSqlType().getName() .equals(pkColumnType.getJavaSqlType().getName()); return isValid; }
public boolean isValid() { final Column primaryKeyColumn = getPrimaryKeyColumn(); final Column foreignKeyColumn = getForeignKeyColumn(); final Table pkTable = primaryKeyColumn.getParent(); final Table fkTable = foreignKeyColumn.getParent(); if ((foreignKeyColumn.isPartOfPrimaryKey() || foreignKeyColumn.isPartOfUniqueIndex()) && pkTable.compareTo(fkTable) > 0) { return false; } final ColumnDataType fkColumnType = foreignKeyColumn.getColumnDataType(); final ColumnDataType pkColumnType = primaryKeyColumn.getColumnDataType(); final boolean isValid = fkColumnType.getJavaSqlType().getName() .equals(pkColumnType.getJavaSqlType().getName()); return isValid; }
private JSONObject handleRoutineColumn(final RoutineColumn<?> column) { final JSONObject jsonColumn = new JSONObject(); try { jsonColumn.put("dataType", column.getColumnDataType().getJavaSqlType() .getJavaSqlTypeName()); jsonColumn.put("databaseSpecificType", column.getColumnDataType() .getDatabaseSpecificTypeName()); jsonColumn.put("width", column.getWidth()); jsonColumn.put("type", column.getColumnType().toString()); if (options.isShowOrdinalNumbers()) { jsonColumn.put("ordinal", column.getOrdinalPosition() + 1); } } catch (final JSONException e) { LOGGER.log(Level.FINER, "Error outputting routine column: " + e.getMessage(), e); } return jsonColumn; }
private JSONObject handleRoutineColumn(final RoutineColumn<?> column) { final JSONObject jsonColumn = new JSONObject(); try { jsonColumn.put("name", column.getName()); jsonColumn.put("dataType", column.getColumnDataType().getJavaSqlType().getName()); jsonColumn.put("databaseSpecificType", column.getColumnDataType().getDatabaseSpecificTypeName()); jsonColumn.put("width", column.getWidth()); jsonColumn.put("type", column.getColumnType().toString()); if (options.isShowOrdinalNumbers()) { jsonColumn.put("ordinal", column.getOrdinalPosition() + 1); } } catch (final JSONException e) { LOGGER.log(Level.FINER, new StringFormat("Error outputting routine column: %s", e.getMessage()), e); } return jsonColumn; }