from django.db import models
from django.conf import settings
from django.utils.translation import ugettext_lazy as _


class UserExam(models.Model):

    STATUS_REGISTE_SUBMITTED = 0
    STATUS_REGISTE_CONFIRMED = 1
    STATUS_FINSHED = 2

    user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE)
    exam = models.ForeignKey('university.Exam', on_delete=models.CASCADE)
    status = models.SmallIntegerField(choices=(
        (STATUS_REGISTE_SUBMITTED, _('submitted registration, waiting for conformation')),
        (STATUS_REGISTE_CONFIRMED, _('registered successfuly')),
        (STATUS_FINSHED, _('finshed'))
    ), default=STATUS_REGISTE_SUBMITTED)
    exam_time = models.DateTimeField(blank=False, null=False)
    exam_venue = models.CharField(max_length=255, blank=False, null=False)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)

    class Meta:
        db_table = 'user_exams'