CODEWITHSUNDEEP
ruby-on-railsormactiverecord
Chad Johnson
Chad Johnson

Reputation: 21895

Update multiple records simultaneously with ActiveRecord in Rails using one query?

Let's suppose I have a table called 'user_products' and a corresponding model called UserProduct in my Rails application. I also have a field called 'is_temporary' in my table. Now suppose I want to run a query like this but using the ActiveRecord abstraction layer:

UPDATE user_products SET is_temporary = false WHERE user_id = 12345;

Is there a way I can do this using ActiveRecord? Maybe something along the lines of

UserProduct.find_by_user_id(12345).update_attributes(:is_temporary => false)

I'd like only one query to be run for this to happen.

Upvotes: 14

Views: 11507

Answers (3)

Mr H
Mr H

Reputation: 5304

This is an old post. I updated this in case someone checks it :) (Rails 4)

DEPRECATION: Relation#update_all with conditions is deprecated. Please use Item.where(color: 'red').update_all(...) rather than Item.update_all(..., color: 'red').

So the query will be 

UserProduct.where(:user_id => 12345).update_all(:is_temporary => false)

Cheers

Upvotes: 19

iain
iain

Reputation: 16274

UserProduct.update_all({:is_temporary => false}, {:user_id => 12345})

Although beware: this skips all validations and callbacks, since no instance of UserProduct will ever be instanciated.

Upvotes: 18

Brian Rose
Brian Rose

Reputation: 1725

UserProduct.update_all({:is_temporary => false}, {:user_id => 12345})

Upvotes: 16

Related Questions