"""SQL queries."""

INSERT_INTO_PRODUCT = """
INSERT IGNORE INTO product (
    product_id,
    orchard_product_id,
    upc,
    itunes_vendor_id,
    provider)
VALUES (%(product_id)s, %(upc)s, '%(upc)s', '%(upc)s', 'orchard')
"""

INSERT_INTO_PRODUCT_IN_STORE = """
INSERT INTO product_in_store (store_id, product_id, store_internal_id,
store_internal_status, force_polling, status, received_for_polling_date,
delivery_date, sales_start_date, countries, go_live_date)
VALUES (286, %(product_id)s, %(album_uri)s, "", 1, "live", %(date_inserted)s,
%(release_date)s, %(release_date)s, %(countries)s, %(live_from)s)
ON DUPLICATE KEY UPDATE store_internal_id=VALUES(`store_internal_id`)
"""