Update Multiple Records with a single command in Ruby

Question

Basically I want to update an array of objects that my api recieves in a single command. I have done it when I was inserting but I couldn't find a way to do update it. Here is m create method for multiple insertions:

def create_all

    if Attendance.create attendance_params
        render json: { message: "attendance added" }, status: :ok
    else
        render json: { message: "error in creation" }, status: :bad_request
    end
end

Params:

def attendance_params
    params.require(:attendance).map do |p|

        p.permit(
            :student_id,
            :id,
            :attendance
        )
    end
end

I tried to do similar thing with update but it generates this error:

   Completed 500 Internal Server Error in 11ms (ActiveRecord: 2.7ms) 
   Argument Error (When assigning attributes, you must pass a hash as an argument.)

my update method is this:

def update_attendance
    if Attendance.update attendance_params
        render json: { message: "attendance updated" }, status: :ok
    end
end

Joe Edgar · Accepted Answer · 2020-04-14 16:28:33Z

1

ActiveRecord Create can take an array of hashes and create multiple records simultaneously.

However, ActiveRecord Update cannot.

You could potentially create an "update_batch" method on your model that allows for an array of hashes. You would have to send an array of hashes and each hash would have to include the id of the record you are updating (and allow that in your strong parameters definition). Then in your update_batch method you would have to grab the id from each hash and update each:

class Attendance < ActiveRecord
  def update_batch(attendance_records)
    attendance_records.each do |record|
      Attendance.find(record[:id]).update(record.except(:id))
    end
  end
end

edited Apr 14, 2020 at 16:28

answered Apr 13, 2020 at 19:32

Joe Edgar

9405 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Meherwer Ali Over a year ago

apparently this is working but I got forbidden attributes error. although I have defined strong attributes and have used them like this: StudentAttendance.find(record[:id]) .update_attributes!(student_attendance_params_for_update=(record))

TamerB · Accepted Answer · 2020-04-13 23:16:25Z

1

Please check this example and try applying it:

Attendance.where(:student_id => [23,45,68,123]).update_all(:attendance => true)

Or if you're trying to update all Attendance records:

Attendance.update_all(:attendance => true)

Also, please check this link: https://apidock.com/rails/ActiveRecord/Relation/update_all

answered Apr 13, 2020 at 23:16

TamerB

1,4411 gold badge13 silver badges28 bronze badges

1 Comment

Meherwer Ali Over a year ago

there are multiple records to be updated by multiple entries which are received in the form of an array update_all update all records with same value.

Collectives™ on Stack Overflow

Update Multiple Records with a single command in Ruby

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related