How to update a column without loading the object in ActiveRecord

Question

Foo.where(:some_id => 1).update_all(:some_columnn => "1")

Is this the right way to update Foo? I don't want to do a find and update the object.

Answer 1

As of Rails 4, the conditions are no longer supplied on the update_all method, but are instead specified on the preceding collection. For example,

# updates everything, as usual
Foo.update_all(some_column: '1')

# update only the specified rows
Foo.where(some_id: 1).update_all(some_column: '1')

Answer 2

Yes it is the right way, but remember, no callbacks or validations will be executed.

BTW, update_all accepts conditions also. Like this

Foo.update_all({:some_columnn => "1"}, {:some_id => 1})