"""Vendor accounts config for Apple Music Streams ETL.""" from datetime import datetime sme_vendors = { '2016-04-27': { 'default': [ '86759381', '86759192', '86759190', '86759337', '86759368', '86759340', '86759336', '86759374', '86759369', '86759380', '86759366', '86759342', '86759370', '86759373', '86759377', '86759356', '86759338', '86759379', '86759365', '86759376', '86759375', '86759341', '86759367', '86759255', '86759357', '86759191', '86759194', '86759193', '86759362', '86759363', '86759361', '86759339', '86759364', '86759371', '86759343', '86759372', '86759195', '86759378', '86759359', '86759344', '86759358']}, '2016-08-02': { 'default': [ '86759381', '86759192', '86759190', '86759337', '86759368', '86759340', '86759336', '86759374', '86759369', '86759380', '86759366', '86759342', '86759370', '86759373', '86759377', '86759356', '86759338', '86759379', '86759365', '86759360', '86759375', '86759341', '86759376', '86759367', '86759255', '86759357', '86759191', '86759194', '86759193', '86759362', '86759363', '86759361', '86759339', '87165506', '86759364', '86759371', '86759343', '86759372', '86759195', '86759378', '86759359', '86759344', '86759358']}, '2017-02-25': { 'default': [ '86759381', '86759192', '86759190', '86759337', '86759368', '86759340', '86759336', '86759374', '86759369', '86759380', '86759366', '86759342', '86759370', '86759373', '86759377', '86759356', '86759338', '86759379', '86759365', '86759360', '86759375', '86759341', '86759376', '86759367', '86759255', '86759357', '86759191', '86759194', '86759193', '86759363', '86759361', '86759339', '87165506', '86759364', '86759371', '86759343', '86759372', '86759195', '86759378', '86759359', '86759344', '86759358']}, '2017-02-26': { 'default': [ '86759381', '86759192', '86759190', '86759337', '86759368', '86759340', '86759336', '86759374', '86759369', '86759380', '86759366', '86759342', '86759370', '86759373', '86759377', '86759356', '86759338', '86759379', '86759365', '86759360', '86759375', '86759341', '86759376', '86759367', '86759255', '86759357', '86759191', '86759194', '86759193', '86759363', '86759361', '86759339', '86759364', '86759371', '86759343', '86759372', '86759195', '86759378', '86759359', '86759344', '86759358']}, '2017-02-27': { 'default': [ '86759381', '86759192', '86759190', '86759337', '86759368', '86759340', '86759336', '86759374', '86759369', '86759380', '86759366', '86759342', '86759370', '86759373', '86759377', '86759356', '86759338', '86759379', '86759365', '86759360', '86759375', '86759341', '86759376', '86759367', '86759255', '86759357', '86759191', '86759194', '86759193', '86759362', '86759363', '86759361', '86759339', '86759364', '86759371', '86759343', '86759372', '86759195', '86759378', '86759359', '86759344', '86759358']}, '2017-02-28': { 'default': [ '86759381', '86759192', '86759190', '86759337', '86759368', '86759340', '86759336', '86759374', '86759369', '86759380', '86759366', '86759342', '86759370', '86759373', '86759377', '86759356', '86759338', '86759379', '86759365', '86759360', '86759375', '86759341', '86759376', '86759367', '86759255', '86759357', '86759191', '86759194', '86759193', '86759362', '86759363', '86759361', '86759339', '87165506', '86759364', '86759371', '86759343', '86759372', '86759195', '86759378', '86759359', '86759344', '86759358']}, '2017-11-15': { 'default': [ '86759381', '86759192', '86759190', '86759337', '86759368', '86759340', '86759336', '86759374', '86759369', '86759380', '86759366', '86759342', '86759370', '86759373', '86759377', '86759356', '86759338', '86759379', '86759365', '86759360', '86759375', '86759341', '86759376', '86759367', '86759255', '86759357', '86759191', '86759194', '86759193', '86759362', '86759363', '86759361', '86759339', '87165506', '86759364', '86759371', '86759343', '86759372', '86759195', '86759378', '86759359', '86759344', '86759358'], 'amContentDemographics': [ '86759368', '86759370', '86759381', '86759374', '86759363', '86759369', '86759362', '86759377', '87165506', '86759372', '86759338', '86759337', '86759356', '86759342', '86759380', '86759339', '86759375']}, '2017-11-16': { 'default': [ '86759377', '86759336', '86759358', '86759378', '86759360', '86759362', '86759374', '86759361', '86759376', '86759368', '86759359', '86759344', '86759381', '86759363', '86759193', '86759379', '86759373', '86759365', '86759367', '86759339', '86759371', '86759366', '86759195', '86759342', '86759356', '86759357', '86759338', '86759364', '86759191', '86759380', '86759340', '86759255', '86759343', '86759375', '86759372', '86759194', '86759190', '86759337', '86759370', '86759192', '86759369', '87165506', '86759341']}, '2018-03-22': { 'default': [ '86759377', '86759336', '85455525', '86759358', '86759378', '86759360', '86759362', '86759374', '86759361', '86759376', '86759368', '85455527', '80031738', '86759344', '85406443', '86759359', '86759381', '86759363', '80031742', '85455526', '85406437', '86759193', '80030905', '86759379', '86759373', '85455523', '86759365', '85004044', '80030469', '80031744', '86759367', '80033092', '86759339', '86759371', '86759366', '80031741', '86759195', '80033091', '80026921', '86759342', '86759356', '86759357', '86759338', '80030906', '86759191', '86759364', '86759380', '86759340', '86759255', '86759343', '86759375', '86759372', '80031740', '80031941', '86759194', '86759190', '86759337', '86759370', '86759192', '86759369', '85455524', '87165506', '86759341']}, '2018-03-23': { 'default': [ '85625470', '86759377', '86759336', '85455525', '85625473', '86759358', '86759378', '86759360', '85625478', '86759362', '80033089', '86759374', '86759361', '85520934', '86759376', '86759368', '85455527', '86759367', '80031738', '86759344', '85406443', '85741873', '86759359', '86759381', '86759380', '86759363', '80031742', '85455526', '85406437', '86759193', '80030905', '86759379', '86759373', '85455523', '86759365', '80031763', '80030469', '80031744', '85004044', '80033092', '85625472', '80031739', '80033090', '80031741', '85625475', '80033091', '85757805', '86759195', '86759339', '86759366', '80026921', '85406441', '86759342', '86759356', '86759357', '86759371', '86759338', '80030906', '85625694', '86759191', '85774842', '86759340', '86759255', '85741870', '86759343', '86759364', '80031743', '80031740', '80031941', '85741872', '86759194', '85741871', '86759372', '85625474', '80033230', '86759190', '86759337', '86759370', '86759192', '86759369', '85455524', '85625477', '86759375', '86759341', '87165506'], 'amContentDemographics': [ '85625470', '85625478', '85520934', '85004044', '85406443', '86759190', '86759365', '80031742', '80026921', '86759344', '86759377', '85406437', '86759368', '86759370', '86759376', '85757805', '85455525', '86759380', '85625472', '86759372', '86759339', '86759381', '85455523', '85625477', '80033091', '85406441', '80030469', '80031941', '85455524', '85774842', '85741871', '85455526', '87165506', '80033092', '86759340', '80033089', '80030906', '80031740', '86759375', '80031739', '86759359', '80033230', '85625475', '85625473', '86759194', '85741870', '85741872', '80031743', '80031763', '85455527', '86759378', '80030905', '86759336', '85625474', '80031744', '86759193', '86759360', '86759374', '85741873', '85625694', '80031738', '80033090', '80031741']}, '2018-03-24': { 'default': [ '85625470', '86759377', '86759336', '85455525', '85625473', '86759378', '86759360', '85625478', '86759362', '80033089', '86759374', '86759361', '85520934', '86759376', '86759368', '85455527', '80031738', '86759344', '85406443', '85741873', '86759359', '86759363', '80031742', '85455526', '85406437', '80030905', '86759379', '86759373', '85455523', '86759365', '80031763', '80030469', '80031744', '85004044', '80033092', '85625472', '80031739', '80033090', '80031741', '85625475', '80033091', '85757805', '86759195', '86759339', '86759371', '80026921', '85406441', '86759342', '86759356', '86759357', '86759338', '80030906', '85625694', '86759191', '85774842', '86759340', '86759364', '85741870', '86759343', '86759380', '80031743', '80031740', '80031941', '85741872', '86759194', '85741871', '85625474', '80033230', '86759190', '86759337', '86759370', '86759192', '86759369', '85455524', '85625477', '87165506', '86759341'], 'amNonRoyaltyStreams': [ '80031739', '85004044', '85455527', '86759190', '86759195', '86759364', '80030905', '86759359', '86759378', '86759342', '86759380', '86759343', '86759379', '86759371', '85406443', '80033089', '80033090', '85625477', '85625478', '85625472', '85741872', '86759340', '85625475', '86759360', '86759362', '86759339', '85455525', '85625470', '80031941', '86759336', '86759356', '80031763', '86759369', '85406437', '86759373', '86759374', '86759361', '80030469', '80031743', '86759357', '85741871', '86759192', '86759191', '80031741', '80026921', '80031742', '85455524', '85757805', '80033091', '80030906', '85455523', '80031740', '80033092', '85625474', '85406441', '85741873', '86759194', '85455526', '86759341', '85774842', '80031738', '86759344', '86759363', '86759337', '86759365', '86759376', '87165506', '85625694', '85625473', '80033230', '86759368', '85741870', '80031744', '85520934', '86759370'], 'amContentDemographics': [ '85625470', '85625478', '85520934', '85004044', '85406443', '80031742', '80026921', '85406437', '85757805', '85455525', '85625472', '85455523', '85625477', '80033091', '85406441', '80030469', '80031941', '85455524', '85741871', '85774842', '85455526', '87165506', '80033092', '80033089', '80030906', '80031740', '80033230', '80031739', '85625475', '85625473', '85741870', '80031743', '85741872', '80031763', '85455527', '80031744', '80030905', '85625474', '85741873', '85625694', '80031738', '80033090', '80031741']}, '2018-03-25': { 'default': [ '85625470', '86759377', '86759336', '85455525', '85625473', '86759358', '86759378', '86759360', '85625478', '86759362', '80033089', '86759374', '85520934', '86759376', '86759368', '85455527', '80031738', '86759344', '85406443', '85741873', '86759381', '86759363', '80031742', '85455526', '85406437', '80030905', '86759373', '85455523', '86759365', '80031763', '80030469', '80031744', '85004044', '80033092', '85625472', '80031739', '80033090', '80031741', '85625475', '80033091', '85757805', '86759195', '86759339', '86759371', '80026921', '85406441', '86759342', '86759356', '86759357', '86759338', '80030906', '85625694', '86759364', '85774842', '86759340', '86759255', '85741870', '86759343', '86759372', '80031743', '80031740', '80031941', '85741872', '86759194', '85741871', '85625474', '80033230', '86759190', '86759337', '86759370', '87165506', '86759369', '85455524', '85625477', '86759375', '86759341'], 'amContentDemographics': [ '85625470', '85625478', '85520934', '85004044', '85406443', '80031742', '80026921', '85406437', '85757805', '85455525', '85625472', '85455523', '85625477', '80033091', '85406441', '80030469', '80031941', '85455524', '85741871', '85774842', '85455526', '80033092', '80033089', '80030906', '80031740', '80033230', '80031739', '85625475', '85625473', '85741870', '80031743', '85741872', '80031763', '85455527', '80031744', '80030905', '85625474', '85741873', '85625694', '80031738', '80033090', '80031741']}, '2018-03-26': { 'default': [ '85625470', '86759336', '85455525', '85625473', '86759378', '86759360', '85625478', '86759362', '80033089', '86759374', '86759361', '85520934', '86759376', '86759368', '85455527', '80031738', '86759344', '85406443', '85741873', '86759381', '86759363', '80031742', '85455526', '85406437', '86759193', '80030905', '86759379', '86759373', '85455523', '86759365', '80031763', '80030469', '80031744', '85004044', '80033092', '85625472', '80031739', '80033090', '80031741', '85625475', '80033091', '85757805', '86759339', '86759371', '80026921', '85406441', '86759342', '86759357', '86759338', '80030906', '85625694', '86759191', '85774842', '86759340', '86759364', '85741870', '86759343', '86759372', '80031743', '80031740', '80031941', '85741872', '86759194', '85741871', '85625474', '80033230', '86759190', '86759337', '86759370', '86759192', '86759369', '85455524', '85625477', '87165506', '86759341'], 'amContentDemographics': [ '85625470', '85625478', '85520934', '85004044', '85406443', '80031742', '80026921', '85406437', '85757805', '85455525', '85625472', '85455523', '85625477', '80033091', '85406441', '80030469', '80031941', '85455524', '85741871', '85774842', '85455526', '80033092', '80033089', '80030906', '80031740', '80033230', '80031739', '85625475', '85625473', '85741870', '80031743', '85741872', '80031763', '85455527', '80031744', '80030905', '85625474', '85741873', '85625694', '80031738', '80033090', '80031741']}, '2018-03-27': { 'default': [ '85625470', '86759336', '85455525', '85625473', '86759378', '86759360', '85625478', '86759362', '80033089', '86759374', '86759361', '85520934', '86759376', '86759368', '85455527', '86759367', '80031738', '86759344', '85406443', '85741873', '86759381', '86759363', '80031742', '85455526', '85406437', '80030905', '86759373', '85455523', '86759365', '80031763', '80030469', '80031744', '85004044', '80033092', '85625472', '80031739', '80033090', '80031741', '85625475', '80033091', '85757805', '86759339', '86759371', '80026921', '85406441', '86759342', '86759356', '86759357', '86759338', '80030906', '85625694', '86759191', '85774842', '86759340', '86759364', '85741870', '86759343', '86759375', '80031743', '80031740', '80031941', '85741872', '85741871', '85625474', '80033230', '86759190', '86759337', '86759370', '87165506', '86759369', '85455524', '85625477', '86759341'], 'amContentDemographics': [ '85625470', '85625478', '85520934', '85004044', '85406443', '80031742', '80026921', '85406437', '85757805', '85455525', '85625472', '85455523', '85625477', '80033091', '85406441', '80030469', '80031941', '85455524', '85741871', '85774842', '85455526', '80033092', '80033089', '80030906', '80031740', '80033230', '80031739', '85625475', '85625473', '85741870', '80031743', '85741872', '80031763', '85455527', '80031744', '80030905', '85625474', '85741873', '85625694', '80031738', '80033090', '80031741']}, '2018-03-28': { 'default': [ '85625470', '86759377', '86759336', '85455525', '85625473', '86759378', '86759360', '85625478', '86759362', '80033089', '85520934', '86759376', '86759368', '85455527', '80031738', '86759344', '85406443', '85741873', '86759359', '86759381', '86759363', '80031742', '85455526', '85406437', '86759193', '80030905', '86759373', '85455523', '86759365', '80031763', '80030469', '80031744', '85004044', '80033092', '85625472', '80031739', '80033090', '80031741', '85625475', '80033091', '85757805', '86759339', '86759366', '86759371', '80026921', '85406441', '86759342', '86759356', '86759357', '86759338', '80030906', '85625694', '86759191', '85774842', '86759340', '86759364', '85741870', '86759343', '86759372', '80031743', '80031740', '80031941', '85741872', '86759375', '85741871', '86759380', '85625474', '80033230', '86759190', '86759337', '86759370', '87165506', '86759369', '85455524', '85625477'], 'amNonRoyaltyStreams': [ '80031739', '85004044', '85455527', '86759190', '86759364', '80030905', '86759359', '86759378', '86759377', '86759342', '86759343', '86759371', '85406443', '80033089', '80033090', '85625477', '85625478', '85625472', '85741872', '86759340', '85625475', '86759360', '86759362', '86759339', '85455525', '85625470', '80031941', '86759336', '86759356', '80031763', '86759338', '86759369', '85406437', '86759373', '80030469', '80031743', '86759357', '85741871', '86759193', '86759191', '80031741', '80026921', '80031742', '85455524', '85757805', '80033091', '80030906', '85455523', '80031740', '80033092', '86759375', '85625474', '85406441', '85741873', '85455526', '86759363', '85774842', '80031738', '86759344', '86759337', '86759365', '86759376', '87165506', '85625694', '85625473', '85741870', '86759372', '80031744', '85520934', '86759370', '80033230'], 'amContentDemographics': [ '85625470', '85625478', '85520934', '85004044', '85406443', '80031742', '80026921', '85406437', '85757805', '85455525', '85625472', '85455523', '85625477', '80033091', '85406441', '80030469', '80031941', '85455524', '85741871', '85774842', '85455526', '80033092', '80033089', '80030906', '80031740', '80033230', '80031739', '85625475', '85625473', '85741870', '80031743', '85741872', '80031763', '85455527', '80031744', '80030905', '85625474', '85741873', '85625694', '80031738', '80033090', '80031741']}, '2018-03-29': { 'default': [ '85625470', '86759377', '86759336', '85455525', '85625473', '86759378', '86759360', '85625478', '80033089', '86759374', '85520934', '86759376', '85455527', '86759367', '80031738', '86759344', '85406443', '85741873', '86759363', '80031742', '85455526', '85406437', '86759193', '80030905', '86759373', '85455523', '86759365', '80031763', '80030469', '80031744', '85004044', '80033092', '85625472', '80031739', '80033090', '80031741', '85625475', '80033091', '85757805', '86759339', '86759371', '80026921', '85406441', '86759342', '86759356', '86759357', '86759364', '80030906', '85625694', '86759191', '85774842', '86759340', '86759380', '85741870', '80031743', '80031740', '80031941', '85741872', '86759194', '85741871', '85625474', '80033230', '86759190', '86759337', '86759370', '87165506', '86759369', '85455524', '85625477', '86759341'], 'amNonRoyaltyStreams': [ '80031739', '85004044', '85455527', '86759190', '80030905', '86759378', '86759377', '86759342', '86759380', '80033230', '86759371', '85406443', '80033089', '80033090', '85625477', '85625478', '85625472', '85741872', '86759340', '85625475', '86759360', '86759364', '86759339', '85455525', '85625470', '80031941', '86759336', '86759356', '80031763', '86759369', '85406437', '86759367', '86759373', '86759374', '80030469', '80031743', '86759357', '85741871', '86759193', '86759191', '80031741', '80026921', '80031742', '85455524', '85757805', '80033091', '80030906', '85455523', '80031740', '80033092', '85625474', '85406441', '85741873', '86759194', '85455526', '86759341', '85774842', '80031738', '86759344', '86759363', '86759337', '86759376', '87165506', '85625694', '85625473', '85741870', '80031744', '85520934', '86759370'], 'amContentDemographics': [ '85625470', '85625478', '85520934', '85004044', '85406443', '80031742', '80026921', '85406437', '85757805', '85455525', '85625472', '85455523', '85625477', '80033091', '85406441', '80030469', '80031941', '85455524', '85741871', '85774842', '85455526', '80033092', '80033089', '80030906', '80031740', '80033230', '80031739', '85625475', '85625473', '85741870', '80031743', '85741872', '80031763', '85455527', '80031744', '80030905', '85625474', '85741873', '85625694', '80031738', '80033090', '80031741']}, '2018-03-30': { 'default': [ '85625470', '86759377', '85455525', '85625473', '86759378', '86759360', '85625478', '80033089', '86759361', '85520934', '86759376', '85455527', '80031738', '86759344', '85406443', '85741873', '86759381', '86759363', '80031742', '85455526', '85406437', '86759193', '80030905', '86759373', '85455523', '86759365', '80031763', '80030469', '80031744', '85004044', '80033092', '85625472', '80031739', '80033090', '80031741', '85625475', '80033091', '85757805', '86759339', '86759366', '86759371', '80026921', '85406441', '86759342', '86759357', '86759338', '80030906', '85625694', '86759364', '85774842', '86759340', '86759380', '85741870', '86759343', '80031743', '80031740', '80031941', '85741872', '85741871', '85625474', '80033230', '86759190', '86759337', '86759370', '87165506', '86759369', '85455524', '85625477'], 'amNonRoyaltyStreams': [ '80031739', '85004044', '85455527', '86759190', '80030905', '86759377', '86759342', '86759380', '86759343', '86759371', '85406443', '80033089', '80033090', '85625477', '85625478', '85625472', '85741872', '86759340', '85625475', '86759364', '86759378', '86759339', '85455525', '85625470', '80031941', '80031763', '86759338', '86759369', '85406437', '86759381', '86759373', '80030469', '80031743', '86759357', '85741871', '86759193', '80031741', '80026921', '80031742', '85455524', '85757805', '80033091', '80030906', '85455523', '80031740', '80033092', '85625474', '85406441', '85741873', '85455526', '86759363', '85774842', '80031738', '86759344', '86759337', '86759365', '86759376', '87165506', '85625694', '85625473', '85741870', '80031744', '85520934', '86759370', '80033230'], 'amContentDemographics': [ '85625470', '85625478', '85520934', '85004044', '85406443', '80031742', '80026921', '85406437', '85757805', '85455525', '85625472', '85455523', '85625477', '80033091', '85406441', '80030469', '80031941', '85455524', '85741871', '85774842', '85455526', '80033092', '80033089', '80030906', '80031740', '80033230', '80031739', '85625475', '85625473', '85741870', '80031743', '85741872', '80031763', '85455527', '80031744', '80030905', '85625474', '85741873', '85625694', '80031738', '80033090', '80031741']}, '2018-03-31': { 'default': [ '85625470', '86759336', '85455525', '85625473', '86759360', '85625478', '80033089', '85520934', '86759376', '85455527', '86759367', '80031738', '86759344', '85406443', '85741873', '86759363', '80031742', '85455526', '85406437', '80030905', '86759373', '85455523', '80031763', '80030469', '80031744', '85004044', '80033092', '85625472', '80031739', '80033090', '80031741', '85625475', '80033091', '85757805', '86759339', '80026921', '85406441', '86759342', '86759357', '86759338', '80030906', '85625694', '86759364', '85774842', '86759340', '86759375', '85741870', '80031743', '80031740', '80031941', '85741872', '86759194', '85741871', '85625474', '80033230', '86759190', '86759370', '86759369', '85455524', '85625477', '86759341'], 'amNonRoyaltyStreams': [ '85625470', '86759367', '85625478', '85520934', '85004044', '85406443', '86759190', '86759342', '80031742', '80026921', '86759344', '85406437', '86759370', '86759376', '86759338', '85455525', '85757805', '86759369', '85625472', '86759339', '85455523', '85625477', '80033091', '80030469', '85406441', '80031941', '85455524', '85774842', '85741871', '85455526', '80033092', '86759340', '80033089', '80030906', '80031740', '80033230', '86759375', '80031739', '85625475', '86759194', '85741870', '85625473', '86759357', '80031743', '80031744', '85741872', '86759363', '80031763', '80030905', '85625474', '85455527', '86759360', '86759373', '85741873', '85625694', '80031738', '80033090', '80031741'], 'amContentDemographics': [ '85625470', '85625478', '85520934', '85004044', '85406443', '80031742', '80026921', '85406437', '85757805', '85455525', '85625472', '85455523', '85625477', '80033091', '85406441', '80030469', '80031941', '85455524', '85741871', '85774842', '85455526', '80033092', '80033089', '80030906', '80031740', '80033230', '80031739', '85625475', '85625473', '85741870', '80031743', '85741872', '80031763', '85455527', '80031744', '80030905', '85625474', '85741873', '85625694', '80031738', '80033090', '80031741']}, '2018-04-01': { 'default': [ '85625470', '85455525', '85625473', '86759378', '85625478', '80033089', '85520934', '85455527', '80031738', '85406443', '85741873', '80031742', '85455526', '85406437', '80030905', '85455523', '80031763', '80030469', '80031744', '85004044', '80033092', '85625472', '80031739', '80033090', '80031741', '85625475', '80033091', '85757805', '86759339', '80026921', '85406441', '86759342', '86759357', '80030906', '85625694', '85774842', '86759375', '85741870', '80031743', '80031740', '80031941', '85741872', '85741871', '85625474', '80033230', '86759370', '85455524', '85625477'], 'amNonRoyaltyStreams': [ '80031739', '85004044', '85455527', '80030905', '86759342', '85406443', '80033089', '80033090', '85625477', '85625478', '85625472', '85741872', '86759378', '85625475', '86759339', '85455525', '85625470', '80031941', '80031763', '85406437', '80030469', '80031743', '86759357', '85741871', '80031741', '80026921', '80031742', '85455524', '85757805', '80033091', '80030906', '85455523', '80031740', '80033092', '86759375', '85625474', '85406441', '85741873', '85455526', '85774842', '80031738', '85625694', '85625473', '85741870', '80031744', '85520934', '80033230'], 'amContentDemographics': [ '85625470', '85625478', '85520934', '85004044', '85406443', '80031742', '80026921', '85406437', '85757805', '85455525', '85625472', '85455523', '85625477', '80033091', '85406441', '80030469', '80031941', '85455524', '85741871', '85774842', '85455526', '80033092', '80033089', '80030906', '80031740', '80033230', '80031739', '85625475', '85625473', '85741870', '80031743', '85741872', '80031763', '85455527', '80031744', '80030905', '85625474', '85741873', '85625694', '80031738', '80033090', '80031741']}, '2018-04-02': { 'default': [ '85625470', '85455525', '85625473', '85625478', '80033089', '85520934', '86759376', '85455527', '80031738', '85406443', '85741873', '80031742', '85455526', '85406437', '80030905', '85455523', '80031763', '80030469', '80031744', '85004044', '80033092', '85625472', '80031739', '80033090', '80031741', '85625475', '80033091', '85757805', '86759339', '80026921', '85406441', '80030906', '85625694', '85774842', '85741870', '80031743', '80031740', '80031941', '85741872', '85741871', '85625474', '80033230', '85455524', '85625477'], 'amNonRoyaltyStreams': [ '80031739', '85004044', '85455527', '80030905', '85406443', '80033089', '80033090', '85625477', '85625478', '85625472', '85741872', '85625475', '85455525', '85625470', '80031941', '80031763', '85406437', '80030469', '80031743', '85741871', '80031741', '80026921', '80031742', '85455524', '85757805', '80033091', '80030906', '85455523', '80031740', '80033092', '85625474', '85406441', '85741873', '85455526', '85774842', '80031738', '85625694', '85625473', '85741870', '80031744', '85520934', '80033230'], 'amContentDemographics': [ '85625470', '85625478', '85520934', '85004044', '85406443', '80031742', '80026921', '85406437', '85757805', '85455525', '85625472', '85455523', '85625477', '80033091', '85406441', '80030469', '80031941', '85455524', '85741871', '85774842', '85455526', '80033092', '80033089', '80030906', '80031740', '80033230', '80031739', '85625475', '85625473', '85741870', '80031743', '85741872', '80031763', '85455527', '80031744', '80030905', '85625474', '85741873', '85625694', '80031738', '80033090', '80031741']}, '2018-04-03': { 'default': [ '85625470', '85455525', '85625473', '85625478', '80033089', '85520934', '85455527', '80031738', '85406443', '85741873', '80031742', '85455526', '85406437', '80030905', '85455523', '80031763', '80030469', '80031744', '85004044', '80033092', '85625472', '80031739', '80033090', '80031741', '85625475', '80033091', '85757805', '80026921', '85406441', '80030906', '85625694', '85774842', '85741870', '80031743', '80031740', '80031941', '85741872', '85741871', '85625474', '80033230', '85455524', '85625477']}, '2018-05-09': { 'default': [ '80026921', '80030469', '80030905', '80030906', '80031738', '80031739', '80031740', '80031741', '80031742', '80031743', '80031744', '80031763', '80031941', '80033089', '80033090', '80033091', '80033092', '80033230', '85004044', '85406437', '85406441', '85406443', '85455523', '85455524', '85455525', '85455526', '85455527', '85520934', '85625470', '85625472', '85625473', '85625474', '85625475', '85625477', '85625478', '85625694', '85741870', '85741871', '85741872', '85741873', '85757805', '85774842', '87165506']}, '2020-07-15': { 'default': [ '80026921', '80030469', '80030905', '80030906', '80031738', '80031739', '80031740', '80031741', '80031742', '80031743', '80031744', '80031763', '80031941', '80033089', '80033090', '80033091', '80033092', '80033230', '85004044', '85406437', '85406441', '85406443', '85455523', '85455524', '85455525', '85455526', '85455527', '85520934', '85625470', '85625472', '85625473', '85625474', '85625475', '85625477', '85625478', '85625694', '85741870', '85741871', '85741872', '85741873', '85757805', '85774842', '87165506'], 'amContentDemographics': [ '85455526', '80033092', '80031763', '85757805', '80026921', '85625470', '85625478', '85625472', '85406441', '85741870', '87165506', '85406437', '80033090', '85625474', '80031739', '80030469', '85625473', '85741872', '85625477', '80030906', '85520934', '85455523', '85455525', '80031743', '80033091', '80031742', '80033089', '85455524', '85741871', '85741873', '80031740', '85406443', '80031738', '85004044', '80031744', '80031741', '80030905', '85455527', '80033230', '80031941', '85625694']}, '2020-07-16': { 'default': [ '80026921', '80030469', '80030905', '80030906', '80031738', '80031739', '80031740', '80031741', '80031742', '80031743', '80031744', '80031763', '80031941', '80033089', '80033090', '80033091', '80033092', '80033230', '85004044', '85406437', '85406441', '85406443', '85455523', '85455524', '85455525', '85455526', '85455527', '85520934', '85625470', '85625472', '85625473', '85625474', '85625475', '85625477', '85625478', '85625694', '85741870', '85741871', '85741872', '85741873', '85757805', '85774842', '87165506']}, '2022-12-17': { 'default': [ '80026921', '80030469', '80030905', '80030906', '80031738', '80031739', '80031740', '80031741', '80031742', '80031743', '80031744', '80031763', '80031941', '80033089', '80033090', '80033091', '80033092', '80033230', '85004044', '85406437', '85406441', '85406443', '85455523', '85455524', '85455525', '85455526', '85455527', '85520934', '85625470', '85625472', '85625473', '85625474', '85625475', '85625477', '85625478', '85625694', '85741870', '85741871', '85741872', '85741873', '85757805', '85774842', '87165506'], 'amContainer': [ '80026921', '80030469', '80030905', '80030906', '80031738', '80031739', '80031740', '80031741', '80031742', '80031743', '80031744', '80031763', '80031941', '80033089', '80033090', '80033091', '80033092', '80033230', '85004044', '85406437', '85406441', '85406443', '85455523', '85455524', '85455525', '85455526', '85455527', '85520934', '85625470', '85625472', '85625473', '85625474', '85625475', '85625477', '85625478', '85625694', '85741870', '85741871', '85741872', '85741873', '85757805', '87165506' ], 'amContentDemographics': [ '80026921', '80030469', '80030905', '80030906', '80031738', '80031739', '80031740', '80031741', '80031742', '80031743', '80031744', '80031763', '80031941', '80033089', '80033090', '80033091', '80033092', '80033230', '85004044', '85406437', '85406441', '85406443', '85455523', '85455524', '85455525', '85455526', '85455527', '85520934', '85625470', '85625472', '85625473', '85625474', '85625475', '85625477', '85625478', '85625694', '85741870', '85741871', '85741872', '85741873', '85757805', '87165506' ] }, '2022-12-18': { 'default': [ '80026921', '80030469', '80030905', '80030906', '80031738', '80031739', '80031740', '80031741', '80031742', '80031743', '80031744', '80031763', '80031941', '80033089', '80033090', '80033091', '80033092', '80033230', '85004044', '85406437', '85406441', '85406443', '85455523', '85455524', '85455525', '85455526', '85455527', '85520934', '85625470', '85625472', '85625473', '85625474', '85625475', '85625477', '85625478', '85625694', '85741870', '85741871', '85741872', '85741873', '85757805', '85774842', '87165506'] }, # vendor_id 85774842 is temporarily removed for 2023-10-02 '2023-10-02': { 'default': [ '80026921', '80030469', '80030905', '80030906', '80031738', '80031739', '80031740', '80031741', '80031742', '80031743', '80031744', '80031763', '80031941', '80033089', '80033090', '80033091', '80033092', '80033230', '85004044', '85406437', '85406441', '85406443', '85455523', '85455524', '85455525', '85455526', '85455527', '85520934', '85625470', '85625472', '85625473', '85625474', '85625475', '85625477', '85625478', '85625694', '85741870', '85741871', '85741872', '85741873', '85757805', '87165506'] }, '2023-10-03': { 'default': [ '80026921', '80030469', '80030905', '80030906', '80031738', '80031739', '80031740', '80031741', '80031742', '80031743', '80031744', '80031763', '80031941', '80033089', '80033090', '80033091', '80033092', '80033230', '85004044', '85406437', '85406441', '85406443', '85455523', '85455524', '85455525', '85455526', '85455527', '85520934', '85625470', '85625472', '85625473', '85625474', '85625475', '85625477', '85625478', '85625694', '85741870', '85741871', '85741872', '85741873', '85757805', '85774842', '87165506'] } } theorchard_vendors = { '2016-01-01': { 'default': ['80028967', '80029727', '80032046', '80032543', '80034465', '80031727', '80031813', '85420853', '80032084', '80035150', '80028547']}, '2023-01-01': { 'default': ['80028967', '80029727', '80032046', '80032543', '80034465', '80031727', '80031813', '85420853', '80032084', '80035150', '80028547', '85320019'], # excluding altafonte 85320019 for specific reports 'amNonRoyaltySummaryStreams': [ '80028967', '80029727', '80032046', '80032543', '80034465', '80031727', '80031813', '85420853', '80032084', '80035150', '80028547'], 'amArtists': [ '80028967', '80029727', '80032046', '80032543', '80034465', '80031727', '80031813', '85420853', '80032084', '80035150', '80028547'], 'amPlaylists': [ '80028967', '80029727', '80032046', '80032543', '80034465', '80031727', '80031813', '85420853', '80032084', '80035150', '80028547'], 'amSongs': [ '80028967', '80029727', '80032046', '80032543', '80034465', '80031727', '80031813', '85420853', '80032084', '80035150', '80028547'], }, } licensors = { 'theorchard': theorchard_vendors, 'sme': sme_vendors, 'awal': {'2015-06-30': {'default': ['80031998']}}, } # Required/optional contexts. contexts_config = { # licensor, e.g. default, theorchard, sme 'default': { # report, e.g. default, amContainer, amStreams 'default': { 'required': [ '80026921', '80028967', '85520934', '80031941', '80030469', '80030906', '85004044', '80031998', '80030905', '85741873', '80029727', '85320019' # altafonte ] } } } def get_vendors(date, licensor, report_name=None): """Get list of vendor accounts by date and a licensor. Args: date (str): YYYY-MM-DD str for report requested. licensor (str): A name of a licensor (e.g. sme or theorchard) Returns: list: The vendor account list available for date and the licensor. """ current_date = datetime.strptime(date, '%Y-%m-%d') for vendor_date in sorted(licensors[licensor], reverse=True): if current_date >= datetime.strptime(vendor_date, '%Y-%m-%d'): vendors = licensors[licensor][vendor_date] if report_name and vendors.get(report_name): return vendors.get(report_name) return vendors.get('default')