"""SQL queries for direct_delivery."""

# Get Vector order errors
SELECT_VECTOR_ORDER_ERRORS = """
    SELECT
        id,
        vector_order_id,
        error_timestamp,
        last_updated_at
    FROM
        vo_sync_errors
    WHERE
        vector_order_id IN :order_ids
        AND is_resolved = False
    ;
"""

# Resolve error record for Vector orders by setting vo_sync_errors.is_resolved
# to True.
UPDATE_VECTOR_ORDER_SYNC_ERRORS_SET_RESOLVED = """
    UPDATE
        vo_sync_errors
    SET
        is_resolved = True
    WHERE
        id = :error_record_id
    ;
"""