is there no way to get this alter statement without writing raw sql?
e.g. something like: op.alter_column("my_table", "my_column",
existing_type=ENUM(...), type_=ENUM()) ?
On Monday, September 24, 2018 at 2:36:52 PM UTC-4, Mike Bayer wrote:
>
> Postgresql ENUMs are entirely different from any other database so it
> matters a lot. For PG, you'd want to be doing op.execute("ALTER TYPE
> myenum ..."), full syntax is at
> https://www.postgresql.org/docs/9.1/static/sql-altertype.html
> On Mon, Sep 24, 2018 at 12:45 PM Alex Rothberg <agrot...@gmail.com
> <javascript:>> wrote:
> >
> > Assuming that I am using the PEP-435 enum feature in SQLA, e.g.:
> > class InvitationReason(str, enum.Enum):
> > ORIGINAL_ADMIN = "ORIGINAL_ADMIN"
> > FIRM_USER = "FIRM_USER"
> > ...
> >
> > reason = db.Column(db.Enum(InvitationReason), nullable=False)
> >
> > and I want to add / change the values in the enum. I know that alembic
> won't auto generate the migration. Given that, what is the simplest way to
> specify the migration by hand? I am using postgres, if that matters.
> >
> > --
> > You received this message because you are subscribed to the Google
> Groups "sqlalchemy-alembic" group.
> > To unsubscribe from this group and stop receiving emails from it, send
> an email to sqlalchemy-alembic+unsubscr...@googlegroups.com <javascript:>.
>
> > For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy-alembic" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy-alembic+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
