I have a model called Agency.
One of the rows from an Agency active record looks as follows:
#<Agency id: 1, name: "Hello", contact_person: "Abhimanyu", phone_number: "946159", email: "[email protected] ", local_package: false, outstation: true, remarks: nil, status: 1> Here I want to change the value of status to 0 . How can I do that?
4 Answers
Ruby on Rails provides many methods for updating an activerecord. You can get differences of each method from this blog post.
agency = Agency.find(1) agency.update(status: 0) agency.update_attribute(:status, 0) agency.update_column(:status, 0) agency.update_columns(status: 0) You can also use this
Agency.find(1).update_column(:status, 0)
You need the update_column method. Try this:
agency = Agency.find(1) agency.update_column(:status, 0) You should spend some time reading the Ruby on Rails Guides.
To update, you can use:
agency.update_column(:status, 0) But update_column will ignore all the validations that you may have on your model.
If you don’t want to ignore your model validations, I recommend you to use:
agency.update status: 0 The method update_attributes is deprecated on rails 6 (https://blog.saeloun.com/2019/04/15/rails-6-deprecates-update-attributes.html)
To find the record that you want to update, you can use .find or .where methods. If you can find by ID use:
agency = Agency.find(1) If you need to find by other fields, use .where:
agency = Agency.where(email: '[email protected]').first The .first is used since the .where will return a Array with objects, and you need to select an object inside. If the object that you want isn't the first one, you can use .last.
ncG1vNJzZmirpJawrLvVnqmfpJ%2Bse6S7zGiorp2jqbawutJoa25qZWeGeYCOoaawZZOWu261jK6nnZmkmnqiedKpnJyhlp6wbq%2FOpaympl2eu26tzWaYnKyZq7KzscKoqZ1lmaN6s8HBsmSopl2nrqq40g%3D%3D