如何在Rails中实现Block模型的同类型对象双向父子关联？

你当前创建的children_id列只能实现一对多的自引用关系（一个父Block对应多个子Block，但一个子Block只能有一个父Block），但你需要的是多对多的自引用关联（一个Block可以同时属于多个父Block，也能拥有多个子Block），这种场景需要通过中间关联表来实现，以下是具体步骤：

1. 创建中间关联表的迁移 #

首先生成一个中间表（命名为block_relationships），用于存储父Block和子Block的关联关系，表中需要两个外键字段分别指向blocks表：

class CreateBlockRelationships < ActiveRecord::Migration[7.0]
  def change
    create_table :block_relationships do |t|
      t.references :parent, null: false, foreign_key: { to_table: :blocks }
      t.references :child, null: false, foreign_key: { to_table: :blocks }

      # 添加唯一索引，避免同一个父子对重复创建
      t.index [:parent_id, :child_id], unique: true
    end
  end
end

执行迁移：

rails db:migrate

2. 在Block模型中定义关联关系 #

在app/models/block.rb中添加自引用的多对多关联：

class Block < ApplicationRecord
  # 关联当前Block的所有父Block
  has_many :child_relationships, class_name: "BlockRelationship", foreign_key: "child_id", dependent: :destroy
  has_many :parents, through: :child_relationships, source: :parent

  # 关联当前Block的所有子Block
  has_many :parent_relationships, class_name: "BlockRelationship", foreign_key: "parent_id", dependent: :destroy
  has_many :children, through: :parent_relationships, source: :child
end

• dependent: :destroy确保当某个Block被删除时，对应的关联记录也会被清理，避免无效数据
• source用于指定关联的源模型，因为Rails无法自动推断自引用关联的指向

3. 定义中间关联模型（可选） #

如果需要直接操作中间关联表，可以生成BlockRelationship模型：

rails generate model BlockRelationship parent:references child:references

生成后的模型文件app/models/block_relationship.rb内容如下：

class BlockRelationship < ApplicationRecord
  belongs_to :parent, class_name: "Block"
  belongs_to :child, class_name: "Block"
end

4. 使用示例 #

按照你给出的场景，我们可以这样操作关联：

# 创建所需的Block实例
block1 = Block.create(name: "Block 1")
block2 = Block.create(name: "Block 2")
block3 = Block.create(name: "Block 3")
block4 = Block.create(name: "Block 4")
block5 = Block.create(name: "Block 5")
block6 = Block.create(name: "Block 6")
block7 = Block.create(name: "Block 7")
block10 = Block.create(name: "Block 10")
block11 = Block.create(name: "Block 11")
block12 = Block.create(name: "Block 12")

# 给Block1添加父Block3、Block2
block1.parents << block3
block1.parents << block2

# 给Block1添加子Block4、5、6
block1.children << block4
block1.children << block5
block1.children << block6

# 给Block2添加父Block7
block2.parents << block7

# 给Block2添加子Block10、11、12
block2.children << block10
block2.children << block11
block2.children << block12

# 查询验证
block1.parents       # 返回 [block3, block2]
block1.children      # 返回 [block4, block5, block6]
block2.parents       # 返回 [block7]
block2.children      # 返回 [block10, block11, block12]

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