理论2:树- Nestedset和InnoDB

Question

我正在使用主义的2棵树-Nestedset扩展和MySQL InndoDB数据库。

yml表模式如下所示：

Ext\Entity\PageElement:
  type: entity
  table: page_element
  repositoryClass: Gedmo\Tree\Entity\Repository\NestedTreeRepository
  gedmo:
    tree:
      type: nested
  id:
    id:
      type: integer
      generator:
        strategy: AUTO
  fields:
    element_object_data:
      type: array
      nullabe: true
    element_object_type:
      type: string
      nullable: true
    lft:
      type: integer
      gedmo:
        - treeLeft
    rgt:
      type: integer
      gedmo:
        - treeRight
    root:
      type: integer
      gedmo:
        - treeRoot
    lvl:
      type: integer
      gedmo:
        - treeLevel
    sort_order:
      type: integer
      nullable: true
    created:
      type: datetime
      gedmo:
        timestampable:
          on: create
    updated:
      type: datetime
      gedmo:
        timestampable:
          on: update
  manyToOne:
    parent:
      targetEntity: Ext\Entity\PageElement
      inversedBy: children
      gedmo:
        - treeParent
  oneToMany:
    children:
      targetEntity: Ext\Entity\PageElement
      mappedBy: parent

尝试删除包含子节点的任何节点，我得到mysql错误：

PDOException: SQLSTATE23000:完整性约束违反: 1451不能删除或更新父行:外键约束失败(page_element、约束page_element_ibfk_1外键(parent_id)引用page_element (id))

我理解这是因为InnoDB引用的限制，但我不知道如何避免它？

Answer 1

答案在github 问题跟踪器上