from django.db import models

class User(models.Model):
        name = models.CharField(max_length=64,  default="no name yet", unique=True)
        password = models.CharField(max_length=64,  default="no password yet")
        user_email =   models.CharField(max_length=64,  null=True, blank=True ,unique=True)
        user_status =  models.CharField(max_length=15,  null=True, blank=True)
        passed_quizes = models.ManyToManyField('PassedQuiz', blank=True, related_name='passed_quizes')
        course_subscriptions = models.ManyToManyField('Course', blank=True, related_name='course_subscriptions')




class SearchTags(models.Model):
        name = models.CharField(max_length=64, default="no name yet", unique=True)



class Course(models.Model):
        name = models.CharField(max_length=64, unique=True)
        search_tags = models.ManyToManyField('SearchTags', blank=True, related_name='search_tags')
        description = models.CharField(max_length=500,  null=True, blank=True)
        course_creator = models.ForeignKey(User, on_delete=models.CASCADE)
        created_on = models.DateTimeField(auto_now_add=True)
        updated_on = models.DateTimeField(auto_now=True)



class Lesson(models.Model):
        name = models.CharField(max_length=64)
        description = models.CharField(max_length=500, null=True, blank=True)
        course = models.ForeignKey(Course, on_delete=models.CASCADE)
        created_on = models.DateTimeField(auto_now_add=True)
        updated_on = models.DateTimeField(auto_now=True)

        class Meta:
                unique_together = ("name", "course")

class Document(models.Model):
    docfile = models.FileField(upload_to='documents/%Y/%m/%d')
    belong_to_lesson = models.ForeignKey(Lesson, on_delete=models.CASCADE,null=True, blank=True)
    created_on = models.DateTimeField(auto_now_add=True)
    updated_on = models.DateTimeField(auto_now=True)

class Chat(models.Model):
        course = models.OneToOneField(Course, on_delete=models.CASCADE)

class Messages(models.Model):
        text = models.CharField(max_length=500)
        author =  models.CharField(max_length=50)
        belong_to_chat = models.ForeignKey(Chat, on_delete=models.CASCADE)
        created_on = models.DateTimeField(auto_now_add=True)



class TestQuiz(models.Model):
        title = models.CharField(max_length=64,  default="no title yet")
        quiz_in_json = models.CharField(max_length=1024,  default="no title yet")
        belong_to_lesson = models.ForeignKey(Lesson, on_delete=models.CASCADE,default=None)
      #  questions = models.ManyToManyField('Question', blank=True, related_name='posts')


class TestQuestion(models.Model):
        title = models.CharField(max_length=64,  default="no title yet")
        belong_to_quiz = models.ForeignKey(TestQuiz, on_delete=models.CASCADE)
     #   variant_result_pair = models.ManyToManyField('VariantResult', blank=True, related_name='posts')


class TestQuestionVariantResult(models.Model):
        suggested_choice = models.CharField(max_length=64,  default="no title yet")
        correct_choice = models.CharField(max_length=64, default="no title yet")
        belong_to_question =  models.ForeignKey(TestQuestion, on_delete=models.CASCADE)


class PassedTestQuiz(models.Model):
        test_quiz = models.ForeignKey(TestQuiz, on_delete=models.CASCADE)
        test_quiz_user = models.ForeignKey(User, on_delete=models.CASCADE,default=None)
        test_quiz_pass_attempt = models.IntegerField(default=0)
        class Meta:
                unique_together = ("test_quiz", "test_quiz_user","test_quiz_pass_attempt")
       # quiz_passed_username = models.CharField(max_length=64,default=None)



class QuestionAnswerResult(models.Model):
        question =  models.CharField(max_length=64,  default="no question yet")
        answer = models.CharField(max_length=64,  default="no question yet")
       # correctanswer = models.CharField(max_length=64,  default="no question yet")
        belong_to_quiz = models.ForeignKey(PassedTestQuiz, on_delete=models.CASCADE,default=None)