本文介绍了has_one通过与条件关联的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有3个相关的表格/模型。我想检索组织聚会的用户,给定Party记录,带有布尔值 organized 的联接表,以及一个用户

I have 3 relevant tables/models. I would like to retrieve the user which has organized a party, given a Party record, a join table with a boolean organized column, and a users table.

到目前为止,我最大的尝试(这对我来说很有意义)。我省略了不相关的列。

My best attempt so far (this one makes the most sense to me after much fiddling). I've omitted the irrelevant columns.

class Party
  # party_id

  has_many   :parties_users
  has_many   :users, through: :parties_users, source: :user
  has_one    :organizer,
             -> { where organizer: true },
             through: :parties_users,
             source: :user







class PartiesUser
  # party_id
  # user_id
  # organized:bool

  belongs_to :party
  belongs_to :user







class User
  # user_id
  has_many : parties_users






上述设置引发了以下错误,老实说我不完全理解:
ActiveRecord :: HasOneThroughCantAssociateThroughCollection(Cannot有一个has_one:through关联 Party#organizer,其中:through关联 Party#parties_users是一个集合。在:through选项中指定has_one或belongs_to关联。)

我知道我可以通过实例方法来执行此操作,但是考虑到使用的频率类型,将其作为关联可以大大受益于我的应用。

I know I can do this via an instance method, but given the frequency types of use, my app would massively benefit from having this as an association.

推荐答案

如错误消息所述,您无法通过has_many获得has_one。

As the error message says, you can't have a has_one through a has_many.

如果组织者标志在连接记录上,您可以(相反)这样做...

You could (instead) do it this way if the organizer flag is on the join record...

has_many :parties_users
has_many :users, through: :parties_users, source: :user
has_one :main_party_user, -> {where organizer: true}, class_name: 'PartiesUser'
has_one :organizer, through: :main_party_user, class_name: 'User'

这篇关于has_one通过与条件关联的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-11 16:49