dublicate display of Posts from controller - conditions and joins problem - Ruby on Rails

Posted by bgadoci on Stack Overflow See other posts from Stack Overflow or by bgadoci
Published on 2010-04-15T15:36:11Z Indexed on 2010/04/15 17:33 UTC
Read the original article Hit count: 580

I have built a blog application using Ruby on Rails. In the application I have posts and tags. Post has_many :tags and Tag belongs_to :post.

In the /views/posts/index.html view I want to display two things. First is a listing of all posts displayed 'created_at DESC' and then in the side bar I am wanting to reference my Tags table, group records, and display as a link that allows for viewing all posts with that tag.

With the code below, I am able to display the tag groups and succesfully display all posts with that tag. There are two problems with it thought.

  1. /posts view, the code seems to be referencing the Tag table and displaying the post multiple times, directly correlated to how many tags that post has. (i.e. if the post has 3 tags it will display the post 3 times).

  2. /posts view, only displays posts that have Tags. If the post doesn't have a tag, no display at all.

/views/posts/index.html.erb

<%= render :partial => @posts %>

/views/posts/_post.html.erb

<% div_for post do %>

    <h2><%= link_to_unless_current h(post.title), post %></h2>
    <i>Posted <%= time_ago_in_words(post.created_at) %></i> ago
    <%= simple_format h truncate(post.body, :length => 300) %>
    <%= link_to "Read More", post %> | 
    <%= link_to "View & Add Comments (#{post.comments.count})", post %>


    <hr/>
<% end %>

/models/post.rb

class Post < ActiveRecord::Base
  validates_presence_of :body, :title
  has_many :comments, :dependent => :destroy
  has_many :tags, :dependent => :destroy

  cattr_reader :per_page
    @@per_page = 10

end

posts_controller.rb

def index
    @tag_counts = Tag.count(:group => :tag_name, :order => 'updated_at DESC', :limit => 10)
    @posts=Post.all(:joins => :tags,:conditions=>(params[:tag_name] ? 
                         { :tags => { :tag_name => params[:tag_name] }} : {}

                         )
                      ).paginate :page => params[:page], :per_page => 5

    respond_to do |format|
      format.html # index.html.erb
      format.xml  { render :xml => @posts }
      format.json { render :json => @posts }
      format.atom
    end
  end

© Stack Overflow or respective owner

Related posts about ruby-on-rails

Related posts about ruby