Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 954
John F. Miller Avatar asked Feb 26 '11 21:02

John F. Miller


1 Answers

Yes, it does in ActiveRecord as in DataMapper

like image 56
fl00r Avatar answered Sep 29 '22 15:09

fl00r