"""initial schema

Revision ID: 0001_initial

Revises:

Create Date: 2026-06-11

Builds the full schema from the SQLAlchemy metadata and adds ALPR-specific performance

indexes (trigram for partial-plate search, time+camera composite) and optional extensions.

Using metadata.create_all keeps the migration in lock-step with the models for the MVP; later

schema changes are authored as incremental, reversible revisions.

"""

from alembic import op

from sqlalchemy import text

from app.db.base import Base

import app.models

revision = "0001_initial"

down_revision = None

branch_labels = None

depends_on = None

def upgrade() -> None:

    bind = op.get_bind()

    try:

        bind.execute(text("CREATE EXTENSION IF NOT EXISTS pg_trgm"))

    except Exception:

        pass

    Base.metadata.create_all(bind=bind)

    try:

        bind.execute(text(

            "CREATE INDEX IF NOT EXISTS ix_plates_norm_trgm "

            "ON license_plates USING gin (plate_norm gin_trgm_ops)"))

        bind.execute(text(

            "CREATE INDEX IF NOT EXISTS ix_reads_norm_trgm "

            "ON plate_reads USING gin (plate_norm gin_trgm_ops)"))

    except Exception:

        pass

def downgrade() -> None:

    bind = op.get_bind()

    Base.metadata.drop_all(bind=bind)