import json
from django.db import models
from django.conf import settings

class Setting(models.Model):
    id = models.BigAutoField(primary_key=True)
    param = models.TextField(unique=True)
    value = models.TextField(null=True)
    comment = models.TextField(null=True)

    class Meta:
        db_table = "setting"

    @staticmethod
    def get_multiple_setting(params):
        return dict(
            Setting.objects.filter(param__in=params).values_list("param", "value")
        )

    @staticmethod
    def get_setting(param):
        return (
            Setting.objects
            .filter(param=param)
            .values_list("value", flat=True)
            .first()
        )