# Generated for FTG Competition / Fixtures / Match foundation.

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


class Migration(migrations.Migration):
    initial = True

    dependencies = [
        ("clubs", "0003_club_squad_membership"),
        ("leagues", "0002_leaguecompetition"),
    ]

    operations = [
        migrations.CreateModel(
            name="Fixture",
            fields=[
                (
                    "id",
                    models.UUIDField(
                        default=uuid.uuid4,
                        editable=False,
                        primary_key=True,
                        serialize=False,
                    ),
                ),
                ("round_number", models.PositiveSmallIntegerField()),
                ("leg", models.PositiveSmallIntegerField()),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                (
                    "away_club",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.PROTECT,
                        related_name="away_fixtures",
                        to="clubs.club",
                    ),
                ),
                (
                    "competition",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.PROTECT,
                        related_name="fixtures",
                        to="leagues.leaguecompetition",
                    ),
                ),
                (
                    "home_club",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.PROTECT,
                        related_name="home_fixtures",
                        to="clubs.club",
                    ),
                ),
            ],
            options={
                "ordering": ["competition_id", "round_number", "home_club_id"],
                "indexes": [
                    models.Index(
                        fields=["competition", "round_number"],
                        name="fixture_comp_round_idx",
                    ),
                    models.Index(
                        fields=["home_club", "competition"],
                        name="fixture_home_comp_idx",
                    ),
                    models.Index(
                        fields=["away_club", "competition"],
                        name="fixture_away_comp_idx",
                    ),
                ],
                "constraints": [
                    models.CheckConstraint(
                        condition=models.Q(round_number__gte=1, round_number__lte=38),
                        name="fixture_valid_round",
                    ),
                    models.CheckConstraint(
                        condition=models.Q(leg__in=[1, 2]),
                        name="fixture_valid_leg",
                    ),
                    models.CheckConstraint(
                        condition=(
                            models.Q(leg=1, round_number__lte=19)
                            | models.Q(leg=2, round_number__gt=19)
                        ),
                        name="fixture_leg_round_consistent",
                    ),
                    models.CheckConstraint(
                        condition=~models.Q(home_club=models.F("away_club")),
                        name="fixture_distinct_clubs",
                    ),
                    models.UniqueConstraint(
                        fields=("competition", "home_club", "away_club"),
                        name="uq_fixture_ordered_pair",
                    ),
                    models.UniqueConstraint(
                        fields=("competition", "round_number", "home_club"),
                        name="uq_fixture_round_home",
                    ),
                    models.UniqueConstraint(
                        fields=("competition", "round_number", "away_club"),
                        name="uq_fixture_round_away",
                    ),
                ],
            },
        ),
        migrations.CreateModel(
            name="Match",
            fields=[
                (
                    "id",
                    models.UUIDField(
                        default=uuid.uuid4,
                        editable=False,
                        primary_key=True,
                        serialize=False,
                    ),
                ),
                (
                    "status",
                    models.CharField(
                        choices=[
                            ("PENDING", "Pending scheduling"),
                            ("SCHEDULED", "Scheduled"),
                            ("IN_PROGRESS", "In progress"),
                            ("COMPLETED", "Completed"),
                            ("CANCELLED", "Cancelled"),
                        ],
                        default="PENDING",
                        max_length=12,
                    ),
                ),
                ("scheduled_at", models.DateTimeField(blank=True, null=True)),
                ("started_at", models.DateTimeField(blank=True, null=True)),
                ("completed_at", models.DateTimeField(blank=True, null=True)),
                ("cancelled_at", models.DateTimeField(blank=True, null=True)),
                ("home_score", models.PositiveSmallIntegerField(blank=True, null=True)),
                ("away_score", models.PositiveSmallIntegerField(blank=True, null=True)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                ("updated_at", models.DateTimeField(auto_now=True)),
                (
                    "fixture",
                    models.OneToOneField(
                        on_delete=django.db.models.deletion.PROTECT,
                        related_name="match",
                        to="matches.fixture",
                    ),
                ),
            ],
            options={
                "ordering": ["created_at", "id"],
                "indexes": [
                    models.Index(fields=["status"], name="match_status_idx"),
                    models.Index(fields=["scheduled_at"], name="match_scheduled_idx"),
                ],
                "constraints": [
                    models.CheckConstraint(
                        condition=models.Q(status__in=["PENDING", "SCHEDULED", "IN_PROGRESS", "COMPLETED", "CANCELLED"]),
                        name="match_valid_status",
                    ),
                    models.CheckConstraint(
                        condition=(
                            models.Q(
                                status="PENDING",
                                scheduled_at__isnull=True,
                                started_at__isnull=True,
                                completed_at__isnull=True,
                                cancelled_at__isnull=True,
                                home_score__isnull=True,
                                away_score__isnull=True,
                            )
                            | models.Q(
                                status="SCHEDULED",
                                scheduled_at__isnull=False,
                                started_at__isnull=True,
                                completed_at__isnull=True,
                                cancelled_at__isnull=True,
                                home_score__isnull=True,
                                away_score__isnull=True,
                            )
                            | models.Q(
                                status="IN_PROGRESS",
                                scheduled_at__isnull=False,
                                started_at__isnull=False,
                                completed_at__isnull=True,
                                cancelled_at__isnull=True,
                                home_score__isnull=True,
                                away_score__isnull=True,
                            )
                            | models.Q(
                                status="COMPLETED",
                                scheduled_at__isnull=False,
                                started_at__isnull=False,
                                completed_at__isnull=False,
                                cancelled_at__isnull=True,
                                home_score__isnull=False,
                                away_score__isnull=False,
                            )
                            | models.Q(
                                status="CANCELLED",
                                started_at__isnull=True,
                                completed_at__isnull=True,
                                cancelled_at__isnull=False,
                                home_score__isnull=True,
                                away_score__isnull=True,
                            )
                        ),
                        name="match_lifecycle",
                    ),
                    models.CheckConstraint(
                        condition=(
                            models.Q(started_at__isnull=True)
                            | models.Q(completed_at__isnull=True)
                            | models.Q(completed_at__gte=models.F("started_at"))
                        ),
                        name="match_completed_after_start",
                    ),
                ],
            },
        ),
    ]
