How to Destroy multiple objects simultaneously in Rails 3

Question

I have a Rails application that is trying to delete multiple objects at a time.

I have tried like sending set of id seperated by ',' to rails destroy method,but it destroy only single object. Is it possible to delete multiple objects in rails 3.

The answer has given is correct, but just for knowledge go through the difference of delete_all and destroy_all. This would help you : http://stackoverflow.com/questions/6698207/delete-all-vs-destroy-all — Anand Soni, Jan 21 '13 at 07:57

Eugene Rourke · Accepted Answer · 2013-01-21T09:23:03.010

129

destroy_all destroys the records matching conditions by calling destroy method for each instantiating record. So object’s callbacks are executed.

Model.destroy_all(:status => "inactive")
Model.where(:id => [1,2,3,4,5]).destroy_all
Model.where(:id => 1..5).destroy_all

UPDATE

User.where(:id => params[:ids]).destroy_all

/users?ids[]=1&ids[]=2&ids[]=3

edited Jan 21 '13 at 09:23

answered Jan 21 '13 at 07:41

Eugene Rourke

4,934
1
22
24

how to pass array of id , i tried like http://localhost:3000/users/id=[1,2,3,4]....Does rails accept this routes... – Cyber Jan 21 '13 at 08:43
can you snow routes.rb file? – Eugene Rourke Jan 22 '13 at 06:43

score 8 · Answer 2 · answered Jan 21 '13 at 07:27

8

Model.delete([1,2,5,6])

or

Model.delete_all(["col_name in (?)", [1,2,5,6]])

Just pass the ids array

answered Jan 21 '13 at 07:27

Sachin R

11,606
10
35
40

16

delete is not the same thing as destroy. – Sergio Tulentsev Jan 21 '13 at 07:50
How to pass array of ids ... i am getting a routing error when i tried like above... – Cyber Jan 22 '13 at 04:44

score 2 · Answer 3 · answered Aug 02 '18 at 14:18

I had exactly the same problem, but the solution here did not work for me in rails 5.1.6.

Perhaps you pass parameter params[:ids] in the wrong way.

Here's how I fix it.

Before

Model.where(:id => params[:ids]).destroy_all

After

ids = params[:ids].split(",")
Model.where(:id => ids).destroy_all

score 0 · Answer 4 · answered Mar 01 '17 at 10:24

If performance is important to you and/or if you work on a large dataset you should prefer delete_all over destroy_all.

Destroy_all will execute a DELETE query one at a time. So it can be very slow. More details about the differences between delete_all and destroy_all can be found on this page.

Since the @M Kumar's answer will be deprecated with the new rail's version.

Model.delete_all(["col_name in (?)", [1,2,5,6]])
DEPRECATION WARNING: Passing conditions to delete_all is deprecated and will be removed in Rails 5.1.

This command might help other's in the future :

Model.where(id: [1,2,5,6]).delete_all

score 0 · Answer 5 · answered Jul 06 '18 at 13:30

0

You can also delete for a range of Ids. Say you have 1500 records and you want to delete from 751 to last:

a = Model.where(id: [751..1500])
a.destroy_all

answered Jul 06 '18 at 13:30

LordKiz

603
6
15

How to Destroy multiple objects simultaneously in Rails 3

5 Answers5

Before

After

Linked

Related