"""Add multilingual support to glossaries

Revision ID: d4a1f8e2b3c7
Revises: cb71a958ad92
Create Date: 2026-05-16

Adds source_language to glossaries and translations JSON to glossary_terms.
"""

from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa

# revision identifiers
revision = "d4a1f8e2b3c7"
down_revision = "006"
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    op.add_column(
        "glossaries",
        sa.Column("source_language", sa.String(10), nullable=False, server_default="fr"),
    )
    op.add_column(
        "glossary_terms",
        sa.Column("translations", sa.JSON, nullable=True),
    )


def downgrade() -> None:
    op.drop_column("glossary_terms", "translations")
    op.drop_column("glossaries", "source_language")
