Cannot introspect table with foreign key constraint in another schema about peewee HOT 1 CLOSED

Unfortunately this will require reworking a deal of code. The root of the issue is that peewee's Database.get_foreign_keys() APIs assume that the dest table is in the same namespace. We would need to capture the destination schema and add it to the ForeignKeyMetadata, then ensure it is propagated as a parameter to the subsequent introspection calls (e.g. for building-out key_table). There just aren't facilities for this at present and I'm not sure when I'll have time to add them.

My suggestion would be to explicitly declare your models, e.g.

db = MySQLDatabase(...)

class Base(db.Model):
    class Meta:
        legacy_table_names = False

class KeyTable(Base):
    example_id = BigAutoField()
    class Meta:
        schema = 'schema_a'

class DataTable(Base):
    example = ForeignKeyField(KeyTable)
    dummy_data = CharField()

    class Meta:
        primary_key = CompositeKey('example', 'dummy_data')

q = DataTable.select(DataTable, KeyTable).join(KeyTable)
for row in q:
    print(row.example.example_id, row.dummy_data)

from peewee.