"""default calendar sync disabled

Revision ID: 20260527_0009
Revises: 20260526_0008
Create Date: 2026-05-27 14:20:00
"""
from __future__ import annotations

from alembic import op
import sqlalchemy as sa


revision = "20260527_0009"
down_revision = "20260526_0008"
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("users")}

    if "calendar_sync_enabled" in columns:
        op.alter_column(
            "users",
            "calendar_sync_enabled",
            existing_type=sa.Boolean(),
            nullable=False,
            server_default=sa.false(),
        )
        op.execute("UPDATE users SET calendar_sync_enabled = FALSE")


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

    if "calendar_sync_enabled" in columns:
        op.alter_column(
            "users",
            "calendar_sync_enabled",
            existing_type=sa.Boolean(),
            nullable=False,
            server_default=sa.true(),
        )
        op.execute("UPDATE users SET calendar_sync_enabled = TRUE")