Single step batch delete in Ruby on Rails

Question

How to send such a query to database server from Rake task without removing record-by-record in "each" loop?

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

score 9 · Accepted Answer · answered May 15 '12 at 11:57

9

ActiveRecord has the delete_all method for you. Note that it does not call the destroy callbacks. http://api.rubyonrails.org/classes/ActiveRecord/Relation.html#method-i-delete_all

answered May 15 '12 at 11:57

jimworm

Is there a rails console function which calls destroy callbacks when deleting parents? – W.M. Sep 04 '17 at 18:52
4

`.destroy_all` does it but that is not a single-step batch delete the question asked for. – jimworm Oct 04 '17 at 10:32

Cc Won · Answer 2 · 2022-06-29T01:51:17.477

0

For me, I use small query to iterate over deletes

while Topic.limit(1000).delete_all > 0 do
  next
end

edited Jun 29 '22 at 01:51

answered Jun 21 '22 at 02:01

Cc Won

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Jun 21 '22 at 06:35

2 Answers2