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; }
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 void handleData(final Table table, final ResultSet rows) throws SchemaCrawlerException { final String tableName; if (table != null) { if (options.isShowUnqualifiedNames()) { tableName = table.getName(); } else { tableName = table.getFullName(); } } else { tableName = ""; } handleData(tableName, rows); }
.format("o--> %s [%s]", table.getFullName(), table.getTableType())); final SortedMap<String, Object> tableAttributes = new TreeMap<>(table .getAttributes());
for (final Table table: tables) out.println(" table: " + table.getFullName());
for (final Table table: tables) out.println(" table: " + table.getFullName()); final Column[] columns = table.getColumns().toArray(new Column[0]); Arrays.sort(columns);
for (final Table table: tables) out.println(" table: " + table.getFullName()); final Column[] columns = table.getColumns().toArray(new Column[0]); Arrays.sort(columns);
for (final Table table: tables) out.println(" table: " + table.getFullName()); out.println(" # columns: " + table.getColumns().size()); out.println(" # child tables: "
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; }
for (final Table table: tables) out.println(" table: " + table.getFullName()); out.println(" # columns: " + table.getColumns().size()); out.println(" # child tables: "
for (final Table table: tables) out.println(" table: " + table.getFullName()); out.println(" # columns: " + table.getColumns().size()); out.println(" # constraints: "
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; }
for (final Table table: tables) out.println(" table: " + table.getFullName()); final Column[] columns = table.getColumns().toArray(new Column[0]); Arrays.sort(columns);
for (final Table table: tables) out.println(" table: " + table.getFullName()); final Column[] columns = table.getColumns().toArray(new Column[0]); Arrays.sort(columns);
for (final Table table: tables) out.println(" table: " + table.getFullName()); final Constraint[] tableConstraints = table.getTableConstraints() .toArray(new Constraint[0]);
if (!options.isShowUnqualifiedNames()) jsonTable.put("fullName", table.getFullName());
final int colspan = options.isShowOrdinalNumbers()? 3: 2; formattingHelper.append(" /* ").append(table.getFullName()) .append(" -=-=-=-=-=-=-=-=-=-=-=-=-=- */").println(); formattingHelper.append(" \"").append(nodeId(table)).append("\" [")
/** * {@inheritDoc} */ @Override public void handleData(final Table table, final ResultSet rows) throws SchemaCrawlerException { final String tableName; if (table != null) { if (options.isShowUnqualifiedNames()) { tableName = table.getName(); } else { tableName = table.getFullName(); } } else { tableName = ""; } handleData(tableName, rows); }
/** * {@inheritDoc} * * @see schemacrawler.tools.traversal.DataTraversalHandler#handleData(schemacrawler.schema.Table, * java.sql.ResultSet) */ @Override public void handleData(final Table table, final ResultSet rows) throws SchemaCrawlerException { final String tableName; if (table != null) { if (options.isShowUnqualifiedNames()) { tableName = table.getName(); } else { tableName = table.getFullName(); } } else { tableName = ""; } handleData(tableName, rows); }
/** * {@inheritDoc} */ @Override public void handleData(final Table table, final ResultSet rows) throws SchemaCrawlerException { final String tableName; if (table != null) { if (options.isShowUnqualifiedNames()) { tableName = table.getName(); } else { tableName = table.getFullName(); } } else { tableName = ""; } handleData(tableName, rows); }