sql - Ruby on Rails中的单步批处理删除

Question

如何在不删除“每个”循环中的逐条记录的情况下从Rake任务向数据库服务器发送这样的查询？

delete from data
where uuid in (
    select uuid
    from data
    group by uuid, raw, recdate
    having count(*)>1
);

Answer 1

ActiveRecord为您提供了delete_all方法。请注意，它不会调用destroy回调。 http://api.rubyonrails.org/classes/ActiveRecord/Relation.html#method-i-delete_all