"""Model for asset file details."""

import sqlalchemy

from asset_file_details.connectors import mysql
from asset_file_details.queries import flac_file_details \
    as flac_file_details_query


@mysql.db_session
def get_flac_file_details(upc, filename, session=None):
    """Get the details for the flac file from the database.

    Args:
        upc (str): UPC of the asset.
        filename (str): Filename of the flac file {upc}_{cd}_{track_id}.flac
        session (sqlalchemy.orm.session.Session): Database session.

    Returns:
        Response: Tuple containing the column names and result row data.
    """
    result = session.execute(
        sqlalchemy.text(flac_file_details_query.get_flac_file_details),
        {'upc': upc, 'filename': filename}
    )

    return result.keys(), result.fetchone()