"""SQL Queries."""

SELECT_FROM_INBOUND_GENRE_MAPPING = """
    SELECT orchard_genre_id as genre_id,
           orchard_subgenre_id as subgenre_id
    FROM inbound_genre_mapping
    WHERE inbound_genre_text = %s;
"""

SELECT_GENRE_DEFAULTS_FOR_VENDOR = """
    SELECT default_orchard_genre_id as genre_id,
           default_orchard_subgenre_id as subgenre_id
    FROM inbound_major_label_mapping
    WHERE vendor_id = %s
    AND subaccount_id is NULL;
"""

SELECT_GENRE_DEFAULTS_FOR_SUBACCOUNT = """
    SELECT default_orchard_genre_id as genre_id,
           default_orchard_subgenre_id as subgenre_id
    FROM inbound_major_label_mapping
    WHERE vendor_id = %s
    AND subaccount_id = %s;
"""