1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
# SPDX-FileCopyrightText: 2026 Dennis Fink <me+coding@dennisfink.me>
#
# SPDX-License-Identifier: BSD-3-Clause
"""Store incoming Webmention status as a non-native Enum.
Revision ID: 7c38bb1a935e
Revises: e62b1a7c4d90
"""
import sqlalchemy as sa
from alembic import op
revision = "7c38bb1a935e"
down_revision = "e62b1a7c4d90"
branch_labels = None
depends_on = None
status_enum = sa.Enum(
"received",
"verifying",
"verified",
"failed",
"deleted",
name="received_webmention_status",
native_enum=False,
)
def upgrade() -> None:
with op.batch_alter_table("received_webmentions") as batch_op:
batch_op.alter_column(
"status",
existing_type=sa.Text(),
type_=status_enum,
existing_nullable=False,
)
def downgrade() -> None:
with op.batch_alter_table("received_webmentions") as batch_op:
batch_op.alter_column(
"status",
existing_type=status_enum,
type_=sa.Text(),
existing_nullable=False,
)
|