"""Constants used by the lambda."""

INGEST_READY_STATUS = 'DELIVERED'
VALIDATION_FAILED_STATUS = 'VALIDATION_FAILED'
PURGED_RELEASE = 'PURGED_RELEASE'

INSERT_QUERY = """
INSERT INTO ddex_delivery_to_ingest(
    catalog_ingestion_source_id, s3_bucket_name, s3_key_name, status)
VALUES (%s, %s, %s, %s);
"""

INSERT_QUERY_SME_ANALYTICS = """
INSERT INTO ddex_delivery_to_ingest(
    catalog_ingestion_source_id, s3_bucket_name, s3_key_name,
    is_confidential, has_artwork, earliest_start_datetime,
    earliest_preorder_datetime, earliest_start_date, earliest_preorder_date,
    status, upc, grid, original_release_datetime)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);
"""