essential_builder_db::sql::delete

Constant OLDEST_SOLUTION_FAILURES

Source 
pub const OLDEST_SOLUTION_FAILURES: &str = "DELETE FROM solution_failure\nWHERE id IN (\n    SELECT id\n    FROM solution_failure\n    ORDER BY attempt_block_num ASC, attempt_solution_ix ASC\n    LIMIT CASE\n        WHEN (SELECT COUNT(*) FROM solution_failure) > :keep_limit\n        THEN (SELECT COUNT(*) FROM solution_failure) - :keep_limit\n        ELSE 0\n    END\n)\n";
Expand description
DELETE FROM solution_failure
WHERE id IN (
    SELECT id
    FROM solution_failure
    ORDER BY attempt_block_num ASC, attempt_solution_ix ASC
    LIMIT CASE
        WHEN (SELECT COUNT(*) FROM solution_failure) > :keep_limit
        THEN (SELECT COUNT(*) FROM solution_failure) - :keep_limit
        ELSE 0
    END
)