import uuid

from django.conf import settings
from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):
    dependencies = [
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
        ("matches", "0012_live_tactics_match_intelligence_engine"),
    ]

    operations = [
        migrations.AddField(
            model_name="match",
            name="execution_mode",
            field=models.CharField(
                choices=[("AUTO", "Automatic simulation"), ("INTERACTIVE", "Interactive live runner")],
                default="AUTO",
                max_length=16,
            ),
        ),
        migrations.AddConstraint(
            model_name="match",
            constraint=models.CheckConstraint(
                condition=models.Q(execution_mode__in=["AUTO", "INTERACTIVE"]),
                name="match_valid_execution_mode",
            ),
        ),
        migrations.CreateModel(
            name="InteractiveMatchSession",
            fields=[
                ("id", models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ("status", models.CharField(choices=[
                    ("PREPARED", "Prepared before kickoff"),
                    ("OPEN", "Live command window open"),
                    ("COMPLETED", "Interactive match completed"),
                    ("ABORTED", "Interactive runner aborted"),
                ], default="PREPARED", max_length=16)),
                ("engine_key", models.CharField(default="ftg.match.v2.interactive", max_length=64)),
                ("engine_version", models.CharField(default="2.2.0", max_length=64)),
                ("current_segment", models.PositiveSmallIntegerField(default=0)),
                ("current_minute", models.PositiveSmallIntegerField(default=0)),
                ("home_score", models.PositiveSmallIntegerField(default=0)),
                ("away_score", models.PositiveSmallIntegerField(default=0)),
                ("revision", models.PositiveIntegerField(default=0)),
                ("segment_duration_seconds", models.PositiveSmallIntegerField(default=60)),
                ("next_advance_at", models.DateTimeField(blank=True, null=True)),
                ("completed_at", models.DateTimeField(blank=True, null=True)),
                ("aborted_at", models.DateTimeField(blank=True, null=True)),
                ("policy_key", models.CharField(default="ftg.match.interactive_runner.v1", max_length=100)),
                ("policy_version", models.CharField(default="1.0.0", max_length=30)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                ("updated_at", models.DateTimeField(auto_now=True)),
                ("match", models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, related_name="interactive_session", to="matches.match")),
                ("snapshot", models.OneToOneField(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name="interactive_session", to="matches.matchsimulationsnapshot")),
            ],
            options={
                "ordering": ["match_id"],
                "indexes": [models.Index(fields=["status", "next_advance_at"], name="live_session_due_idx")],
                "constraints": [
                    models.CheckConstraint(condition=models.Q(status__in=["PREPARED", "OPEN", "COMPLETED", "ABORTED"]), name="live_session_valid_status"),
                    models.CheckConstraint(condition=models.Q(current_segment__gte=0, current_segment__lte=8), name="live_session_segment_0_8"),
                    models.CheckConstraint(condition=models.Q(current_minute__gte=0, current_minute__lte=120), name="live_session_minute_0_120"),
                    models.CheckConstraint(condition=models.Q(segment_duration_seconds__gte=5, segment_duration_seconds__lte=900), name="live_session_duration_5_900"),
                    models.CheckConstraint(
                        condition=(
                            models.Q(status="PREPARED", snapshot__isnull=True, next_advance_at__isnull=True, completed_at__isnull=True, aborted_at__isnull=True)
                            | models.Q(status="OPEN", snapshot__isnull=False, next_advance_at__isnull=False, completed_at__isnull=True, aborted_at__isnull=True)
                            | models.Q(status="COMPLETED", snapshot__isnull=False, next_advance_at__isnull=True, completed_at__isnull=False, aborted_at__isnull=True)
                            | models.Q(status="ABORTED", next_advance_at__isnull=True, completed_at__isnull=True, aborted_at__isnull=False)
                        ),
                        name="live_session_lifecycle",
                    ),
                ],
            },
        ),
        migrations.CreateModel(
            name="LiveMatchCommand",
            fields=[
                ("id", models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ("sequence", models.PositiveIntegerField()),
                ("idempotency_key", models.CharField(max_length=64)),
                ("command_type", models.CharField(choices=[("TACTICS", "Change live tactics"), ("SUBSTITUTION", "Manual substitution")], max_length=16)),
                ("effective_segment", models.PositiveSmallIntegerField()),
                ("submitted_minute", models.PositiveSmallIntegerField(default=0)),
                ("expected_revision", models.PositiveIntegerField()),
                ("payload", models.JSONField(default=dict)),
                ("command_hash", models.CharField(max_length=64)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                ("actor", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="live_match_commands", to=settings.AUTH_USER_MODEL)),
                ("club", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="live_match_commands", to="clubs.club")),
                ("session", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="commands", to="matches.interactivematchsession")),
            ],
            options={
                "ordering": ["session_id", "sequence"],
                "indexes": [models.Index(fields=["session", "club", "effective_segment"], name="live_cmd_segment_idx")],
                "constraints": [
                    models.UniqueConstraint(fields=("session", "sequence"), name="uq_live_cmd_sequence"),
                    models.UniqueConstraint(fields=("session", "club", "idempotency_key"), name="uq_live_cmd_idempotency"),
                    models.CheckConstraint(condition=models.Q(sequence__gte=1), name="live_cmd_sequence_gte1"),
                    models.CheckConstraint(condition=models.Q(command_type__in=["TACTICS", "SUBSTITUTION"]), name="live_cmd_valid_type"),
                    models.CheckConstraint(condition=models.Q(effective_segment__gte=1, effective_segment__lte=8), name="live_cmd_segment_1_8"),
                    models.CheckConstraint(condition=models.Q(submitted_minute__gte=0, submitted_minute__lte=120), name="live_cmd_minute_0_120"),
                    models.CheckConstraint(condition=~models.Q(idempotency_key=""), name="live_cmd_idempotency_nonempty"),
                    models.CheckConstraint(condition=~models.Q(command_hash=""), name="live_cmd_hash_nonempty"),
                ],
            },
        ),
        migrations.CreateModel(
            name="InteractiveMatchCheckpoint",
            fields=[
                ("id", models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ("segment", models.PositiveSmallIntegerField()),
                ("start_minute", models.PositiveSmallIntegerField()),
                ("end_minute", models.PositiveSmallIntegerField()),
                ("phase", models.CharField(choices=[("REGULATION", "Regulation"), ("EXTRA_TIME", "Extra time"), ("SHOOTOUT", "Penalty shootout")], max_length=16)),
                ("home_score", models.PositiveSmallIntegerField()),
                ("away_score", models.PositiveSmallIntegerField()),
                ("events_payload", models.JSONField(default=list)),
                ("tactical_decisions_payload", models.JSONField(default=list)),
                ("command_sequence", models.PositiveIntegerField(default=0)),
                ("projection_hash", models.CharField(max_length=64)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                ("session", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="checkpoints", to="matches.interactivematchsession")),
            ],
            options={
                "ordering": ["session_id", "segment"],
                "constraints": [
                    models.UniqueConstraint(fields=("session", "segment"), name="uq_live_checkpoint_segment"),
                    models.CheckConstraint(condition=models.Q(segment__gte=1, segment__lte=8), name="live_checkpoint_segment_1_8"),
                    models.CheckConstraint(condition=models.Q(start_minute__gte=1, start_minute__lte=120), name="live_checkpoint_start_1_120"),
                    models.CheckConstraint(condition=models.Q(end_minute__gte=1, end_minute__lte=120), name="live_checkpoint_end_1_120"),
                    models.CheckConstraint(condition=models.Q(end_minute__gte=models.F("start_minute")), name="live_checkpoint_end_after_start"),
                    models.CheckConstraint(condition=models.Q(phase__in=["REGULATION", "EXTRA_TIME"]), name="live_checkpoint_field_phase"),
                    models.CheckConstraint(condition=~models.Q(projection_hash=""), name="live_checkpoint_hash_nonempty"),
                ],
            },
        ),
        migrations.AddField(
            model_name="matchtacticaldecision",
            name="live_command",
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name="tactical_decisions", to="matches.livematchcommand"),
        ),
        migrations.AlterField(
            model_name="matchtacticaldecision",
            name="source",
            field=models.CharField(choices=[
                ("USER_RULE", "Preconfigured tactical rule"),
                ("AUTO_ADAPTATION", "Coach automatic adaptation"),
                ("LIVE_COMMAND", "Interactive live command"),
            ], max_length=20),
        ),
        migrations.AlterField(
            model_name="matchtacticaldecision",
            name="trigger_type",
            field=models.CharField(choices=[
                ("MINUTE", "Minute reached"), ("TRAILING", "Trailing"), ("LEADING", "Leading"),
                ("DRAWING", "Drawing"), ("SELF_RED_CARD", "Own player sent off"),
                ("OPPONENT_RED_CARD", "Opponent player sent off"), ("LIVE_COMMAND", "Interactive live command"),
            ], max_length=24),
        ),
        migrations.RemoveConstraint(model_name="matchtacticaldecision", name="tactic_decision_valid_source"),
        migrations.RemoveConstraint(model_name="matchtacticaldecision", name="tactic_decision_valid_trigger"),
        migrations.AddConstraint(
            model_name="matchtacticaldecision",
            constraint=models.CheckConstraint(condition=models.Q(source__in=["USER_RULE", "AUTO_ADAPTATION", "LIVE_COMMAND"]), name="tactic_decision_valid_source"),
        ),
        migrations.AddConstraint(
            model_name="matchtacticaldecision",
            constraint=models.CheckConstraint(condition=models.Q(trigger_type__in=["MINUTE", "TRAILING", "LEADING", "DRAWING", "SELF_RED_CARD", "OPPONENT_RED_CARD", "LIVE_COMMAND"]), name="tactic_decision_valid_trigger"),
        ),
    ]
