ruby-on-rails - 是否可以向 Rails 4 中的 LEFT OUTER JOIN 添加条件？

Question

鉴于这种结构:

class Account < ActiveRecord::Base
    has_many :users
    has_many :teams
    validates :name, presence: true
end

class User < ActiveRecord::Base
    belongs_to :account
    has_and_belongs_to_many :teams
    validates :name, presence: true
end

class Team < ActiveRecord::Base
    belongs_to :account
    has_and_belongs_to_many :users
    validates :name, presence: true
end

目标是获取帐户的所有团队 ID/名称的列表/数组，以及指示给定用户是否属于团队的标志。

在 SQL 中，我可以通过以下方式获得此结果:

SELECT teams.id, teams.name, 
     teams_users.team_id IS NOT NULL AS member FROM teams 
    LEFT OUTER JOIN teams_users ON 
        (teams.id = teams_users.team_id AND team_users.user_id = ?)
    WHERE teams.account_id = ?

是否有 Rails 4/ActiveRecord 方法可以获得相同的结果？我所做的每一次尝试都插入了 teams_users.user_id = ? WHERE 子句中的条件，它只返回用户是其成员的团队列表，而不是与帐户关联的所有团队。

Answer 1

应该可以使用 joins 的字符串形式.在插入字符串之前清理任何用户输入。

Team.select(:id, :name).
  select("teams_users.team_id IS NOT NULL AS member FROM teams").
  joins("LEFT OUTER JOIN teams_users ON (teams.id = teams_users.team_id AND team_users.user_id = #{current_user.id})").
  where(account_id: account.id)