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

Question

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.

Mr H · Accepted Answer · 2014-04-04 01:42:06Z

19

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

answered Apr 4, 2014 at 1:42

Mr H

5,3143 gold badges42 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rajan Verma - Aarvy Over a year ago

Is it possible to pass array in update_all, to make one to one corresponding update like. UserProduct.where(:user_id => [1,2,3,4,5]).update_all(:name => ["ball", "bat", "shelf", "boots", "net"]).

iain · Accepted Answer · 2010-12-15 22:18:26Z

18

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.

answered Dec 15, 2010 at 22:18

iain

16.3k4 gold badges40 silver badges42 bronze badges

Comments

Brian Rose · Accepted Answer · 2010-12-15 22:16:42Z

16

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

answered Dec 15, 2010 at 22:16

Brian Rose

1,72513 silver badges10 bronze badges

1 Comment

Rajan Verma - Aarvy Over a year ago

This is deprecated

Collectives™ on Stack Overflow

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

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related