# Part 7 — practical submissions + assessment label (NOT APPLIED YET)
# Review, then: python manage.py migrate courses 0011

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


class Migration(migrations.Migration):

    dependencies = [
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
        ('courses', '0010_course_certificates'),
    ]

    operations = [
        migrations.AddField(
            model_name='course',
            name='practical_instructions',
            field=models.TextField(blank=True, help_text='Shown to candidates after they pass the MCQ (GitHub/Figma/ZIP expectations).'),
        ),
        migrations.AddField(
            model_name='course',
            name='practical_rubric',
            field=models.TextField(blank=True, help_text='Reviewer checklist for the practical component.'),
        ),
        migrations.AddField(
            model_name='coursecertificate',
            name='assessment_type',
            field=models.CharField(choices=[('knowledge', 'Knowledge Assessment'), ('theory_practical', 'Theory + Practical Assessment')], default='knowledge', help_text='Printed on the certificate: Knowledge vs Theory + Practical.', max_length=32),
        ),
        migrations.CreateModel(
            name='PracticalSubmission',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('submission_type', models.CharField(choices=[('github_link', 'GitHub repository link'), ('figma_link', 'Figma file link'), ('file_upload', 'File upload (ZIP)')], max_length=20)),
                ('submission_url', models.URLField(blank=True, help_text='GitHub or Figma link when submission_type is a link.')),
                ('submission_file', models.FileField(blank=True, help_text='ZIP / file upload when submission_type is file_upload.', null=True, upload_to='practical_submissions/')),
                ('status', models.CharField(choices=[('pending', 'Pending review'), ('approved', 'Approved'), ('needs_revision', 'Needs revision'), ('rejected', 'Rejected')], db_index=True, default='pending', max_length=20)),
                ('reviewer_notes', models.TextField(blank=True, help_text='Shown to the candidate on rejection or resubmission requests.')),
                ('submitted_at', models.DateTimeField(auto_now_add=True)),
                ('reviewed_at', models.DateTimeField(blank=True, null=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('attempt', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='practical_submissions', to='courses.courseexamattempt')),
                ('course', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='practical_submissions', to='courses.course')),
                ('reviewed_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='reviewed_practical_submissions', to=settings.AUTH_USER_MODEL)),
                ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='practical_submissions', to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'verbose_name': 'Practical submission',
                'verbose_name_plural': 'Practical submissions',
                'ordering': ['-submitted_at'],
            },
        ),
        migrations.AddIndex(
            model_name='practicalsubmission',
            index=models.Index(fields=['status', 'submitted_at'], name='practical_queue_idx'),
        ),
        migrations.AddConstraint(
            model_name='practicalsubmission',
            constraint=models.UniqueConstraint(fields=('attempt',), name='uniq_practical_per_attempt'),
        ),
    ]