"""Buildooor hire dayrate availability defaults

Revision ID: 000000000014
Revises: 000000000013
Create Date: 2026-02-22

TM-014: Update Buildooor dayrate schedule to wed/sun AM/PM defaults.
"""

from alembic import op

revision = "000000000014"
down_revision = "000000000013"
branch_labels = None
depends_on = None


def upgrade() -> None:
    """Configure Buildooor availability to Wednesday + Sunday, AM/PM."""
    sql = """
        UPDATE dayrate_config
        SET available_days = ARRAY['wednesday', 'sunday']::text[],
            slots = ARRAY['AM', 'PM']::text[],
            updated_at = NOW()
        WHERE application_id = '91057ad9-4380-47c5-9393-69db91c5080d'::uuid;
    """
    op.execute(sql)


def downgrade() -> None:
    """Revert Buildooor availability to Thursday + Saturday, AM/PM defaults."""
    sql = """
        UPDATE dayrate_config
        SET available_days = ARRAY['thursday', 'saturday']::text[],
            slots = ARRAY['AM', 'PM']::text[],
            updated_at = NOW()
        WHERE application_id = '91057ad9-4380-47c5-9393-69db91c5080d'::uuid;
    """
    op.execute(sql)