interest topic. in console, use to_sql to represent SQL, Maybe found more hits.
2010/4/23 Will Prater <[email protected]> > More observations I've found. The Arel includes method does not seem > to respect HMT :select joins. I'd prefer to use the "includes" lazy- > laoding way, but cannot seem to get the extra attributes to come back. > > Both will return the Manager Model > ==================================== > ruby-1.8.7-p249 > p = Project.first.managers.first > => #<Manager id: 1, first_name: "Edward", last_name: "Scissorhands", > email: nil, phone: nil, created_at: "2010-04-22 22:52:29", updated_at: > "2010-04-22 22:52:29"> > > ruby-1.8.7-p249 > p = Project.includes(:managers).first.managers.first > => #<Manager id: 1, first_name: "Edward", last_name: "Scissorhands", > email: nil, phone: nil, created_at: "2010-04-22 22:52:29", updated_at: > "2010-04-22 22:52:29"> > > > Notice that all the extra attributes are NOT passed > =================================== > ruby-1.8.7-p249 > p = > Project.includes(:managers).first.managers.first.to_json > => "{\"created_at\":\"2010-04-22T22:52:29Z\",\"updated_at\": > \"2010-04-22T22:52:29Z\",\"id\":1,\"phone\":null,\"last_name\": > \"Scissorhands\",\"first_name\":\"Edward\",\"email\":null}" > > > Notice that all the extra attributes are passed > =================================== > ruby-1.8.7-p249 > p = Project.first.managers.first.to_json > => "{\"created_at\":\"2010-04-22T22:52:29Z\",\"updated_at\": > \"2010-04-22T22:52:29Z\",\"project_id\":\"1\",\"primary\":\"t\", > \"manager_id\":\"1\",\"id\":1,\"phone\":null,\"last_name\": > \"Scissorhands\",\"first_name\":\"Edward\",\"email\":null}" > > > Here is the setup in my Model > =================================== > has_many :managers_projects > has_many :managers, :through => :managers_projects, > :select => 'managers.*, managers_projects.project_id, > managers_projects.manager_id, managers_projects.`primary`' > > > > On Apr 21, 5:00 pm, Will Prater <[email protected]> wrote: > > Hello, > > > > How can one get the extra attributes from the association table while > > using lazy loading like so: > > > > # I have a HMT (rails3) association and am using the includes method > > to prepare my queries. But Im not able to get at the extra fields in > > the association table this way. > > > > # Schema > > create_table "consultants_projects", :force => true do |t| > > t.integer "consultant_id" > > t.integer "project_id" > > t.integer "pay_rate" > > t.integer "bill_rate" > > t.date "start_date" > > t.date "end_date" > > t.boolean "enabled", :default => true > > end > > > > add_index "consultants_projects", ["consultant_id"], :name => > > "index_consultants_projects_on_consultant_id" > > add_index "consultants_projects", ["project_id"], :name => > > "index_consultants_projects_on_project_id" > > > > # Model > > class Project < ActiveRecord::Base > > has_many :managers_projects > > has_many :managers, :through => :managers_projects > > > > # We want all the extra fields on the consultants_projects > > association > > has_many :consultants_projects > > has_many :consultants, > > :through => :consultants_projects, > > :select => 'consultants.*, consultants.id,'+ > > 'consultants_projects.id as consultants_projects_id, ' > > + > > 'consultants_projects.project_id,' + > > 'consultants_projects.pay_rate,' + > > 'consultants_projects.pay_rate,' + > > 'consultants_projects.bill_rate,' + > > 'consultants_projects.start_date,' + > > 'consultants_projects.end_date,' + > > 'consultants_projects.enabled AS > > consultants_projects_enabled' > > > > end > > > > # c = Consultant.includes(:projects) > > # c.first.projects > > # > > # Does not include the extra fields like pay_rate, bill_rate etc that > > are stored in the association table. > > > > -- > > 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 [email protected]. > > To unsubscribe from this group, send email to > [email protected]<rubyonrails-talk%[email protected]> > . > > For more options, visit this group athttp:// > groups.google.com/group/rubyonrails-talk?hl=en. > > -- > 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]<rubyonrails-talk%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > > -- tommy xiao E-mail: xiaods(AT)gmail.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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
