undefined method `update_attributes' for #<Array:0xb5d61608> rails 4

Question

I have the below action in my controller

cust = Customer.where(email: 'test@testing.com').pluck(:post_id)
@posts = Post.find(cust)
if params[:status]
  if @posts.update_attribute(:customer_id, customer_id)
    respond_to do |format|
      format.json { render json: 'test'}
    end
  end
end

The above update_attribute is throwing undefined method error.

cust will return array of ids such as [1,2,3]

How can I do this

Answer 1

Try this

cust = Customer.where(email: 'test@testing.com').pluck(:post_id)

Post.update_all({:customer_id, customer_id}, {id: cust})

we can include the where clause in the update_all query itself

Answer 2

try to alter the queries in the following way

cust = Customer.where(email: 'test@testing.com').first.pluck(:post_id)

This will return a single customer, then do the same thing with post @posts = Post.where(id: cust).first

However, if you want multiple records in @posts, then you'll need to loop through them all and update individually.

@posts.each do |post| if post.update_attribute(:customer_id, customer_id) end end

Answer 3

Try:

@posts = Post.where(id: cust)
@posts.update_all(customer_id: customer_id)

It constructs a single SQL UPDATE statement and sends it straight to the database.