import uuid
from decimal import Decimal

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ("content", "0001_initial"),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        # ------------------------------------------------------------------
        # Enrollment
        # ------------------------------------------------------------------
        migrations.CreateModel(
            name="Enrollment",
            fields=[
                ("id", models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                ("updated_at", models.DateTimeField(auto_now=True)),
                ("status", models.CharField(choices=[("active", "Active"), ("completed", "Completed"), ("dropped", "Dropped")], default="active", max_length=16)),
                ("progress_percent", models.DecimalField(decimal_places=2, default=0, max_digits=5)),
                ("completed_at", models.DateTimeField(blank=True, null=True)),
                ("last_activity_at", models.DateTimeField(blank=True, null=True)),
                ("course", models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name="enrollments", to="content.course")),
                ("course_version", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="enrollments", to="content.courseversion")),
                ("user", models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name="enrollments", to=settings.AUTH_USER_MODEL)),
            ],
            options={"ordering": ["-created_at"]},
        ),
        migrations.AddIndex(
            model_name="enrollment",
            index=models.Index(fields=["user", "status"], name="enrollment_user_status_idx"),
        ),
        migrations.AddIndex(
            model_name="enrollment",
            index=models.Index(fields=["course", "status"], name="enrollment_course_status_idx"),
        ),
        migrations.AddConstraint(
            model_name="enrollment",
            constraint=models.UniqueConstraint(fields=("user", "course"), name="enrollment_unique_course"),
        ),
        migrations.AddConstraint(
            model_name="enrollment",
            constraint=models.CheckConstraint(condition=models.Q(("progress_percent__gte", 0)) & models.Q(("progress_percent__lte", 100)), name="enrollment_progress_range"),
        ),
        # ------------------------------------------------------------------
        # Progress
        # ------------------------------------------------------------------
        migrations.CreateModel(
            name="Progress",
            fields=[
                ("id", models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                ("updated_at", models.DateTimeField(auto_now=True)),
                ("status", models.CharField(choices=[("not_started", "Not started"), ("in_progress", "In progress"), ("completed", "Completed")], default="not_started", max_length=16)),
                ("started_at", models.DateTimeField(blank=True, null=True)),
                ("completed_at", models.DateTimeField(blank=True, null=True)),
                ("score", models.DecimalField(blank=True, decimal_places=2, max_digits=5, null=True)),
                ("enrollment", models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name="lesson_progress", to="learning.enrollment")),
                ("lesson", models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name="progress_records", to="content.lesson")),
            ],
            options={"ordering": ["-updated_at"], "verbose_name_plural": "progress records"},
        ),
        migrations.AddIndex(
            model_name="progress",
            index=models.Index(fields=["enrollment", "status"], name="progress_enroll_status_idx"),
        ),
        migrations.AddConstraint(
            model_name="progress",
            constraint=models.UniqueConstraint(fields=("enrollment", "lesson"), name="progress_unique_lesson"),
        ),
        # ------------------------------------------------------------------
        # SpacedRepetitionCard
        # ------------------------------------------------------------------
        migrations.CreateModel(
            name="SpacedRepetitionCard",
            fields=[
                ("id", models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                ("updated_at", models.DateTimeField(auto_now=True)),
                ("ease_factor", models.DecimalField(decimal_places=2, default=Decimal("2.50"), max_digits=4)),
                ("interval_days", models.PositiveIntegerField(default=0)),
                ("repetitions", models.PositiveIntegerField(default=0)),
                ("due_at", models.DateTimeField(db_index=True, default=django.utils.timezone.now)),
                ("last_reviewed_at", models.DateTimeField(blank=True, null=True)),
                ("last_quality", models.PositiveSmallIntegerField(blank=True, null=True)),
                ("is_suspended", models.BooleanField(default=False)),
                ("problem", models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name="review_cards", to="content.problem")),
                ("user", models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name="review_cards", to=settings.AUTH_USER_MODEL)),
            ],
            options={"ordering": ["due_at"]},
        ),
        migrations.AddIndex(
            model_name="spacedrepetitioncard",
            index=models.Index(fields=["user", "due_at"], name="src_user_due_idx"),
        ),
        migrations.AddConstraint(
            model_name="spacedrepetitioncard",
            constraint=models.UniqueConstraint(fields=("user", "problem"), name="src_unique_user_problem"),
        ),
        migrations.AddConstraint(
            model_name="spacedrepetitioncard",
            constraint=models.CheckConstraint(condition=models.Q(("ease_factor__gte", 1.3)), name="src_ease_factor_min"),
        ),
        migrations.AddConstraint(
            model_name="spacedrepetitioncard",
            constraint=models.CheckConstraint(condition=models.Q(("last_quality__isnull", True)) | models.Q(("last_quality__lte", 5)), name="src_quality_range"),
        ),
        # ------------------------------------------------------------------
        # Bookmark
        # ------------------------------------------------------------------
        migrations.CreateModel(
            name="Bookmark",
            fields=[
                ("id", models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                ("updated_at", models.DateTimeField(auto_now=True)),
                ("note", models.CharField(blank=True, default="", max_length=500)),
                ("course", models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="bookmarks", to="content.course")),
                ("lesson", models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="bookmarks", to="content.lesson")),
                ("problem", models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="bookmarks", to="content.problem")),
                ("user", models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name="bookmarks", to=settings.AUTH_USER_MODEL)),
            ],
            options={"ordering": ["-created_at"]},
        ),
        migrations.AddConstraint(
            model_name="bookmark",
            constraint=models.CheckConstraint(
                condition=(
                    models.Q(("problem__isnull", False), ("course__isnull", True), ("lesson__isnull", True))
                    | models.Q(("problem__isnull", True), ("course__isnull", False), ("lesson__isnull", True))
                    | models.Q(("problem__isnull", True), ("course__isnull", True), ("lesson__isnull", False))
                ),
                name="bookmark_single_target",
            ),
        ),
        migrations.AddConstraint(
            model_name="bookmark",
            constraint=models.UniqueConstraint(condition=models.Q(("problem__isnull", False)), fields=("user", "problem"), name="bookmark_unique_problem"),
        ),
        migrations.AddConstraint(
            model_name="bookmark",
            constraint=models.UniqueConstraint(condition=models.Q(("course__isnull", False)), fields=("user", "course"), name="bookmark_unique_course"),
        ),
        migrations.AddConstraint(
            model_name="bookmark",
            constraint=models.UniqueConstraint(condition=models.Q(("lesson__isnull", False)), fields=("user", "lesson"), name="bookmark_unique_lesson"),
        ),
    ]