CODEWITHSUNDEEP
ruby-on-railsherokurails-console
Ian Ellis
Ian Ellis

Reputation: 541

Ruby on Rails: Update Attribute

Google is seriously failing me right now. All I need to do is update one attribute, setting a user to admin, from the Heroku rails console.

I can't find a single simple answer. What I've been trying is:

Record.update_attribute(:roles_mask, "1")

Where record is the correct record.

'undefined method 'update attribute''

I can't just type Record.roles_mask = 1?

EDIT.

I used Record, and I shouldn't have done that in the example. What I've done is exactly this:

ian = User.where(:id => '5')

ian.update_attribute(:roles_mask, '1')

Error: undefined method 'update_attributes'

Upvotes: 5

Views: 8494

Answers (3)

uma
uma

Reputation: 2952

Where clause return a array and you are trying to make update query on array, that's why you got error.

you should try to find out first record

ian = User.where(:id => 1).first
or
ian = User.find(1)
or
ian = User.find_by_id(1)

now your update query will work.

ian.update_attribute(:roles_mask, '1')

Upvotes: 1

Mike S
Mike S

Reputation: 11409

The problem is that using the .where function creates a relation, rather than finding the record itself. Do this:

ian = User.find(5)
ian.update_attribute(:roles_mask, '1')

Or if you want to use .where then you could do this:

ian = User.where(:id => 5)
ian.first.update_attribute(:roles_mask, '1')

EDIT

See this answer for details about why this is happening.

Upvotes: 10

craig.kaminsky
craig.kaminsky

Reputation: 5598

To use update_attribute (or update_attributes), you need to call that from an instance and not the class. 

rails c> rec = Record.find(1)
rails c> rec.update_attribute(:att, 'value')
rails c> rec.update_attributes(att: 'value', att2: 'value2')

I would think that should take care of your issue.

Upvotes: 3

Related Questions