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


class Migration(migrations.Migration):
    dependencies = [("matches", "0015_draw_generation_governance")]

    operations = [
        migrations.AddField(
            model_name="fixture",
            name="replay_of_fixture",
            field=models.ForeignKey(
                null=True, blank=True, editable=False,
                on_delete=django.db.models.deletion.PROTECT,
                related_name="replay_fixtures",
                to="matches.fixture",
            ),
        ),
        migrations.AddField(
            model_name="fixture",
            name="replay_sequence",
            field=models.PositiveSmallIntegerField(default=0, editable=False),
        ),
        migrations.RemoveConstraint(model_name="fixture", name="uq_fixture_league_pair"),
        migrations.RemoveConstraint(model_name="fixture", name="uq_fixture_league_r_home"),
        migrations.RemoveConstraint(model_name="fixture", name="uq_fixture_league_r_away"),
        migrations.RemoveConstraint(model_name="fixture", name="uq_fixture_fed_gen_pair"),
        migrations.RemoveConstraint(model_name="fixture", name="uq_fixture_fed_gen_home"),
        migrations.RemoveConstraint(model_name="fixture", name="uq_fixture_fed_gen_away"),
        migrations.AddConstraint(
            model_name="fixture",
            constraint=models.CheckConstraint(
                condition=(
                    models.Q(("replay_of_fixture__isnull", True), ("replay_sequence", 0))
                    | models.Q(("replay_of_fixture__isnull", False), ("replay_sequence__gte", 1))
                ),
                name="fixture_replay_metadata_consistent",
            ),
        ),
        migrations.AddConstraint(
            model_name="fixture",
            constraint=models.UniqueConstraint(
                fields=("competition", "home_club", "away_club"),
                condition=models.Q(competition__isnull=False, replay_of_fixture__isnull=True),
                name="uq_fixture_league_pair",
            ),
        ),
        migrations.AddConstraint(
            model_name="fixture",
            constraint=models.UniqueConstraint(
                fields=("competition", "round_number", "home_club"),
                condition=models.Q(competition__isnull=False, replay_of_fixture__isnull=True),
                name="uq_fixture_league_r_home",
            ),
        ),
        migrations.AddConstraint(
            model_name="fixture",
            constraint=models.UniqueConstraint(
                fields=("competition", "round_number", "away_club"),
                condition=models.Q(competition__isnull=False, replay_of_fixture__isnull=True),
                name="uq_fixture_league_r_away",
            ),
        ),
        migrations.AddConstraint(
            model_name="fixture",
            constraint=models.UniqueConstraint(
                fields=("federation_competition", "draw_generation", "round_number", "home_club", "away_club"),
                condition=models.Q(federation_competition__isnull=False, replay_of_fixture__isnull=True),
                name="uq_fixture_fed_gen_pair",
            ),
        ),
        migrations.AddConstraint(
            model_name="fixture",
            constraint=models.UniqueConstraint(
                fields=("federation_competition", "draw_generation", "round_number", "home_club"),
                condition=models.Q(federation_competition__isnull=False, replay_of_fixture__isnull=True),
                name="uq_fixture_fed_gen_home",
            ),
        ),
        migrations.AddConstraint(
            model_name="fixture",
            constraint=models.UniqueConstraint(
                fields=("federation_competition", "draw_generation", "round_number", "away_club"),
                condition=models.Q(federation_competition__isnull=False, replay_of_fixture__isnull=True),
                name="uq_fixture_fed_gen_away",
            ),
        ),
        migrations.AddConstraint(
            model_name="fixture",
            constraint=models.UniqueConstraint(
                fields=("replay_of_fixture", "replay_sequence"),
                condition=models.Q(replay_of_fixture__isnull=False),
                name="uq_fixture_replay_sequence",
            ),
        ),
    ]
