with_variant does not work for SchemaType

from sqlalchemy import *
from sqlalchemy.orm import *
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.dialects import postgresql

Base = declarative_base()


class A(Base):
    __tablename__ = 'a'
    id = Column(Integer, primary_key=True)
    things = Column(
        Enum(
            "one", "two", "three"
        ).with_variant(
            postgresql.ENUM("one", "two", "three", name="my_enum"),
            "postgresql"
        )
    )

e = create_engine("postgresql://scott:tiger@localhost/test", echo=True)

Base.metadata.drop_all(e)
Base.metadata.create_all(e)

tries to create the main "enum", does not do the right thing for the variant version either

Comments (7)