Update instance variable to actual active record

I have three models as you can see below.

class Watchedfamily < ActiveRecord::Base
has_many :watchedmembers, :dependent => :destroy
accepts_nested_attributes_for :watchedmembers
has_many :old_watchedmembers, :dependent => :destroy
accepts_nested_attributes_for :old_watchedmembers
end

class OldWatchedmember < ActiveRecord::Base
belongs_to :watchedfamily
end

class Watchedmember < ActiveRecord::Base
belongs_to :watchedfamily
end

Now I have a method in my controller that is (for a given
watchedfamily) copying all entries of watchedmembers to
old_watchedmembers and then deleting the watchedmember entries.
Finally I am updating the watchedfamily with new watchedmembers. I
just need it for comparing old members with actual members.

Everything is working great in my database. I only have one problem in
the controller below. I need the @family.watchedmembers for a next
step, but the problem is that the @family.watchedmembers variable has
the old and the new members in its memory. The database is updated and
correct! It is only the @family.watchedmembers variable that has both
members in it.

My solution is to just call again: ‘@watchedfamily =
Watchedfamily.find(id)’ to get the recent data from the db.

Is that the only possibily or is that bad because of additional load
on the db?

id = params[:id]
@watchedfamily = Watchedfamily.find(id)

@watchedfamily.watchedmembers.each do |member|
params = {:watchedfamily => {:old_watchedmembers_attributes =>
MyExistingMemberEntries } }
@watchedfamily.update_attributes(params[:watchedfamily]) #copy
watchedmember to old_watchedmember
member.destroy #destroy watchedmember
end

params = {:watchedfamily => {:watchedmembers_attributes =>
MyNewMemberEntries } }
@watchedfamily.update_attributes(params[:watchedfamily]) #create
recent watchedmembers

@watchedfamily = Watchedfamily.find(id) #call the variable again from
the db to get the actual data!

@watchedfamily.watchedmembers.each do |x|
#some code for the next step
end

I hope someone can give me a hint!
Cheers,
Sebastian

On May 11, 8:13am, Sebastian [email protected] wrote:

Everything is working great in my database. I only have one problem in
the controller below. I need the @family.watchedmembers for a next
step, but the problem is that the @family.watchedmembers variable has
the old and the new members in its memory. The database is updated and
correct! It is only the @family.watchedmembers variable that has both
members in it.

By default, ActiveRecord caches the found records for an association -
doing this:

@family.watchedmembers(true)

will force the association to reload from the database.

–Matt J.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs