/** * {@inheritDoc} */ @Override public ColumnDataType getColumnDataType() { return column.getColumnDataType(); }
/** * {@inheritDoc} */ @Override public boolean isNullable() { return column.isNullable(); }
protected boolean isColumnSignificant(final Column column) { return column != null && (column instanceof IndexColumn || column.isPartOfPrimaryKey() || column.isPartOfForeignKey() || column.isPartOfIndex()); }
ColumnPartial(final Column column) { this(requireNonNull(column, "No column provided").getParent(), column.getName()); addAttributes(column.getAttributes()); }
out.println(String.format("%s", column.getFullName())); .format(" - %s=%s", "data-type", column.getColumnDataType())); out.println(String.format(" - %s=%s", "size", column.getSize())); out.println(String.format(" - %s=%s", "decimal digits", column.getDecimalDigits())); out.println(String.format(" - %s=%s", "width", column.getWidth())); out.println(String .format(" - %s=%s", "default value", column.getDefaultValue())); out.println(String.format(" - %s=%s", "auto-incremented", column.isAutoIncremented())); out.println(String .format(" - %s=%s", "nullable", column.isNullable())); out.println(String .format(" - %s=%s", "generated", column.isGenerated())); out.println(String.format(" - %s=%s", "part of primary key", column.isPartOfPrimaryKey())); out.println(String.format(" - %s=%s", "part of foreign key", column.isPartOfForeignKey())); out.println(String.format(" - %s=%s", "ordinal position", column.getOrdinalPosition())); out.println(String .format(" - %s=%s", "remarks", column.getRemarks()));
try jsonColumn.put("name", column.getName()); printRemarks(column, jsonColumn); column.getColumnDataType().getJavaSqlType().getName()); jsonColumn .put("databaseSpecificType", column.getColumnDataType().getDatabaseSpecificTypeName()); jsonColumn.put("width", column.getWidth()); jsonColumn.put("size", column.getSize()); jsonColumn.put("decimalDigits", column.getDecimalDigits()); jsonColumn.put("nullable", column.isNullable()); jsonColumn.put("autoIncremented", column.isAutoIncremented()); jsonColumn.put("generated", column.isGenerated()); jsonColumn.put("ordinal", column.getOrdinalPosition());
if (options.isShowStandardColumnTypeNames()) columnTypeName = column.getColumnDataType().getJavaSqlType() .getName(); columnTypeName = column.getColumnDataType() .getDatabaseSpecificTypeName(); final String columnType = columnTypeName + column.getWidth(); final String nullable = columnNullable(columnTypeName, column.isNullable()); columnDetails = columnType + nullable; emphasize = column.isPartOfPrimaryKey(); if (options.isShowOrdinalNumbers()) ordinalNumberString = String.valueOf(column.getOrdinalPosition());
try jsonColumn.put("name", column.getName()); jsonColumn.put("dataType", column.getColumnDataType().getJavaSqlType() .getJavaSqlTypeName()); jsonColumn.put("databaseSpecificType", column.getColumnDataType() .getDatabaseSpecificTypeName()); jsonColumn.put("width", column.getWidth()); jsonColumn.put("size", column.getSize()); jsonColumn.put("decimalDigits", column.getDecimalDigits()); jsonColumn.put("nullable", column.isNullable()); jsonColumn.put("ordinal", column.getOrdinalPosition()); jsonColumn.put("remarks", column.getRemarks());
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 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); }
final boolean assertDataNotLoaded) final Table table = column.getParent(); assertThat("Primary key table table should not be in the database - " + table.getName(), emptyOptional()); assertThat("Column references do not match", column == table.lookupColumn(column.getName()).get(), is(true)); column.getColumnDataType(); fail("An exception should be thrown indicating that this table was not loaded from the database");
public static String constructForeignKeyName(final Column pkColumn, final Column fkColumn) { requireNonNull(pkColumn, "No primary key column provided"); requireNonNull(fkColumn, "No foreign key column provided"); final Table pkTable = pkColumn.getParent(); final Table fkParent = fkColumn.getParent(); final String pkHex = Integer.toHexString(pkTable.getFullName().hashCode()); final String fkHex = Integer.toHexString(fkParent.getFullName().hashCode()); final String foreignKeyName = String.format("SC_%s_%s", pkHex, fkHex) .toUpperCase(); return foreignKeyName; }
/** * {@inheritDoc} */ @Override public int getDecimalDigits() { return column.getDecimalDigits(); }
/** * {@inheritDoc} */ @Override public int getSize() { return column.getSize(); }
private void printTableColumnRemarks(final Column column) { if (column == null || !column.hasRemarks() || options.isHideRemarks()) { return; } formattingHelper .writeDetailRow("", "", column.getRemarks(), true, false, "remarks"); }
/** * {@inheritDoc} */ @Override public String getWidth() { return column.getWidth(); }
if (grepColumnInclusionRule.test(column.getFullName())) if (grepDefinitionInclusionRule.test(column.getRemarks()))
/** * {@inheritDoc} */ @Override public boolean isPartOfPrimaryKey() { return column.isPartOfPrimaryKey(); }
/** * {@inheritDoc} */ @Override public int getOrdinalPosition() { return column.getOrdinalPosition(); }