CODEWITHSUNDEEP
ruby-on-railsruby-on-rails-3activerecord
John F. Miller
John F. Miller

Reputation: 27227

Does the update_all method in ActiveRecord return the number of rows?

I want to set the 'lock' column on a row only if it is not already set. Race conditions are likely and performance is important so this must be done in a single query. I think the solution should look like this:

class MyModel
  def lock(worker)
    cnt = MyModel.where(id: self.id, lock: nil).update_all(:lock=>worker.name)
    cnt == 1
  end
end

Does the update_all method actually return the number of rows effected like it does in DataMapper?

Upvotes: 5

Views: 3438

Answers (1)

fl00r
fl00r

Reputation: 83680

Yes, it does in ActiveRecord as in DataMapper

Upvotes: 6

Related Questions