Rails 2.3.x 中通过关联过滤记录有很多

Question

我有三个模型通过 has_many_through 关联连接。

class Board < ActiveRecord::Base
has_many   :celebrations, :dependent => :destroy
has_many   :users, :through => :celebrations

class User < ActiveRecord::Base
has_many :boards,
         :through => :celebrations
has_many :celebrations, :dependent => :destroy

class Celebration < ActiveRecord::Base
belongs_to :user
belongs_to :board

class CreateCelebrations < ActiveRecord::Migration
  def self.up
   create_table :celebrations do |t|
      t.column :board_id,        :int, :null => false
      t.column :user_id,         :int, :null => false 
      t.column :role,        :string, :null => false
      t.column :token,       :string
      t.timestamps
      end
  end

我想获取特定论坛的所有用户，其中用户的角色是朋友。该角色位于 Celebrations 表中。

我已在控制器中尝试了以下操作：

@friends = User.condtions(:celebrations => {:role => "FRIEND", :board_id => session[:board_id]})

其结果是：

NoMethodError in FriendsController#show

undefined method `condtions' for #<Class:0x1023e3688>

我已尝试：

@friends = Board.find(session[:board_id]).celebrations.conditions(:role => "FRIEND").joins(:user)

其结果是：

ArgumentError in FriendsController#show

wrong number of arguments (1 for 0)

如何获取具有特定板的好友角色的用户？

预先非常感谢您。

这有效：

board = Board.find(session[:board_id])
@friends = board.users.find(:all, :conditions => ["celebrations.role = ?", "FRIEND"])

Answer 1

我在 Board.rb 文件中扩展了类关联。

has_many   :users, :through => :celebrations do
           def by_role(role) #great for returning all of the users whose role is FRIEND
               find(:all, :conditions => ["celebrations.role = ?", role])
               end
           end

然后我可以在我的控制器中调用以下内容。

board = Board.find(session[:board_id])
@friends = board.users.by_role("FRIEND")

感谢 Josh Susser 和他的博客