Rails 6中has_many through关联异常：account.categories返回空集合

我有三个模型（Account、UserCategory、Category），分属不同模块/文件夹。通过中间表UserCategory定义了has_many through关联，实现一个用户对应多个分类，但关联未按预期工作：调用category.accounts（原描述笔误为category.account）可正常获取数据，但account.categories返回空集合。

模型代码如下：

Account 模型 #

module AccountBlock
  class Account < AccountBlock::ApplicationRecord
    ActiveSupport.run_load_hooks(:account, self)
    self.table_name = :accounts

    include Wisper::Publisher

    has_many :user_categories, class_name: "BxBlockCategories::UserCategory", dependent: :destroy
    has_many :categories, class_name: "BxBlockCategories::Category", through: "user_categories", dependent: :delete_all
  end
end

UserCategory 模型 #

module BxBlockCategories
  class UserCategory < ApplicationRecord
    self.table_name = :user_categories

    belongs_to :account, class_name: "AccountBlock::Account", foreign_key: :account_id
    belongs_to :category, class_name: "BxBlockCategories::Category", foreign_key: :category_id
  end
end

Category 模型 #

module BxBlockCategories
  class Category < BxBlockCategories::ApplicationRecord
    self.table_name = :categories

    has_and_belongs_to_many :sub_categories,
                            join_table: :categories_sub_categories, dependent: :destroy

    has_many :contents, class_name: "BxBlockContentmanagement::Content", dependent: :destroy
    has_many :ctas, class_name: "BxBlockCategories::Cta", dependent: :nullify

    has_many :user_categories, class_name: "BxBlockCategories::UserCategory", dependent: :destroy
    has_many :accounts, class_name: "AccountBlock::Account", through: :user_categories
  end
end

问题原因与修复方案

1. through 参数使用字符串而非符号
   Account模型中has_many :categories的through参数用了字符串"user_categories"，虽然Rails在部分场景下支持字符串，但使用符号:user_categories更规范，能避免潜在的解析歧义。

2. through 关联错误设置 dependent: :delete_all
   对于has_many through关联，不能直接在关联上设置dependent选项——级联操作应作用于中间表的关联（即has_many :user_categories已设置dependent: :destroy，会自动删除关联的UserCategory记录）。在categories关联上设置dependent: :delete_all无效，且可能干扰关联的正常加载。

修复后的 Account 模型代码 #

module AccountBlock
  class Account < AccountBlock::ApplicationRecord
    ActiveSupport.run_load_hooks(:account, self)
    self.table_name = :accounts

    include Wisper::Publisher

    has_many :user_categories, class_name: "BxBlockCategories::UserCategory", dependent: :destroy
    has_many :categories, class_name: "BxBlockCategories::Category", through: :user_categories
  end
end

额外排查步骤 #

如果修复后仍有问题，可执行以下操作确认：

• 检查user_categories表中的account_id字段是否正确关联到accounts表的主键，且存在有效数据记录；
• 在控制台执行Account.first.user_categories，确认中间表关联是否能正常加载；
• 执行Account.first.categories.to_sql，查看生成的SQL语句是否正确关联了三张表，排查是否存在字段或表名的拼写错误。

内容的提问来源于stack exchange，提问作者Devendra Yadav