aboutsummaryrefslogtreecommitdiff
path: root/webmentions_ssg/migrations/versions/7c38bb1a935e_received_webmention_status_enum.py
blob: dcae16d60d28755259db8e06d2db39e816b3ca67 (plain) (blame)
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,
        )