from typing import Literal

# Fields from FanDataListOrderBy whose values are textual and should be
# ordered case-insensitively. Names are in snake_case — the form
# `fansifter_common.adapters.db.jinja2sql_filters.orderby_filter` compares
# against after applying its `transform_to="snakecase"` normalization.
FanDataListCIFields: tuple[str, ...] = ("name",)

FanDataListOrderBy = Literal[
    "name.asc",
    "name.desc",
    "fansCount.asc",
    "fansCount.desc",
    "fansCount7DaysChange.asc",
    "fansCount7DaysChange.desc",
    "fansCount28DaysChange.asc",
    "fansCount28DaysChange.desc",
    "fansCount6MonthChange.asc",
    "fansCount6MonthChange.desc",
    "fansCount1YearChange.asc",
    "fansCount1YearChange.desc",
    "fansCount7DaysPercentChange.asc",
    "fansCount7DaysPercentChange.desc",
    "fansCount28DaysPercentChange.asc",
    "fansCount28DaysPercentChange.desc",
    "fansCount6MonthPercentChange.asc",
    "fansCount6MonthPercentChange.desc",
    "fansCount1YearPercentChange.asc",
    "fansCount1YearPercentChange.desc",
    "spotifyMonthlyListeners.asc",
    "spotifyMonthlyListeners.desc",
    "instagramFollowers.asc",
    "instagramFollowers.desc",
    "tiktokFollowers.asc",
    "tiktokFollowers.desc",
    "spotifyFollowers.asc",
    "spotifyFollowers.desc",
    "facebookFollowers.asc",
    "facebookFollowers.desc",
    "youtubeFollowers.asc",
    "youtubeFollowers.desc",
    "twitterFollowers.asc",
    "twitterFollowers.desc",
    "soundcloudFollowers.asc",
    "soundcloudFollowers.desc",
    "deezerFollowers.asc",
    "deezerFollowers.desc",
    "engagementBenchmark.asc",
    "engagementBenchmark.desc",
    "emailConsentFansCount.asc",
    "emailConsentFansCount.desc",
    "adConsentFansCount.asc",
    "adConsentFansCount.desc",
    "smsConsentFansCount.asc",
    "smsConsentFansCount.desc",
]

FanDataListSocialsStatsOrderBy = Literal[
    "spotifyMonthlyListeners.asc",
    "spotifyMonthlyListeners.desc",
    "instagramFollowers.asc",
    "instagramFollowers.desc",
    "tiktokFollowers.asc",
    "tiktokFollowers.desc",
    "spotifyFollowers.asc",
    "spotifyFollowers.desc",
    "facebookFollowers.asc",
    "facebookFollowers.desc",
    "youtubeFollowers.asc",
    "youtubeFollowers.desc",
    "twitterFollowers.asc",
    "twitterFollowers.desc",
    "soundcloudFollowers.asc",
    "soundcloudFollowers.desc",
    "deezerFollowers.asc",
    "deezerFollowers.desc",
]