"""Logic for asset file details."""

from owsresponse import response

from asset_file_details.models import flac_file_details \
    as flac_file_details_model


def get_flac_file_details(upc, cd, track_id):
    """Get the  details for the flac file and put in a dictionary.

    Args:
        upc (str): UPC of the asset.
        cd (str): CD (volume number) of the asset.
        track_id (str): Track ID (track number) of the asset.

    Returns:
        Response: Dictionary containing asset file details.
    """
    # we need to query by filename since these are not in separate columns
    filename = str(upc) + '_' + str(cd) + '_' + str(track_id) + '.flac'
    keys, result_row = flac_file_details_model.get_flac_file_details(
        upc, filename)
    if result_row:
        result_dict = dict(zip(keys, result_row))
        return response.Response(result_dict)
    return response.Response('FLAC not found', None, 200)