"""add recording url refresh timestamp

Revision ID: 20260603_0010
Revises: 20260527_0009
Create Date: 2026-06-03 15:30:00
"""
from __future__ import annotations

from alembic import op
import sqlalchemy as sa


revision = "20260603_0010"
down_revision = "20260527_0009"
branch_labels = None
depends_on = None


def upgrade() -> None:
    bind = op.get_bind()
    inspector = sa.inspect(bind)
    columns = {column["name"] for column in inspector.get_columns("recordings")}

    if "download_urls_refreshed_at" not in columns:
        op.add_column(
            "recordings",
            sa.Column("download_urls_refreshed_at", sa.DateTime(timezone=True), nullable=True),
        )


def downgrade() -> None:
    bind = op.get_bind()
    inspector = sa.inspect(bind)
    columns = {column["name"] for column in inspector.get_columns("recordings")}

    if "download_urls_refreshed_at" in columns:
        op.drop_column("recordings", "download_urls_refreshed_at")