"""Backfill apple id for episodes under specific apple subscription feeds. Run this in dev with command PYTHONPATH=. env/bin/python3.8 dev/backfill_apple_id_for_episodes_under_specific_apple_feeds.py -- -env dev """ import argparse import csv import logging import os import sys from podcast.models.episode import update_episode from podcast.utils import api_utils log = logging.getLogger('main') log.setLevel(logging.DEBUG) fmt = logging.Formatter('%(asctime)s - %(levelname)s - %(message)s') sh = logging.StreamHandler(sys.stdout) sh.setFormatter(fmt) log.addHandler(sh) users = { 'dev': '366', 'qa': '1298', 'prod': '88' } request_headers = None def backfill_apple_id_for_episodes_under_specific_apple_feeds(filename): """Backfill apple id for episodes under apple subscription feeds. Args: filename (str): The filename to access the csv file. """ if not filename: raise Exception('File with name: backfillAppleIdForEpisodesUnderSpecificAppleFeeds.csv not found') log.info(f'Reading file: {filename}\n') with open(filename) as csv_file: error_episode_count = 0 errored_episode_ids = [] reader = csv.DictReader(csv_file) for row in reader: episode_id = None try: episode_id = int(row['Episode ID']) print(f'\nRunning for episode_id: {episode_id}') apple_episode_id = row['Apple Episode ID'] if apple_episode_id: update_episode(episode_id, {'apple_id': apple_episode_id}) print(f'Updated episode with apple_episode_id: {apple_episode_id}') else: print('Empty apple episode id') except Exception as e: errored_episode_ids.append(episode_id) error_episode_count += 1 log.info( f'\nGot an exception for episode_id: {episode_id}\n' f'Exception trace: {e}\n' ) print(f'\nErrored episode count: {error_episode_count} and errored_episode_ids: {errored_episode_ids} \n') def main(): """Extract shell arguments, backfill apple id for episodes under specific apple subscription feeds.""" global request_headers argparser = argparse.ArgumentParser(prog='Backfill apple id for episodes under specific apple subscription feeds') argparser.add_argument('-env', required=True, help='env', default='qa') args = argparser.parse_args() filename = os.environ.get('FILENAME') env = args.env user_id = users[env] def get_user_id(): """Mock get user id return value.""" return user_id api_utils.get_user_id = get_user_id request_headers = { 'Grass-Account-Type': 'vendor', 'Grass-Account-Id': '1', 'Correlation-Id': '12', 'Orchard-Identity-UUID': 'podcast-admin', 'Content-Type': 'application/json' } log.info(f'Running backfill_apple_id_for_episodes_under_specific_apple_feeds for {env} environment.\n') backfill_apple_id_for_episodes_under_specific_apple_feeds(filename) if __name__ == '__main__': main()