import django.db.models.deletion
import uuid
from django.db import migrations, models


POSSESSION_EVENT_CHOICES = [
    ("POSSESSION_START", "Possession start"),
    ("PASS", "Pass"),
    ("CARRY", "Carry / dribble progression"),
    ("RECOVERY", "Ball recovery / retained advantage"),
    ("TURNOVER", "Turnover"),
    ("CHANCE_CREATED", "Chance created"),
    ("SHOT", "Shot within possession"),
    ("SET_PIECE_WON", "Set piece won"),
    ("POSSESSION_END", "Possession end"),
]
PHASE_CHOICES = [
    ("REGULATION", "Regulation"),
    ("EXTRA_TIME", "Extra time"),
    ("SHOOTOUT", "Penalty shootout"),
]


class Migration(migrations.Migration):
    dependencies = [("matches", "0023_goalkeeper_defensive_duel_micro_mechanics")]

    operations = [
        migrations.CreateModel(
            name="MatchPossessionEvent",
            fields=[
                ("id", models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ("sequence", models.PositiveIntegerField()),
                ("possession_sequence", models.PositiveIntegerField()),
                ("action_sequence", models.PositiveSmallIntegerField()),
                ("minute", models.PositiveSmallIntegerField()),
                ("phase", models.CharField(choices=PHASE_CHOICES, max_length=16)),
                ("event_type", models.CharField(choices=POSSESSION_EVENT_CHOICES, max_length=24)),
                ("origin_zone", models.CharField(max_length=24)),
                ("destination_zone", models.CharField(max_length=24)),
                ("channel", models.CharField(max_length=12)),
                ("outcome", models.CharField(blank=True, default="", max_length=32)),
                ("transition_state", models.CharField(default="SETTLED", max_length=16)),
                ("detail_payload", models.JSONField(blank=True, default=dict)),
                ("evidence_hash", models.CharField(max_length=64)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                ("club", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="possession_events_for", to="clubs.club")),
                ("match", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="possession_events", to="matches.match")),
                ("opponent_club", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="possession_events_against", to="clubs.club")),
                ("player", models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name="possession_events", to="players.player")),
                ("run", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="possession_events", to="matches.matchsimulationrun")),
                ("target_player", models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name="target_possession_events", to="players.player")),
            ],
            options={
                "ordering": ["match_id", "sequence"],
                "indexes": [
                    models.Index(fields=["match", "possession_sequence", "action_sequence"], name="poss_evt_match_pos_idx"),
                    models.Index(fields=["club", "match"], name="poss_evt_club_match_idx"),
                    models.Index(fields=["player", "match"], name="poss_evt_player_match_idx"),
                ],
            },
        ),
        migrations.AlterField(
            model_name="interactivematchsession",
            name="engine_version",
            field=models.CharField(default="3.7.0", max_length=64),
        ),
        migrations.AddConstraint(
            model_name="matchpossessionevent",
            constraint=models.UniqueConstraint(fields=("match", "sequence"), name="uq_match_poss_event_seq"),
        ),
        migrations.AddConstraint(
            model_name="matchpossessionevent",
            constraint=models.UniqueConstraint(fields=("match", "possession_sequence", "action_sequence"), name="uq_match_poss_action"),
        ),
        migrations.AddConstraint(
            model_name="matchpossessionevent",
            constraint=models.CheckConstraint(condition=models.Q(sequence__gte=1), name="poss_evt_seq_gte1"),
        ),
        migrations.AddConstraint(
            model_name="matchpossessionevent",
            constraint=models.CheckConstraint(condition=models.Q(possession_sequence__gte=1), name="poss_evt_poss_gte1"),
        ),
        migrations.AddConstraint(
            model_name="matchpossessionevent",
            constraint=models.CheckConstraint(condition=models.Q(action_sequence__gte=1), name="poss_evt_action_gte1"),
        ),
        migrations.AddConstraint(
            model_name="matchpossessionevent",
            constraint=models.CheckConstraint(condition=models.Q(minute__gte=1, minute__lte=120), name="poss_evt_minute_1_120"),
        ),
        migrations.AddConstraint(
            model_name="matchpossessionevent",
            constraint=models.CheckConstraint(condition=models.Q(phase__in=["REGULATION", "EXTRA_TIME", "SHOOTOUT"]), name="poss_evt_valid_phase"),
        ),
        migrations.AddConstraint(
            model_name="matchpossessionevent",
            constraint=models.CheckConstraint(condition=models.Q(event_type__in=[choice[0] for choice in POSSESSION_EVENT_CHOICES]), name="poss_evt_valid_type"),
        ),
        migrations.AddConstraint(
            model_name="matchpossessionevent",
            constraint=models.CheckConstraint(condition=models.Q(origin_zone__in=["DEFENSIVE_THIRD", "MIDDLE_THIRD", "FINAL_THIRD", "PENALTY_AREA"]), name="poss_evt_valid_origin"),
        ),
        migrations.AddConstraint(
            model_name="matchpossessionevent",
            constraint=models.CheckConstraint(condition=models.Q(destination_zone__in=["DEFENSIVE_THIRD", "MIDDLE_THIRD", "FINAL_THIRD", "PENALTY_AREA"]), name="poss_evt_valid_dest"),
        ),
        migrations.AddConstraint(
            model_name="matchpossessionevent",
            constraint=models.CheckConstraint(condition=models.Q(channel__in=["LEFT", "CENTRE", "RIGHT"]), name="poss_evt_valid_channel"),
        ),
        migrations.AddConstraint(
            model_name="matchpossessionevent",
            constraint=models.CheckConstraint(condition=models.Q(transition_state__in=["SETTLED", "BUILDUP", "PROGRESSION", "COUNTER", "SECOND_BALL"]), name="poss_evt_valid_transition"),
        ),
        migrations.AddConstraint(
            model_name="matchpossessionevent",
            constraint=models.CheckConstraint(condition=~models.Q(evidence_hash=""), name="poss_evt_hash_nonempty"),
        ),
    ]
