In Rails, after using find with: select, my objects are not saved

Question

Running something like:

@users = User.find (: first ,: select => "first name, last name, salary") for @user in @users do @ user.salary = 100000 @ user.save end

After that, users are not updated in the Mysql table.

Answer 1

ActiveRecord does not know the identifier of the object to save data. Therefore, include the id field in: select, as shown below:

@users = User.find (: first ,: select => "id, name, lastname, pay")

Answer 2

, .
, : select. , . vars (@). @user var. @users, :

@users = User.find(:all, :select => "id, name, lastname, salary")
@users.each do |user|
  user.salary = 10000
  user.save
end

ActiveRecord update_all . , .

Answer 3

.update .update_attributes: ( .save, )

Answer 4

Using .save! will also throw an error if it does not save.

Answer 5

I understand that this is a rather old question at the moment, but the correct answer, I believe that any objects returned by: select, are read-only.

See the official Rails guide for Active Record queries, section 3.2:
http://guides.rubyonrails.org/active_record_querying.html

Curiously, I do not see this documented in the API.