from django.db import models


class Vacancy(models.Model):
    id = models.CharField(max_length=255, primary_key=True)
    title = models.CharField(max_length=255, null=True, blank=True)
    description = models.TextField(null=True, blank=True)
    min_payment = models.IntegerField(null=True, blank=True)
    max_payment = models.IntegerField(null=True, blank=True)
    payment_currency = models.CharField(max_length=255, null=True, blank=True)
    payment_type = models.CharField(max_length=255, null=True, blank=True)
    payment_period = models.CharField(max_length=255, null=True, blank=True)
    work_experience = models.CharField(max_length=255, null=True, blank=True)
    type_of_employment = models.CharField(max_length=255, null=True, blank=True)
    work_schedule = models.CharField(max_length=255, null=True, blank=True)
    work_format = models.CharField(max_length=255, null=True, blank=True)
    link = models.CharField(max_length=255, null=True, blank=True)
    address = models.CharField(max_length=255, null=True, blank=True)
    created_at = models.DateTimeField(null=True, blank=True)
    company = models.CharField(max_length=255, null=True, blank=True)
    processed = models.BooleanField()
    source = models.CharField()

    objects = models.Manager()

    def __str__(self):
        return f'{self.source}: {self.company} -> {self.id} {self.title}'

    class Meta:
        managed = False
        db_table = "vacancies"
        verbose_name_plural = 'Vacancies'