Rails 6.0 has_many-belongs_to关联外键识别失败问题

问题详情 #

我有两个模型Loan::Transaction和Loan::Transaction::Transition，目录结构如下：

• models/loan/transaction.rb（对应Loan::Transaction）
• models/loan/transaction/transition.rb（对应Loan::Transaction::Transition）

关联关系：

• 1个Loan::Transaction对应多个Loan::Transaction::Transition
• 1个Loan::Transaction::Transition属于1个Loan::Transaction

Loan::Transaction::Transition表包含loan_transaction_id字段，迁移代码如下：

class CreateLoanTransactionTransitions < ActiveRecord::Migration[6.0]
  def up
    create_table :loan_transaction_transitions, id: :uuid do |t|
      t.timestamps
      t.references :loan_transaction, type: :uuid, null: false, index: true,
                                      foreign_key: { to_table: :loan_transactions }
      t.string :reason
      t.references :made_by, type: :uuid, null: true, foreign_key: { to_table: :users }
    end
    add_column :loan_transaction_transitions, :from_status, :transaction_status, null: false
    add_column :loan_transaction_transitions, :to_status,   :transaction_status, null: false
  end

  def down
    drop_table :loan_transaction_transitions
  end
end

Loan::Transaction::Transition模型代码：

class Loan::Transaction::Transition < ApplicationRecord
  validates :to_status, presence: true
  validates :from_status, presence: true
  validates :loan_transaction_id, presence: true

  belongs_to :made_by, class_name: 'User', foreign_key: 'made_by_id', optional: true
  belongs_to :loan_transaction, class_name: 'Loan::Transaction', foreign_key: 'loan_transaction_id', inverse_of: :transitions
end

Loan::Transaction模型代码：

class Loan::Transaction < ApplicationRecord
  extend ActiveSupport::Concern
  
  has_many :transitions, class_name: 'Transaction::Transition', dependent: :destroy, foreign_key: 'loan_transaction_id', inverse_of: 'loan_transaction'
  accepts_nested_attributes_for :transitions
end

执行Loan::Transaction.first.transitions时触发错误：

ActiveRecord::StatementInvalid (PG::UndefinedColumn: ERROR: column loan_transaction_transitions.transaction_id does not exist)
LINE 1: ... AS one FROM "loan_transaction_transitions" WHERE "loan_tran...

解决方案 #

错误原因 #

Loan::Transaction中的has_many :transitions指定的class_name不完整，写成了Transaction::Transition，而实际模型是Loan::Transaction::Transition。由于命名空间缺失，Rails默认推断外键为transaction_id（对应Transaction模型），而非自定义的loan_transaction_id，导致查询时找不到对应字段。

修正后的代码 #

将Loan::Transaction模型中的has_many关联的class_name修正为完整命名空间：

class Loan::Transaction < ApplicationRecord
  extend ActiveSupport::Concern
  
  has_many :transitions, class_name: 'Loan::Transaction::Transition', dependent: :destroy, foreign_key: 'loan_transaction_id', inverse_of: :loan_transaction
  accepts_nested_attributes_for :transitions
end

额外验证点 #

• 确认inverse_of配置双向对应：Loan::Transaction::Transition中belongs_to的inverse_of: :transitions，和Loan::Transaction中has_many的inverse_of: :loan_transaction匹配
• 两边都明确指定foreign_key: 'loan_transaction_id'，彻底避免Rails自动推断外键时出错

内容的提问来源于stack exchange，提问作者Bruno Aguiar de Souza