Will Alembic auto-detect changes in Python Enums?

[jkugler]

We have a column definition like this:

architecture: Mapped[Optional[ReleaseArchitecture]] = mapped_column(Enum(ReleaseArchitecture, name="architecture_enum"))

If we, in our code, change the members of ReleaseArchitecture, will Alembic pick up those changes and generate the requisite migrations? Or is that a manual process? This is PostgreSQL, by the way, so we have native support for Enums.

[zzzeek]

the situation with alembic and PostgreSQL enums is unfortunately at a zero level right now, meaning autogenerate doesn't consider PG enums at all and you need to do these ALTER options manually (there are also no alembic ALTER TYPE ops, so you need to use op.execute() for these).

[jkugler]

Thank you for the reply. I did find https://github.com/Pogchamp-company/alembic-postgresql-enum and haven't yet tested it, but it may work for my purposes.