"""SQL queries for art_relations."""

SELECT_UPCS = """
    SELECT upc from upcs
    WHERE (`status` = "unused")
    OR (`status` = "claimed" AND last_updated < (NOW() - INTERVAL 12 HOUR))
    ORDER BY upc
    LIMIT :offset,:limit
    FOR UPDATE;
    """

UPDATE_STATUS = """
    UPDATE upcs
    SET `status` = "claimed", `last_updated` = NOW()
    WHERE upc IN :list AND ((`status` = "unused")
    OR (`status` = "claimed" AND last_updated < (NOW() - INTERVAL 12 HOUR)));
    """