Update model with array of IDs

luislavena · February 21, 2012, 4:25pm

Hi,
I am trying to use the update method of activerecord with an array of
ids as the first param.
It does not update any row. The APIs say that it should work.

The array contains 2 IDs.
RSCampaign.update([1,2], {:end_date =>
Date.strptime(“120228”,"%y%m%d")})

If I put an ID instead of the array, it updates fine.

Please help.

I am using ruby 1.8.6

raj_plays · February 21, 2012, 4:33pm

On 21 February 2012 15:25, Rajarshi C. [email protected]
wrote:

I am trying to use the update method of activerecord with an array of
ids as the first param.
It does not update any row. The APIs say that it should work.

What error message do you get? Do both of those IDs map to records? Do
either
of them get updated?

raj_plays · February 21, 2012, 6:30pm

Hey,
I get no error message.
It just doesn’t update any record.
Both the IDs are there in the DB table.

What’s more, even this does not work…
RSCampaign.update([1], {:end_date =>
Date.strptime(“120228”,"%y%m%d")})

though this works…
RSCampaign.update(1, {:end_date =>
Date.strptime(“120228”,"%y%m%d")})

Help please…

raj_plays · February 21, 2012, 8:01pm

On 21.02.2012, at 19:25, Rajarshi C. wrote:

Hi,
I am trying to use the update method of activerecord with an array of
ids as the first param.
It does not update any row. The APIs say that it should work.

The array contains 2 IDs.
RSCampaign.update([1,2], {:end_date =>
Date.strptime(“120228”,"%y%m%d")})

If I put an ID instead of the array, it updates fine.

API says that exactly:
RSCampaign.update([1,2], {:end_date
=>[Date.strptime(“120228”,"%y%m%d")}]*2)

raj_plays · February 21, 2012, 8:04pm

On 21.02.2012, at 19:25, Rajarshi C. wrote:

Hi,
I am trying to use the update method of activerecord with an array of
ids as the first param.
It does not update any row. The APIs say that it should work.

The array contains 2 IDs.
RSCampaign.update([1,2], {:end_date =>
Date.strptime(“120228”,"%y%m%d")})

sorry

RSCampaign.update([1,2], [{:end_date
=>Date.strptime(“120228”,"%y%m%d")}]*2)

raj_plays · February 21, 2012, 9:01pm

On 21.02.2012, at 23:42, Rajarshi C. wrote:

Thank you, Valery.
You are my hero.
Can you please post a link to the APIs?

api.rubyonrails.org

or

github.com

rails/rails/blob/d22592a05b299c21e30ec8b38890a178dca863b4/activerecord/lib/active_record/relation.rb#L312


      
          # * +id+ - This should be the id or an array of ids to be updated.
          # * +attributes+ - This should be a hash of attributes or an array of hashes.
          #
          # ==== Examples
          #
          #   # Updates one record
          #   Person.update(15, :user_name => 'Samuel', :group => 'expert')
          #
          #   # Updates multiple records
          #   people = { 1 => { "first_name" => "David" }, 2 => { "first_name" => "Jeremy" } }
          #   Person.update(people.keys, people.values)
          def update(id, attributes)
            if id.is_a?(Array)
              id.each.with_index.map {|one_id, idx| update(one_id, attributes[idx])}
            else
              object = find(id)
              object.update_attributes(attributes)
              object
            end
          end

people = { 1 => { “first_name” => “David” }, 2 => { “first_name” =>
“Jeremy” } }
Person.update(people.keys, people.values)

people is a Hash
people.keys is an Array of keys # [1,2]
people.values is an Array of values # [{ “first_name” => “David” }, {
“first_name” => “Jeremy”}]

raj_plays · February 21, 2012, 8:42pm

Thank you, Valery.
You are my hero.
Can you please post a link to the APIs?