from apollo_utils.core.constants.dsp import DSP


DESTINATION_TABLE_TRACKS_TOP_PLAYLISTS = {
    DSP.APPLE.value: "tblAppleMusicWeeklyTopPlaylistTrackSummary",
    DSP.SPOTIFY.value: "tblSpotifyWeeklyTopPlaylistTrackSummary",
}

DOWNLOAD_COLUMNS_TRACKS_TOP_PLAYLISTS = {
    DSP.APPLE.value: "`PlaylistId`, `ISRC`, `StoreFront`, `EntryDate`, `ExitDate`",
    DSP.SPOTIFY.value: "`PlaylistId`, `ISRC`, `EntryDate`, `ExitDate`",
}

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