我在部門和研究人員之間的多對多關系中有一個名為關系的連接表。
我希望能夠通過做得到學生名單，Department.find(1).students但我得到ActiveRecord::HasManyThroughSourceAssociationNotFoundError (Could not find the source association(s) :students in model Researcher. Try 'has_many :students, :through => :researchers, :source => <name>'.)
為什么不使用表 Researcher 中的范圍？
class Department < ApplicationRecord
has_many :relations
has_many :researchers, through: :relations
has_many :students, source: :students, through: :researchers
has_many :advisors, source: :advisors, through: :researchers
end
class Relation < ApplicationRecord
belongs_to :researcher
belongs_to :department
end
class Reseacher < ApplicationRecord
scope :students, -> { where(type: 'Student') }
scope :advisors, -> { where(type: 'Advisor') }
end
class Student < Researcher
has_many :relations, foreign_key: :department_id
has_many :departments, through: :relations
end
class Advisor < Researcher
has_many :relations, foreign_key: :department_id
has_many :departments, through: :relations
end
uj5u.com熱心網友回復：
source:option 需要一個關聯作為引數。在內部，rails對引數進行反思，例如：
# source: :students, through: :researchers
>> Researcher.reflect_on_association(:students)
=> nil
在修復has_many :students Association 之前，需要注意以下幾點：
has_many :students, # will look for `students` association in the related
# class unless source is specified; related class is
# determined by reflecting on through option `:researchers`
#
# reflect_on_association(:researchers).klass # => Researcher
through: :researchers # can't go through `researchers`; already there.
# `Student` is a `Researcher`.
source: :students, # there is no `students` association in `Researcher` class.
#
# reflect_on_association(:researchers).klass
# .reflect_on_association(:students) # => nil
要修復關聯，我們可以使用方法scope的引數has_many：
has_many(name, scope = nil, **options, &extension)
# ^ pass a proc as a second argument
class Department < ApplicationRecord
# NOTE: add `dependent: :destroy` option to destroy corresponding Relations
# when destroying a Department
has_many :relations, dependent: :destroy
has_many :researchers, through: :relations
has_many :students,
-> { where(type: "Student") }, # scope the associated model
through: :relations, # relevant association is in Relation model
source: :researcher # look for `researcher` association in Relation.
# instead of `student`
# NOTE: use existing scope from another model
has_many :advisors,
-> { advisors }, # this runs in the source class.
through: :relations, # |
source: :researcher # <------------------'
# Researcher has `advisors` class method,
# defined by `scope: :advisors`.
end
現在，我們需要修復 和 之間的Relation關聯Researcher：
# NOTE: what if you need another "relation" class to make another many-to-many association.
# TODO: call this something a bit more descriptive like `DepartmentStaff`
# or use the conventional `DepartmentResearcher`.
class Relation < ApplicationRecord
belongs_to :researcher
belongs_to :department
end
class Researcher < ApplicationRecord
scope :students, -> { where(type: "Student") }
scope :advisors, -> { where(type: "Advisor") }
# NOTE: `has_many :relations` is the opposite of `belongs_to :researcher`
# `foreign_key` is `researcher_id` which is the default and
# should not be changed.
# has_many :relations, foreign_key: :department_id
has_many :relations, dependent: :destroy # <--.
has_many :departments, through: :relations # <--|
end # |
# |
class Student < Researcher # |
# NOTE: no need to duplicate these; put it in the parent class.
# has_many :relations
# has_many :departments, through: :relations
end
class Advisor < Researcher
end
>> Relation.create!([{researcher: Student.new, department: Department.create},{researcher: Advisor.new, department: Department.first}])
>> Department.first.students
=> [#<Student:0x00007f7f78ae5f98 id: 1, type: "Student">]
>> Department.first.advisors
=> [#<Advisor:0x00007f7f789a9b20 id: 2, type: "Advisor">]
>> Department.first.researchers
=> [#<Student:0x00007f7f786bdc90 id: 1, type: "Student">, #<Advisor:0x00007f7f786bd858 id: 2, type: "Advisor">]
您還可以通過在 中定義額外的關聯來讓 Rails 完成作業Relation，不需要范圍：
class Relation < ApplicationRecord
belongs_to :researcher
belongs_to :department
belongs_to :student, foreign_key: :researcher_id, optional: true
belongs_to :advisor, foreign_key: :researcher_id, optional: true
end
class Department < ApplicationRecord
has_many :relations, dependent: :destroy
has_many :researchers, through: :relations
has_many :students, through: :relations
has_many :advisors, through: :relations
end
https://guides.rubyonrails.org/association_basics.html#the-has-many-through-association
https://api.rubyonrails.org/classes/ActiveRecord/Scoping/Named/ClassMethods.html#method-i-scope
https://api.rubyonrails.org/classes/ActiveRecord/Associations/ClassMethods.html#method-i-has_many
https://api.rubyonrails.org/classes/ActiveRecord/Reflection/ClassMethods.html#method-i-reflect_on_association
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/482388.html