Method summary to update multiple columns [Ruby on Rails]

Rails has multiple methods to update multiple columns at the same time, so I've summarized the differences.


Features </ strong>

  • DB is not saved.
  • alias is attributes =

Usage </ strong> (if you have a table called User)

user = User.first
user.assign_attributes(family_name: "foo", given_name: "bar")

#attribute=in the case of
user.attributes = { family_name: "foo", given_name: "bar" }

It is not saved, so you need to call save.


Features </ strong>

  • Saved in DB.
  • alias is update
  • Validation checks and callback calls are also performed.
  • Returns whether saving is true or false.

Usage example </ strong>

user = User.first
user.update_attributes(family_name: "foo", given_name: "bar")

#For update
user.update(family_name: "foo", given_name: "bar")

There is no need to call save separately.


Features </ strong>

  • If saving fails, an exception will be thrown.
  • alias is update!

Usage example </ strong>

user = User.first
user.update_attributes!(family_name: "foo", given_name: "bar")

#update!in the case of
user.update!(family_name: "foo", given_name: "bar")

The way to return the result is different from update_attributes.


Features </ strong>

  • The fastest update speed because it accesses the database directly.
  • No validation check or callback call.
  • update_at is not updated.

Usage example </ strong>

user = User.first
user.update_columns(family_name: "foo", given_name: "bar")

Please note that there are no validation checks or callback calls.


Recommended Posts