from apollo_utils.core.constants.dsp import DSP


DESTINATION_TABLE_WEEKLY_TOP_PLAYLISTS = {
    DSP.APPLE.value: "tblAppleMusicWeeklyTopPlaylistLatest",
    DSP.SPOTIFY.value: "tblSpotifyWeeklyTopPlaylistLatest",
}

DOWNLOAD_COLUMNS_WEEKLY_TOP_PLAYLISTS = "`PlaylistId`, `Date`, `CountryCode`, `Rank`"

ID_COLUMN_WEEKLY_TOP_PLAYLISTS = "`Id` INT(11) AUTO_INCREMENT"