from django.db import models


class EsExamActivity(models.Model):
    exam_requirement = models.ForeignKey("api.EsExamRequirement", on_delete=models.CASCADE)
    location = models.ForeignKey("api.EsLocation", on_delete=models.SET_NULL, null=True)
    session = models.ForeignKey("api.EsSession", on_delete=models.SET_NULL, null=True)
    code = models.CharField(max_length=150, unique=True)
    name = models.CharField(max_length=150)
    time_slot = models.BigIntegerField(null=True, db_comment="Time slot in 30-minute units")
    is_scheduled = models.BooleanField(default=False)
    created_by = models.BigIntegerField(null=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_by = models.BigIntegerField(null=True)
    updated_at = models.DateTimeField(auto_now=True)

    invigilator_suitability = models.ManyToManyField(
        "api.EsSuitability",
        through="api.EsExamActivityInvigilatorSuitability",
        related_name="exam_activity_invigilator_suitability",
    )
    location_suitability = models.ManyToManyField(
        "api.EsSuitability",
        through="api.EsExamActivityLocationSuitability",
        related_name="exam_activity_location_suitability",
    )

    class Meta:
        db_table = "es_exam_activity"

    def __str__(self):
        return self.name