final String tableType = "[" + table.getTableType() + "]"; printRemarks(table); printTableColumns(table.getColumns(), true); if (isVerbose) printTableColumns(new ArrayList<>(table.getHiddenColumns()), true); printPrimaryKey(table.getPrimaryKey()); printForeignKeys(table); if (!isBrief) printIndexes(table.getIndexes()); printTriggers(table.getTriggers()); printTableConstraints(table.getTableConstraints()); printPrivileges(table.getPrivileges()); printDefinition(table);
private Collection<ColumnReference> mapForeignKeyColumns(final List<Table> tables) { requireNonNull(tables, "No tables provided"); final Collection<ColumnReference> fkColumnsMap = new HashSet<>(); for (final Table table: tables) { for (final ForeignKey foreignKey: table.getForeignKeys()) { for (final ForeignKeyColumnReference columnRef: foreignKey) { fkColumnsMap.add(columnRef); } } } return fkColumnsMap; } }
final List<Column> columns = table.getColumns(); columns.sort(columnsSort); final Schema schema = table.getSchema(); if (schema != null) tableProperties.put("tablename", table.getName()); tableProperties.put("columns", getColumnsListAsString(columns, false, identifiers)); tableProperties.put("orderbycolumns", getColumnsListAsString(columns, true, identifiers)); tableProperties.put("tabletype", table.getTableType().toString());
static void addWeakAssociationToTable(final Table table, final WeakAssociationForeignKey weakAssociation) { if (table != null && weakAssociation != null) { final SortedSet<WeakAssociationForeignKey> tableWeakAssociations = table .getAttribute(WEAK_ASSOCIATIONS_KEY, new TreeSet<WeakAssociationForeignKey>()); tableWeakAssociations.add(weakAssociation); table.setAttribute(WEAK_ASSOCIATIONS_KEY, tableWeakAssociations); } }
TablePartial(final Table table) { this(requireNonNull(table, "No table provided").getSchema(), table.getName()); addAttributes(table.getAttributes()); }
/** * {@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); }
jsonTable.put("name", table.getName()); if (!options.isShowUnqualifiedNames()) jsonTable.put("fullName", table.getFullName()); jsonTable.put("type", table.getTableType()); printRemarks(table, jsonTable); final List<Column> columns = table.getColumns(); final JSONArray jsonColumns = new JSONArray(); jsonTable.put("columns", jsonColumns); .getHiddenColumns()); if (isVerbose && !hiddenColumns.isEmpty()) jsonTable.put("primaryKey", handleIndex(table.getPrimaryKey())); jsonTable.put("foreignKeys", handleForeignKeys(table.getForeignKeys())); if (!isBrief) final Collection<Index> indexesCollection = table.getIndexes(); final List<Index> indexes = new ArrayList<>(indexesCollection); Collections jsonTable.put("triggers", handleTriggers(table.getTriggers())); .getTableConstraints(); final List<TableConstraint> constraints = new ArrayList<>(constraintsCollection); Collections
jsonTable.put("name", table.getName()); if (!options.isShowUnqualifiedNames()) jsonTable.put("fullName", table.getFullName()); jsonTable.put("type", table.getTableType()); final List<Column> columns = table.getColumns(); Collections.sort(columns, NamedObjectSort.getNamedObjectSort(options .isAlphabeticalSortForTableColumns())); jsonTable.put("primaryKey", handleIndex(table.getPrimaryKey())); jsonTable.put("foreignKeys", handleForeignKeys(table.getForeignKeys())); final Collection<Index> indicesCollection = table.getIndices(); final List<Index> indices = new ArrayList<>(indicesCollection); Collections.sort(indices, NamedObjectSort.getNamedObjectSort(options if (table.hasDefinition()) jsonTable.put("definition", table.getDefinition()); jsonTable.put("triggers", handleTriggers(table.getTriggers())); .getTableConstraints(); final List<TableConstraint> tableConstraints = new ArrayList<>(tableConstraintsCollection); Collections.sort(tableConstraints, NamedObjectSort for (final Privilege<Table> privilege: table.getPrivileges())
if (options.isShowUnqualifiedNames()) tableName = table.getName(); tableName = table.getFullName(); final String tableType = "[" + table.getTableType() + "]"; out.println(formattingHelper.createNameRow("", tableType)); final List<Column> columns = table.getColumns(); printTableColumns(columns); printPrimaryKey(table.getPrimaryKey()); printForeignKeys(table); if (isVerbose) printIndices(table.getIndices()); printDefinition(table); printTriggers(table.getTriggers()); printTableConstraints(table.getTableConstraints()); if (isVerbose) printPrivileges(table.getPrivileges()); final String tableRemarks = table.getRemarks(); boolean hasColumnRemarks = false; for (final Column column: columns)
assertThat("Could not find any columns", table0.getColumns(), not(empty())); final MutableTable table1 = new MutableTable(table0.getSchema(), "Test Table 1"); final MutableTable table2 = new MutableTable(table0.getSchema(), "Test Table 2"); final MutablePrimaryKey primaryKey = (MutablePrimaryKey) table0 .getPrimaryKey(); table1.setPrimaryKeyAndReplaceIndex(primaryKey); table2.setPrimaryKeyAndReplaceIndex(primaryKey); for (final Column column: table0.getColumns()) for (final Index index: table0.getIndexes()) for (final ForeignKey fk: table0.getForeignKeys()) for (final Trigger trigger: table0.getTriggers()) for (final Privilege privilege: table0.getPrivileges()) for (final Constraint tableConstraint: table0.getTableConstraints())
for (final Column column: table.getColumns()) if (grepDefinitionInclusionRule.test(table.getRemarks())) if (grepDefinitionInclusionRule.test(table.getDefinition())) for (final Trigger trigger: table.getTriggers())
for (final Table table: tables) out.println(" table: " + table.getFullName()); out.println(" # columns: " + table.getColumns().size()); out.println(" # constraints: " + table.getTableConstraints().size()); out.println(" # indexes: " + table.getIndexes().size()); out.println(" # foreign keys: " + table.getForeignKeys().size()); out.println(" # imported foreign keys: " + table.getExportedForeignKeys().size()); out.println(" # exported: " + table.getImportedForeignKeys().size()); out.println(" # privileges: " + table.getPrivileges().size());
private Set<Column> listTableKeys(final Table table) { final Set<Column> tableKeys = new HashSet<>(); final PrimaryKey primaryKey = table.getPrimaryKey(); if (primaryKey != null && primaryKey.getColumns().size() == 1) { tableKeys.add(primaryKey.getColumns().get(0)); } for (final Index index: table.getIndexes()) { if (index != null && index.isUnique() && index.getColumns().size() == 1) { tableKeys.add(index.getColumns().get(0)); } } return tableKeys; }
for (final Table table: tables) out.println(" table: " + table.getFullName()); final Column[] columns = table.getColumns().toArray(new Column[0]); Arrays.sort(columns); for (final Column column: columns)
final List<Column> columns = table.getColumns(); Collections.sort(columns, columnsSort); if (table.getSchema() != null) tableProperties.put("schema", table.getSchema().getFullName()); tableProperties.put("table", table.getFullName()); tableProperties.put("columns", getColumnsListAsString(columns, false)); tableProperties.put("orderbycolumns", getColumnsListAsString(columns, true)); tableProperties.put("tabletype", table.getTableType().toString());
final String tableType = "[" + table.getTableType() + "]"; formattingHelper.append(" /* ").append(table.getFullName()) .append(" -=-=-=-=-=-=-=-=-=-=-=-=-=- */").println(); formattingHelper.append(" \"").append(nodeId(table)).append("\" [") printTableColumns(table.getColumns()); if (isVerbose) printTableColumns(new ArrayList<>(table.getHiddenColumns()));
.format(" %s [%s]", table.getName(), table.getTableType())); final Column[] columns = table.getColumns().toArray(new Column[0]); Arrays.sort(columns); for (final Column column: columns)
+ table.getName(), catalog.lookupTable(table.getSchema(), table.getName()), emptyOptional()); assertThat("Column references do not match", column == table.lookupColumn(column.getName()).get(), is(true)); table.getTableType(); fail("An exception should be thrown indicating that this table was not loaded from the database");
for (final Table table: tables) out.println(" table: " + table.getFullName()); out.println(" # columns: " + table.getColumns().size()); out.println(" # child tables: " + table.getRelatedTables(TableRelationshipType.child)); out.println(" # parent tables: " + table.getRelatedTables(TableRelationshipType.parent));
/** * Check for table limiting rules. * * @param table * Table to check * @return Whether the table should be included */ @Override public boolean test(final Table table) { final boolean include; if (tableTypes != null) { include = tableTypes .contains(table.getTableType().getTableType().toLowerCase()); } else { include = true; } return include; }