How to optimize update_all calls

Question

Currently, I'm doing the update_all with concatenation like this:

collection.update_all(flag: false)
collection.update_all(["description = CONCAT(description, ?)", 'not_available'])

Is it possible to do it at once?

Obviously, this construction doesn't work:

collection.udpate_all(flag: false, ["description = CONCAT(description, ?)", 'not_available'])

Answer 1

update_all can take array, so you should be able to do something like this:

collection.udpate_all([
  "description = CONCAT(description, ?)", flag = ?,
  'not_available',
  false
])