ruby - Rails 3 查询 : Find all Posts with the same Topic

Question

我正在尝试创建一个查询来查找属于同一主题 ID 的所有帖子。我相信我在正确的轨道上，但所有 @posts 返回的是数据库中的每篇文章。

主题 Controller :

def show
  @topic = Topic.find(params[:id])
  @title = @topic.name
  @posts = Post.where('topic' == @topic).order("updated_at").page(params[:page]).per(10) #not working. still just fetches all posts
  respond_with(@posts)
end

主题模型:

class Topic < ActiveRecord::Base
  has_many :posts, :dependent => :destroy
  attr_accessible  :name
end

后模型:

class Post < ActiveRecord::Base
  belongs_to :topic,    :touch => true
  accepts_nested_attributes_for :topic
  attr_accessible :name, :title, :content, :topic, :topic_attributes
end

Answer 1

我建议您使用模型中的关联来获取所有帖子。你可以这样做:

def show
  @topic = Topic.find(params[:id])
  @title = @topic.name
  @posts = @topic.posts.order("updated_at").page(params[:page]).per(10)     
  respond_with(@posts)
end