sql - ActiveRecord Joins -


ok, so, if user.joins(:session_users), attributes of users table.

how attributes of both tables in activerecord way, i.e., not sql?

edit one

ok, based on first answer, i'm trying have displayed.

so, method written in users controller

def blah    @users = user.includes(:session_users)     @users.each |user|       user.session_users     end end  

then have in users view blah.html.erb

 <%= @users.session_users %>  

and in routing section:

  match "/users/blah" => "users#blah" 

i think want includes instead of joins. see http://railscasts.com/episodes/181-include-vs-joins more info. should fetch columns both,

users = user.includes(:session_users) users.each |user|   user.session_users end 

note, still performs 2 sql queries.

edit

updated answer assumes user has_many :session_users

routes:

# config/routes.rb  '/users/blah' => 'users#blah' 

controller:

# app/controllers/users_controller.rb  class userscontroller < applicationcontroller   def blah     @users = user.includes(:session_users)   end end 

view:

# app/views/users/blah.html.erb  <% @users.each |user| %>    <%= user.name %> // assumes user has name attribute    <% user.session_users.each |session_user| %>     <%= session_user.attributes %> // prints attributes     <%= session_user.created_at %> // assumes user has created_at attribute   <% end %>  <% end %> 

Comments

Popular posts from this blog

PHPMotion implementation - URL based videos (Hosted on separate location) -

javascript - Using Windows Media Player as video fallback for video tag -

c# - Unity IoC Lifetime per HttpRequest for UserStore -