51 lines
1.7 KiB
Python
51 lines
1.7 KiB
Python
"""Add cloud_favorites table for photo likes/favorites.
|
|
|
|
Revision ID: 20260726_0002
|
|
Revises: 20260718_0001
|
|
Create Date: 2026-07-26
|
|
"""
|
|
|
|
from typing import Sequence
|
|
|
|
from alembic import op
|
|
import sqlalchemy as sa
|
|
|
|
|
|
revision: str = "20260726_0002"
|
|
down_revision: str | None = "20260718_0001"
|
|
branch_labels: str | Sequence[str] | None = None
|
|
depends_on: str | Sequence[str] | None = None
|
|
|
|
|
|
def upgrade() -> None:
|
|
op.create_table(
|
|
"cloud_favorites",
|
|
sa.Column("id", sa.Uuid(), nullable=False),
|
|
sa.Column("user_id", sa.Uuid(), nullable=False),
|
|
sa.Column("cloud_id", sa.Uuid(), nullable=False),
|
|
sa.Column(
|
|
"created_at",
|
|
sa.DateTime(timezone=True),
|
|
server_default=sa.text("now()"),
|
|
nullable=False,
|
|
),
|
|
sa.ForeignKeyConstraint(["cloud_id"], ["clouds.id"], ondelete="CASCADE"),
|
|
sa.ForeignKeyConstraint(["user_id"], ["users.id"], ondelete="CASCADE"),
|
|
sa.PrimaryKeyConstraint("id"),
|
|
sa.UniqueConstraint("user_id", "cloud_id", name="uq_cloud_favorites_user_cloud"),
|
|
)
|
|
op.create_index("ix_cloud_favorites_user_id", "cloud_favorites", ["user_id"])
|
|
op.create_index("ix_cloud_favorites_cloud_id", "cloud_favorites", ["cloud_id"])
|
|
op.create_index(
|
|
"ix_cloud_favorites_user_created",
|
|
"cloud_favorites",
|
|
["user_id", sa.text("created_at DESC"), sa.text("id DESC")],
|
|
)
|
|
|
|
|
|
def downgrade() -> None:
|
|
op.drop_index("ix_cloud_favorites_user_created", table_name="cloud_favorites")
|
|
op.drop_index("ix_cloud_favorites_cloud_id", table_name="cloud_favorites")
|
|
op.drop_index("ix_cloud_favorites_user_id", table_name="cloud_favorites")
|
|
op.drop_table("cloud_favorites")
|