"""SQL Queries."""

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

UPDATE_REMAPPED_UPC = """
  UPDATE upc_remap
  SET remapped_upc = %s
  WHERE original_upc = %s
  AND catalog_ingestion_source_id = %s;
"""

INSERT_INTO_ADDED_STORE_CARVEOUTS = """
  INSERT INTO product_added_store_carveout (
    upc, store_id
  ) VALUES (%s, %s);
"""

CLEAR_PREVIOUS_ADDED_STORE_CARVEOUTS = """
  DELETE FROM product_added_store_carveout
  WHERE upc = %s;
"""