"""
This file contains queries that are used to fetch information from track_fingerprint.codegen_error
"""

"""
QUERY_CODEGEN_ERROR_TUID returns tuids from codegen_error table that are in the provided list
"""

QUERY_CODEGEN_ERROR_TUID = """
SELECT tuid
FROM   codegen_error
WHERE  tuid IN( {} )
"""

"""
QUERY_CODEGEN_ERROR_RECENT_ROWS retrieves the most recent 5 rows from codegen_error table.
It is used by monitor_backfill.py to allow us to monitor the progress of the fingerprint
backfill.
"""
QUERY_CODEGEN_ERROR_RECENT_ROWS = """
SELECT tuid,
       upc,
       filename,
       error_message,
       datetime_added_utc,
       datetime_updated_utc,
       file_upload_time_utc,
       created_by,
       updated_by,
       correlation_id,
       track_source
FROM   codegen_error
ORDER  BY id DESC
LIMIT  5
"""


"""
QUERY_CODEGEN_ERROR_STATS retrieves count and min/max tuid from codegen_error table.
It is used by monitor_backfill.py.
"""
QUERY_CODEGEN_ERROR_STATS = """
SELECT Count(1)  AS num_rows,
       Min(tuid) AS min_tuid,
       Max(tuid) AS max_tuid
FROM   codegen_error
"""