Hi there.
I've got a very nasty problem with loading objects in Rails 2.3.5
I want to preload a set of objects with their associations. I'm trying
to do something like that:
@members = Guildsman.find(:all, :include => [{:roster_items =>
:roster},{:gm_lineups => :lineup}], :conditions =>
['lineups.name<>?','zzz'])
with this i'm getting SQL-query:
Guildsman Load Including Associations (3.0ms)[0m [0m SELECT
"guildsmen"."id" AS t0_r0, "guildsmen"."name" AS t0_r1,
"guildsmen"."user_id" AS t0_r2, "guildsmen"."mol" AS t0_r3,
"guildsmen"."created" AS t0_r4, "guildsmen"."accepted" AS t0_r5,
"gw_roster_items"."id" AS t1_r0, "gw_roster_items"."roster_id" AS t1_r1,
"gw_roster_items"."gm_id" AS t1_r2, "gw_roster_items"."char_id" AS
t1_r3, "gw_roster_items"."penalty" AS t1_r4,
"gw_roster_items"."created_at" AS t1_r5, "gw_roster_items"."updated_at"
AS t1_r6, "gw_rosters"."id" AS t2_r0, "gw_rosters"."doc_id" AS t2_r1,
"gw_rosters"."dt" AS t2_r2, "gw_rosters"."gwtype" AS t2_r3,
"gw_rosters"."created_at" AS t2_r4, "gw_rosters"."updated_at" AS t2_r5,
"guildsmen_lineups"."id" AS t3_r0, "guildsmen_lineups"."lineup_id" AS
t3_r1, "guildsmen_lineups"."gm_id" AS t3_r2,
"guildsmen_lineups"."dt_start" AS t3_r3, "guildsmen_lineups"."dt_end" AS
t3_r4, "guildsmen_lineups"."created_at" AS t3_r5,
"guildsmen_lineups"."updated_at" AS t3_r6, "lineups"."id" AS t4_r0,
"lineups"."codename" AS t4_r1, "lineups"."name" AS t4_r2,
"lineups"."fee" AS t4_r3, "lineups"."created_at" AS t4_r4,
"lineups"."updated_at" AS t4_r5 FROM "guildsmen" LEFT OUTER JOIN
"gw_roster_items" ON gw_roster_items.gm_id = guildsmen.id LEFT OUTER
JOIN "gw_rosters" ON "gw_rosters".id = "gw_roster_items".roster_id LEFT
OUTER JOIN "guildsmen_lineups" ON guildsmen_lineups.gm_id = guildsmen.id
LEFT OUTER JOIN "lineups" ON "lineups".id =
"guildsmen_lineups".lineup_id WHERE (lineups.name<>E'zzz')
and then in view i use:
<%...@members.each do |gm|%>
...
<%=gm.gm_lineups.last.lineup.name%>
...
<%end%>
The first time it works perfect by on the very first refresh of the page
i'm getting an error with such stack:
C:/programs/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/attribute_methods.rb:142:in
`create_time_zone_conversion_attribute?'
C:/programs/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/attribute_methods.rb:75:in
`define_attribute_methods'
C:/programs/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/attribute_methods.rb:71:in
`each'
C:/programs/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/attribute_methods.rb:71:in
`define_attribute_methods'
C:/programs/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/attribute_methods.rb:351:in
`respond_to?'
C:/programs/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/associations/association_proxy.rb:213:in
`method_missing'
D:/work/aptana/tax/trunk/app/views/cadre/gw_roster/index.html.erb:18:in
`_run_erb_app47views47cadre47gw_roster47index46html46erb'
D:/work/aptana/tax/trunk/app/views/cadre/gw_roster/index.html.erb:11:in
`each'
D:/work/aptana/tax/trunk/app/views/cadre/gw_roster/index.html.erb:11:in
`_run_erb_app47views47cadre47gw_roster47index46html46erb'
If i remove the :conditions part of select like that:
@members = Guildsman.find(:all, :include => [{:roster_items =>
:roster},{:gm_lineups => :lineup}])
then i'm getting several different queries for this select:
[4;35;1mGuildsman Load (0.0ms)[0m [0mSELECT * FROM "guildsmen" [0m
[4;36;1mGwRosterItem Load (1.0ms)[0m [0;1mSELECT "gw_roster_items".*
FROM "gw_roster_items" WHERE ("gw_roster_items".gm_id IN (5,6,8,9)) [0m
[4;35;1mGuildsmanLineup Load (0.0ms)[0m [0mSELECT
"guildsmen_lineups".* FROM "guildsmen_lineups" WHERE
("guildsmen_lineups".gm_id IN (5,6,8,9)) [0m
[4;36;1mLineup Load (1.0ms)[0m [0;1mSELECT * FROM "lineups" WHERE
("lineups"."id" IN (1,4)) [0m
and then everything works pretty well
i guess that Rails can't properly populate objects with data from single
query but i can't understand how to fix it. Will be grateful for any
information.
--
Posted via http://www.ruby-forum.com/.
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to rubyonrails-t...@googlegroups.com.
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
