"""SQL queries for art_relations and publishing."""


INSERT_HFA_ORCHARD_TRACK_LICENSES = """
    INSERT INTO hfa_orchard_track_licenses
    (orchard_track_id, state, hfa_configuration_code, created_at)
    VALUES
    (%s, %s, %s, CURRENT_TIMESTAMP);
    """

CHECK_HFA_PROCESS_FOR_DATE = """
    SELECT COUNT(*) AS cnt
    FROM hfa_orchard_track_licenses
    WHERE DATE(created_at) = Date(%s);
"""