CODEWITHSUNDEEP
sqlruby-on-railsactiverecord
Noam B.
Noam B.

Reputation: 3250

Rails - Delete all Records that Meet a Condition

How do you write in the Rails way? I have a model - Managers. I want to delete all records from Managers that meet the condition that manager_level is 5.

Thank you.

Upvotes: 53

Views: 55840

Answers (4)

Navarasu
Navarasu

Reputation: 8489

After Rails 5.1., We cannot pass conditions to delete_all/destroy_all method

Manager.where(:manager_level => 5).delete_all

This will run multiple queries to delete each record

But in Rails 6, we can use delete_by to delete using condition,

Manager.delete_by(manager_level: 5)

This will run single delete query

delete from managers where manager_level = 5

Upvotes: 9

MurifoX
MurifoX

Reputation: 15109

I think it is better to use destroy instead of delete

because destroy will delete current object record from db and also its associated children record from db (https://stackoverflow.com/a/22757656/5452072)

Also delete will skip callbacks, but destroy doesn't.

Manager.where(:manager_level => 5).destroy_all

Upvotes: 90

Andrew Hare
Andrew Hare

Reputation: 351758

Try this:

Manager.delete_all(manager_level: 5)

Upvotes: 36

iouri
iouri

Reputation: 2929

This should work:

Manager.where(:manager_level => 5).delete_all

Note: This will not remove dependent records.

Upvotes: 21

Related Questions