"""
SQL to check missing encoding orders.

See sp_eocheck.sql for details.
"""

# TODO: sp_eocheck works in jenkins, but only DISTRIBUTION.DEV.sp_eocheck works locally.
SQL_SP_ENCODING_ORDER_CHECK = """
CALL sp_eocheck('{}', '{}', 'distro_support', '{}', TRUE)
"""

SQL_RESULT_MISSING_ENCODING_ORDER = """
SELECT RELEASE_ID, UPC, REASON, ARRAY_TO_STRING(DMS_IDS,',') as DMS_LIST
FROM {}
"""