"""Parse matches.""" import json import glob def main(): """Parse matches.""" print('asset_final_id, label, title, artists') for fname in glob.glob('./found_items_req*.json'): with open(fname, 'r') as f: file_data = f.read() file_json = json.loads(file_data) for resp in file_json.get('Responses', {}).get('prod_content_review_match_audio_match', []): matches = json.loads(resp.get('matches').get('S')).get('matches') if matches: for match in matches: asset_final_id = resp.get('asset_final_id').get('N') label = sanitize_field(match.get('label') or '') title = sanitize_field(match.get('title', '')) artists = sanitize_field('&'.join(match.get('artists', []))) print(f'{asset_final_id}, "{label}", "{title}", "{artists}"') def sanitize_field(field): """Sanitize data field.""" escaped_commas = field.replace(',', '\\,') escaped_quotes = escaped_commas.replace('"', '\\"') return escaped_quotes if __name__ == '__main__': main()