"""Persist privacy-safe client error daily counts.

Revision ID: 476
Revises: 475
"""

import sqlalchemy as sa

from alembic import op

revision = "476"
down_revision = "475"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.create_table(
        "client_error_daily_aggregates",
        sa.Column("id", sa.CHAR(36), primary_key=True),
        sa.Column("day", sa.Date(), nullable=False),
        sa.Column("surface", sa.String(16), nullable=False),
        sa.Column("report_count", sa.Integer(), nullable=False, server_default="0"),
        sa.Column(
            "first_seen_at",
            sa.DateTime(timezone=True),
            nullable=False,
            server_default=sa.func.now(),
        ),
        sa.Column(
            "last_seen_at",
            sa.DateTime(timezone=True),
            nullable=False,
            server_default=sa.func.now(),
        ),
        sa.UniqueConstraint(
            "day",
            "surface",
            name="uq_client_error_daily_day_surface",
        ),
    )
    op.create_index(
        "ix_client_error_daily_day",
        "client_error_daily_aggregates",
        ["day"],
    )


def downgrade() -> None:
    op.drop_index(
        "ix_client_error_daily_day",
        table_name="client_error_daily_aggregates",
    )
    op.drop_table("client_error_daily_aggregates")