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

"""
QUERY_TRACK_FP_TUID returns tuids from track_fp table that are in the provided list
"""

QUERY_TRACK_FP_TUID = """
SELECT tuid
FROM   track_fp
WHERE  tuid IN( {} )
"""


"""
QUERY_TRACK_FP_STATS retrieves count and min/max tuid from track_fp table. It is
used by monitor_backfill.py to monitor progress of fingerprint backfill.
"""
QUERY_TRACK_FP_STATS = """
SELECT Count(1) as num_rows,
       Min(tuid) AS min_tuid,
       Max(tuid) AS max_tuid
FROM   track_fp
"""