"""Logic for retrieving content metadata from art_relations database."""

from typing import List

from src.common.connectors.art_relations import execute_query
from src.logic import art_relations_queries
from src.models.metadata import ProductParticipation


def get_product_participations(product_id: int) -> List[ProductParticipation]:
    """Get product participations.

    Args:
        product_id: Product id.

    Returns:
        List of product participations.
    """
    result = []
    query_results = execute_query(
        art_relations_queries.RELEASE_ARTIST,
        {'product_id': product_id}
    )
    for record in query_results:
        result.append(
            ProductParticipation(
                product_id=product_id,
                participant_id=record['artist_id'],
                participant_name=record['artist_name'],
                participant_participated_as=record['artist_role'],
            )
        )
    return result