"""SQL Queries."""

SELECT_FROM_INBOUND_MAJOR_LABEL_MAPPING_BY_CODE = """
    SELECT vendor_id, subaccount_id, do_not_ingest
    FROM inbound_major_label_mapping
    WHERE parent_repertoire_owner_code = %s
    AND repertoire_owner_code = %s;
"""

INSERT_INTO_INBOUND_MAJOR_LABEL_MAPPING = """
  INSERT INTO inbound_major_label_mapping (
    inbound_major_label_text,
    vendor_id,
    subaccount_id,
    default_orchard_genre_id,
    default_orchard_subgenre_id,
    parent_repertoire_owner_code,
    repertoire_owner_code)
VALUES (NULL, %s, %s, 11, 133, %s, %s);
"""