from django.contrib.auth import get_user_model
from django.db import models

from dbsynce.models.service_category import ServiceCategory

from dbsynce.docs.database.rating_neg import RatingNeg as HelpTexts
from dbsynce.docs.verbose_names.rating_neg import RatingNeg as VerboseName
from core.settings_vars import METASERVICE_ID

from dbsynce.lib import dicts

class RatingNeg(models.Model):
    """
    RatingNeg - это... FIXME: написать описание таблицы
    """

    # ID METASERVICE
    id_metaservice = models.PositiveIntegerField(
        default=METASERVICE_ID,
        verbose_name = VerboseName.id_metaservice,
        help_text=HelpTexts.id_metaservice,
    )

    # DATA
    count = models.IntegerField(
        verbose_name = VerboseName.count,
        help_text=HelpTexts.count,
    )

    # OTHER
    is_global = models.CharField(
        max_length=1,
        default=False,
        choices = list(dicts.is_global_by_code.items()),
        verbose_name = VerboseName.is_global,
        help_text=HelpTexts.is_global,
    )
    is_visible = models.CharField(
        max_length=1,
        default="f",
        choices = list(dicts.is_visible_by_code.items()),
        verbose_name = VerboseName.is_visible,
        help_text=HelpTexts.is_visible,
    )

    # FK
    user_who = models.ForeignKey(
        get_user_model(),
        related_name="rating_neg_user_who",
        on_delete=models.DO_NOTHING,
        verbose_name = VerboseName.user_who,
        help_text=HelpTexts.user_who,
    )
    user_whom = models.ForeignKey(
        get_user_model(),
        related_name="rating_neg_user_whom",
        on_delete=models.DO_NOTHING,
        verbose_name = VerboseName.user_whom,
        help_text=HelpTexts.user_whom,
    )
    service_category = models.ForeignKey(
        ServiceCategory,
        on_delete=models.DO_NOTHING,
        verbose_name = VerboseName.service_category,
        help_text=HelpTexts.service_category,
    )

    class Meta:
        db_table = "rating_neg"
        verbose_name = "Отрицательная реакция"
        verbose_name_plural = "Отрицательные реакции"