"""SQL Queries."""

SELECT_ORIGINAL_UPC = """
  SELECT original_upc, vendor_id
  FROM upc_remap
  WHERE remapped_upc = %s
  AND catalog_ingestion_source_id = %s;
"""

SELECT_FROM_INBOUND_MAJOR_LABEL_MAPPING = """
    SELECT vendor_id, subaccount_id
    FROM inbound_major_label_mapping
    WHERE inbound_major_label_text = %s;
"""

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