find dependent tables

Here is an implementation for a method to find all the tables that are dependent on some table. This may not be the world's best implementation but it works.

def find_dependent_tables(table, metadata=None):    
    if metadata is None:
        metadata = default_metadata
    result = []
    def _impl(t2):
        for name, t in metadata.tables.iteritems():  
            for c in t.c:
                try:
                    if c.foreign_key.column.table == t2:
                        if t not in result:
                            result.append(t)
                        _impl(t)
                except AttributeError, e:
                    pass
    _impl(table)
    collection = sql_util.TableCollection()
    for r in result:
        collection.add(r)        
    return collection.sort(False)

Comments (6)