reply to https://www.v2ex.com/t/870012#reply28

V2EX_stream.java

class V2EX_stream {
    public List<String> getForeignKeyTable(List<String> tableNames,
                                           DataSourceEntity info,
                                           List<ForeignKeyInfo> foreignKeyInfos) {

        var childTables = tableNames.stream()
                .map(tableName -> findAllTable(info.getDataBaseName(), tableName))
                .filter(column -> !DB_KEYWORD_SET.contains(column.getColumnName().toUpperCase()))
                .flatMap(columnInfo -> foreignKeyInfos.stream()
                        .filter(it -> it.getSourceTableName().equals(columnInfo.getTableName()) &&
                                it.getSourceColumnName().equals(columnInfo.getColumnName())
                        )
                )
                .map(ForeignKeyInfo::getTargetTableName)
                .toList();

        if (childTables.isEmpty()) {
            return Collections.emptyList();
        } else {
            return getForeignKeyTable(childTables, info, foreignKeyInfos);
        }
    }
}