111 lines
5.7 KiB
Python
111 lines
5.7 KiB
Python
"""add content features and alerts
|
|
|
|
Revision ID: 0003_content_features
|
|
Revises: 0002_file_blob_thumb
|
|
Create Date: 2026-06-03
|
|
"""
|
|
|
|
from __future__ import annotations
|
|
|
|
from alembic import op
|
|
import sqlalchemy as sa
|
|
|
|
|
|
revision = "0003_content_features"
|
|
down_revision = "0002_file_blob_thumb"
|
|
branch_labels = None
|
|
depends_on = None
|
|
|
|
|
|
def upgrade() -> None:
|
|
op.add_column("artworks", sa.Column("content_type", sa.String(length=20), nullable=False, server_default="illust"))
|
|
op.add_column("artworks", sa.Column("last_viewed_at", sa.DateTime(timezone=True), nullable=True))
|
|
op.create_index("ix_artworks_content_type", "artworks", ["content_type"])
|
|
op.create_index("ix_artworks_last_viewed_at", "artworks", ["last_viewed_at"])
|
|
|
|
op.add_column("novels", sa.Column("series_id", sa.String(length=50), nullable=True))
|
|
op.add_column("novels", sa.Column("series_title", sa.String(length=500), nullable=True))
|
|
op.add_column("novels", sa.Column("chapter_title", sa.String(length=500), nullable=True))
|
|
op.add_column("novels", sa.Column("chapter_order", sa.Integer(), nullable=False, server_default="0"))
|
|
op.add_column("novels", sa.Column("last_viewed_at", sa.DateTime(timezone=True), nullable=True))
|
|
op.create_index("ix_novels_series_id", "novels", ["series_id"])
|
|
op.create_index("ix_novels_last_viewed_at", "novels", ["last_viewed_at"])
|
|
|
|
op.create_table(
|
|
"creator_follows",
|
|
sa.Column("id", sa.String(length=36), nullable=False),
|
|
sa.Column("created_at", sa.DateTime(timezone=True), nullable=False),
|
|
sa.Column("updated_at", sa.DateTime(timezone=True), nullable=False),
|
|
sa.Column("user_id", sa.String(length=36), nullable=False),
|
|
sa.Column("platform", sa.String(length=20), nullable=False),
|
|
sa.Column("creator_id", sa.String(length=100), nullable=False),
|
|
sa.Column("creator_name", sa.String(length=200), nullable=True),
|
|
sa.Column("creator_handle", sa.String(length=200), nullable=True),
|
|
sa.Column("profile_url", sa.Text(), nullable=True),
|
|
sa.Column("avatar_url", sa.Text(), nullable=True),
|
|
sa.Column("enabled", sa.Boolean(), nullable=False),
|
|
sa.Column("last_checked_at", sa.DateTime(timezone=True), nullable=True),
|
|
sa.Column("latest_published_at", sa.DateTime(timezone=True), nullable=True),
|
|
sa.Column("metadata", sa.JSON(), nullable=False),
|
|
sa.ForeignKeyConstraint(["user_id"], ["users.id"], ondelete="CASCADE"),
|
|
sa.PrimaryKeyConstraint("id"),
|
|
)
|
|
op.create_index("ix_creator_follows_user_id", "creator_follows", ["user_id"])
|
|
op.create_index("ix_creator_follows_platform", "creator_follows", ["platform"])
|
|
op.create_index("ix_creator_follows_creator_id", "creator_follows", ["creator_id"])
|
|
op.create_index("ix_creator_follows_enabled", "creator_follows", ["enabled"])
|
|
|
|
op.create_table(
|
|
"update_alerts",
|
|
sa.Column("id", sa.String(length=36), nullable=False),
|
|
sa.Column("created_at", sa.DateTime(timezone=True), nullable=False),
|
|
sa.Column("updated_at", sa.DateTime(timezone=True), nullable=False),
|
|
sa.Column("user_id", sa.String(length=36), nullable=False),
|
|
sa.Column("follow_id", sa.String(length=36), nullable=True),
|
|
sa.Column("platform", sa.String(length=20), nullable=False),
|
|
sa.Column("creator_id", sa.String(length=100), nullable=False),
|
|
sa.Column("title", sa.String(length=500), nullable=False),
|
|
sa.Column("body", sa.Text(), nullable=True),
|
|
sa.Column("content_type", sa.String(length=20), nullable=True),
|
|
sa.Column("target_url", sa.Text(), nullable=True),
|
|
sa.Column("cover_url", sa.Text(), nullable=True),
|
|
sa.Column("is_read", sa.Boolean(), nullable=False),
|
|
sa.Column("payload", sa.JSON(), nullable=False),
|
|
sa.ForeignKeyConstraint(["follow_id"], ["creator_follows.id"], ondelete="SET NULL"),
|
|
sa.ForeignKeyConstraint(["user_id"], ["users.id"], ondelete="CASCADE"),
|
|
sa.PrimaryKeyConstraint("id"),
|
|
)
|
|
op.create_index("ix_update_alerts_user_id", "update_alerts", ["user_id"])
|
|
op.create_index("ix_update_alerts_follow_id", "update_alerts", ["follow_id"])
|
|
op.create_index("ix_update_alerts_platform", "update_alerts", ["platform"])
|
|
op.create_index("ix_update_alerts_creator_id", "update_alerts", ["creator_id"])
|
|
op.create_index("ix_update_alerts_is_read", "update_alerts", ["is_read"])
|
|
|
|
|
|
def downgrade() -> None:
|
|
op.drop_index("ix_update_alerts_is_read", table_name="update_alerts")
|
|
op.drop_index("ix_update_alerts_creator_id", table_name="update_alerts")
|
|
op.drop_index("ix_update_alerts_platform", table_name="update_alerts")
|
|
op.drop_index("ix_update_alerts_follow_id", table_name="update_alerts")
|
|
op.drop_index("ix_update_alerts_user_id", table_name="update_alerts")
|
|
op.drop_table("update_alerts")
|
|
|
|
op.drop_index("ix_creator_follows_enabled", table_name="creator_follows")
|
|
op.drop_index("ix_creator_follows_creator_id", table_name="creator_follows")
|
|
op.drop_index("ix_creator_follows_platform", table_name="creator_follows")
|
|
op.drop_index("ix_creator_follows_user_id", table_name="creator_follows")
|
|
op.drop_table("creator_follows")
|
|
|
|
op.drop_index("ix_novels_last_viewed_at", table_name="novels")
|
|
op.drop_index("ix_novels_series_id", table_name="novels")
|
|
op.drop_column("novels", "last_viewed_at")
|
|
op.drop_column("novels", "chapter_order")
|
|
op.drop_column("novels", "chapter_title")
|
|
op.drop_column("novels", "series_title")
|
|
op.drop_column("novels", "series_id")
|
|
|
|
op.drop_index("ix_artworks_last_viewed_at", table_name="artworks")
|
|
op.drop_index("ix_artworks_content_type", table_name="artworks")
|
|
op.drop_column("artworks", "last_viewed_at")
|
|
op.drop_column("artworks", "content_type")
|