在过去的某个时候,我运行了一次 alembic 迁移,它创建了一个users
桌子像...
def upgrade():
...
op.create_table(
"users",
sa.Column("id", sa.Integer(), autoincrement=True, nullable=False),
...
sa.Column("type", sa.Enum("Foo", "Bar", "Baz", name="usertype"), nullable=False),
...
)
...
...它会自动创建名为的枚举usertype
与价值观"Foo", "Bar", "Baz"
.
现在,我想创建一些其他表也引用相同的枚举。例如。,
def upgrade():
...
op.create_table('foobar',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
...
sa.Column('user_type', sa.Enum(< ???????? >), nullable=False),
...
)
引用的语法是什么existing enum?
我似乎无法在文档中找到答案:https://docs.sqlalchemy.org/en/13/core/type_basics.html#sqlalchemy.types.Enum https://docs.sqlalchemy.org/en/13/core/type_basics.html#sqlalchemy.types.Enum