"""Content metadata queries."""

TRACK_ARTISTS = """
SELECT
    t.id AS track_id,
    ta.id AS artist_id,
    ta.name AS artist_name,
    LOWER(ta.type) AS artist_role
FROM releases AS r
INNER JOIN track AS t
    ON r.release_id = t.release_id
INNER JOIN track_artist AS ta
    ON t.id = ta.track_id
WHERE r.release_id = %(product_id)s
  AND ta.type <> 'feature_to_primary';
"""

TRACK_WRITERS = """
SELECT
    t.id AS track_id,
    tw.track_writer_id AS artist_id,
    tw.writer_name AS artist_name,
    'track_writer' AS artist_role
FROM releases AS r
INNER JOIN track AS t
    ON r.release_id = t.release_id
INNER JOIN track_writer AS tw
    ON t.id = tw.unique_track_id
WHERE r.release_id = %(product_id)s;
"""