from datetime import date

APP_NAME: str = "update_hot_hits_history"

MARKET_GLOBAL = "_gl"


class Table:
    STATS = "stats"


class Command:
    SELECT = "select"
    UPDATE = "update"
    INSERT = "insert"
    DELETE = "delete"

    ALL_MODIFY = (UPDATE, INSERT, DELETE)


class Folder:
    UPLOAD = "in"
    DOWNLOAD = "out"


class ApolloKey:
    HH_LATEST = "hot_hits_latest_date"
    HH_LATEST_WITH_TIME = "hot_hits_latest_ts"
    HH_JOB_LAST_RUN = "hh_job_last_run_ts"
    HH_RANK_UPDATE = "hh_rank_update_ts"


DEFAULT_DATE_FORMAT = "%Y-%m-%d"


MIN_DATE = date(2000, 1, 1)


FIELD_LIST = (
    "entry_date",
    "latest_date",
    "latest_position",
    "previous_date",
    "previous_position",
    "peak_date",
    "peak_position",
    "added_date",
)