dump_sql_stuff.py

from indico.util.console import cformat
colors = {
    'fk': 'yellow!',
    'pk': 'red!',
    'ix': 'green!',
    'ck': 'cyan!',
    'uq': 'blue!'
}
def print_stuff(table):
    t = db.Model.metadata.tables[table]
    print t.name
    for c in sorted(t.constraints, key=lambda x: x.name):
        if c._create_rule and isinstance(c._create_rule.target, db.Boolean):
            continue
        color = colors[c.name[:2]]
        print cformat('  - %%{%s}{}%%{reset}' % color).format(c.name)
    for idx in sorted(t.indexes, key=lambda x: x.name):
        color = colors[idx.name[:2]]
        print cformat('  - %%{%s}{}%%{reset}' % color).format(idx.name)