"""Constants for sound recordings takedown."""

TAKEDOWN_COLUMNS = [
    'Meta Update Queue Date Added',
    'Label ID',
    'Label Name',
    'Artist Name',
    'Track Name',
    'Release UPC',
    'Track ISRC',
]

ISRC_LOOKUP_COLUMNS = [
    'Vendor ID',
    'Label Name',
    'Imprint Name',
    'Artist ID',
    'Artist Name',
    'Primary Artists',
    'Display UPC',
    'Release Name',
    'Is Deleted',
    'TUID',
    'ISRC',
    'Track Name',
]

RELEASE_UPC = 'Release UPC'

OWS_MASTERS_REGISTRY = 'ows-masters-registry'

LOCAL_DIR = './sound_recordings_takedown'
OUTPUT_FILENAME_PREFIX = 'sound_recordings_takedown'

SUCCESS_EMAIL_SUBJECT = 'The Orchard - YouTube Content ID MUQ'
FAILURE_EMAIL_SUBJECT = 'The Orchard - ERROR YouTube Content ID MUQ'


SUCCESS_MESSAGE_BODY = """
Sound Recordings Takedown script completed successfully.
{registry_note}
Output File: {filename}
MD5: {md5}
Size: {file_size}
Timestamp: {current_time}

The Excel file is attached to this email.

If there is any issue with the data, please contact the Appsec Team.
"""

REGISTRY_SKIPPED_NOTE = 'Note: Masters Registry update was skipped. Generating the output sheet only.\n'

FAILURE_MESSAGE_BODY = """
Sound Recordings Takedown script failed.

Timestamp: {current_time}
Error: {error}

"""