from django.db import models
from datetime import datetime
# Create your models here.



class Skill(models.Model):
    id = models.AutoField(primary_key = True)
    name = models.CharField(max_length=40)
    def __str__(self):
        return str(self.name)



class JobOfferSkill(models.Model):
    id = models.AutoField(primary_key = True)
    skill = models.ManyToManyField(Skill)
    # class Meta:
    #     constraints = [
    #         unique_together = ('skill')
    #     ]
    def __str__(self):
        return str(self.skill)


class JobTypeInfo(models.Model):
    id = models.AutoField(primary_key = True)
    name = models.CharField(max_length=40)
    def __str__(self):
        return str(self.name)



class JobInfo(models.Model):
    id = models.AutoField(primary_key = True)
    text = models.TextField(max_length=40)
    job_type_info = models.ManyToManyField(JobTypeInfo,blank = True)
    # class Meta:
    #     constraints = [
    #         unique_together = ('job_type_info')
    #     ]
    def __str__(self):
        return str(self.job_type_info)



class Language(models.Model):
    id = models.AutoField(primary_key = True)
    name = models.CharField(max_length=40)
    def __str__(self):
        return str(self.name)




class JobOfferLanguage(models.Model):
    id = models.AutoField(primary_key = True)
    language = models.ManyToManyField(Language, blank = True)
    # class Meta:
    #     constraints = [
    #         unique_together = ('language')
    #     ]
    def __str__(self):
        return str(self.language)


class DegreeCourse(models.Model):
    id = models.AutoField(primary_key = True)
    name = models.CharField(max_length=40)

    def __str__(self):
        return str(self.name)


class OfferDegreeCourse(models.Model):
    id = models.AutoField(primary_key = True)
    degree_course = models.ManyToManyField(DegreeCourse)
    # class Meta:
    #     constraints = [
    #         unique_together = ('degree_course')
    #     ]
    def __str__(self):
        return str(self.id)



class JobOffer(models.Model):
    id = models.AutoField(primary_key = True)
    salary_from = models.FloatField()
    salary_to = models.FloatField()
    creation_date = models.DateTimeField(default = datetime.now)
    job_offer_skill = models.ForeignKey(JobOfferSkill, on_delete = models.CASCADE)
    job_info = models.ForeignKey(JobInfo, on_delete = models.CASCADE)
    job_offer_language = models.ForeignKey(JobOfferLanguage, on_delete = models.CASCADE)
    offer_degree_course = models.ForeignKey(OfferDegreeCourse, on_delete = models.CASCADE)


    def __str__(self):
        return str(self.id)