from ..base import PrepareBase
from ..contsants import NON_SIGNED_ARTIST_GENRE_TABLE


__all__ = ["ArtistGenre"]


class ArtistGenre(PrepareBase):
    depends_on = {"preparation.non_signed.artist.prepare"}
    priority = 1
    table_name: str = NON_SIGNED_ARTIST_GENRE_TABLE

    query: str = """
        SELECT
            T_NON_SIGNED_ARTIST.ID AS ID,
            V_CM_TAG.NAME AS GENRE
        FROM DNA.DNA_PUBLIC.T_NON_SIGNED_ARTIST AS T_NON_SIGNED_ARTIST
        JOIN DELPHI_EXPLORATION.CHARTMETRIC.V_L_CM_ARTIST_TAG AS V_L_CM_ARTIST_TAG
            ON T_NON_SIGNED_ARTIST.ID = V_L_CM_ARTIST_TAG.CM_ARTIST
        JOIN DELPHI_EXPLORATION.CHARTMETRIC.V_CM_TAG AS V_CM_TAG
            ON V_L_CM_ARTIST_TAG.CM_TAG = V_CM_TAG.ID
            AND V_L_CM_ARTIST_TAG.LINK_TYPE = 'cm_artist_genre'
            AND NOT V_L_CM_ARTIST_TAG.HIDDEN AND V_L_CM_ARTIST_TAG.SCORE > 0
        GROUP BY
            T_NON_SIGNED_ARTIST.ID,
            GENRE
        ORDER BY
            ID
    """