constant.py

class DatabaseTYPE:
    ENUMS = "ENUMS"
    BIGINT = "BIGINT"
    DT = "DATETIME"
    TS = "TIMESTAMP"


UNIT_10K = 10000

# SELECT DISTINCT jsonb_array_elements ( "capabilities" ) AS v FROM screen ORDER BY v;
SCREEN_CAPABILITIES = (
    "2D",
    "3D",
    "4DX",
    "5.1",
    "7.1",
)

# SELECT DISTINCT jsonb_array_elements ( "cpl_priority" ) AS v FROM screen ORDER BY v;
SCREEN_CPL_PRIORITY = (
    {"name": "cc"},
    {"name": "hi"},
    {"name": "vi"},
    {"name": "audio", "value": "5.1"},
    {"name": "audio", "value": "7.1"},
    {"name": "audio", "value": "atmos"},
    {"name": "audio", "value": "auro"},
    {"name": "audio", "value": "dts"},
)

# SELECT DISTINCT "type" v FROM device ORDER BY v;
DEVICE_TYPE = (
    "axis",
    "barco",
    "cd",
    "christie",
    "christie_series_3",
)

# SELECT DISTINCT category v FROM device ORDER BY v;
DEVICE_CATEGORY = (
    "audio",
    "automation",
    "camera",
    "content",
    "external",
)

# SELECT DISTINCT model v FROM device ORDER BY v;
DEVICE_MODEL = (
    "BARCO DP PROJECTOR",
    "BARCO ICMP",
    "CHR-IMB-S2",
    "CHR-IMB-S3",
    "CINEMA",
)

# SELECT DISTINCT edit_rate v FROM cpl ORDER BY v;
CPL_EDIT_RATE = (
    24,
    25,
    30,
    48,
    50,
    60,
    96,
)

# SELECT DISTINCT frame_rate v FROM cpl ORDER BY v;
CPL_FRAME_RATE = (
    24,
    25,
    30,
    48,
    50,
    60,
    96,
    100,
    120,
)

#
CPL_AUDIO_FORMATS = (
    "1.0",
    "2.0",
    "5.1",
    "7.1",
    "ATMOS",
)

# SELECT DISTINCT audio_language v FROM cpl ORDER BY v;
CPL_AUDIO_LANGUAGE = (
    "af",
    "am",
    "ar",
    "as",
    "aus",
    "be",
    "bg",
    "bn",
    "bs",
    "bts",
    "ca",
    "cam",
    "ch",
    "chn",
    "cmn",
    "cmn-Hans",
    "cmn-Hant",
    "cmn-TW",
    "cmn-hans",
    "cmn-hant",
    "cmn-tw",
    "cri",
    "cs",
    "da",
    "da-dk",
    "da-us",
    "de",
    "de-de",
    "de-us",
    "dz",
    "el",
    "en",
    "en-au",
    "en-de",
    "en-gb",
    "en-mx",
    "en-us",
    "es",
    "es-419",
    "es-AR",
    "es-MX",
    "es-ar",
    "es-es",
    "es-mx",
    "es-us",
    "et",
    "eu",
    "fa",
    "fi",
    "fil",
    "fr",
    "fr-CA",
    "fr-ca",
    "fr-ch",
    "ga",
    "gal",
    "gd",
    "gl",
    "gn",
    "gsw",
    "gu",
    "guc",
    "ha",
    "haz",
    "he",
    "hi",
    "hi-in",
    "hnd",
    "hr",
    "hu",
    "hy",
    "id",
    "ie",
    "int",
    "is",
    "is-is",
    "it",
    "it-it",
    "ja",
    "jul",
    "ka",
    "kk",
    "km",
    "kn",
    "ko",
    "kok",
    "kr",
    "ks",
    "ky",
    "lt",
    "lv",
    "mia",
    "mk",
    "ml",
    "mn",
    "mr",
    "ms",
    "mul",
    "mwr",
    "my",
    "nan",
    "nap",
    "ne",
    "nl",
    "nl-be",
    "nl-nl",
    "no",
    "none",
    "or",
    "pa",
    "pl",
    "pnj",
    "prs",
    "pt",
    "pt-BR",
    "pt-br",
    "pt-us",
    "qu",
    "ro",
    "ru",
    "sa",
    "sah",
    "se",
    "sen",
    "si",
    "sk",
    "sl",
    "sm",
    "sq",
    "sr",
    "ss",
    "sv",
    "sw",
    "ta",
    "te",
    "te-in",
    "th",
    "tl",
    "tn",
    "to",
    "tr",
    "trl",
    "uk",
    "und",
    "und-us",
    "und-x",
    "ur",
    "vi",
    "vls",
    "vo",
    "wo",
    "yak",
    "yi",
    "yue",
    "za",
    "zh",
    "zlm",
)

# SELECT DISTINCT aspect_ratio_active_area v FROM cpl ORDER BY v;
CPL_ASPECT_RATIO_ACTIVE_AREA = (
    0.00,
    1.00,
    1.19,
    1.25,

)

# SELECT DISTINCT content_kind v FROM cpl ORDER BY v;
CPL_CONTENT_KIND = (
    "advertisement",
    "feature",
    "policy",
    "promo",
    "psa",
    "rating",
    "short",
    "short subject",
    "teaser",
    "test",
    "trailer",
    "transitional",
)