Doctrine 2 nested set - retrieve full tree in single query

Question

I'm using stof/StofDoctrineExtensionsBundle (Bundle wrapper for Atlantic18/DoctrineExtensions) to implement a Nested Set (tree) entity. The entity is configured and working, but I can't figure out how to retrieve all root notes with all of their children (full trees) in a single query. I currently have the full collection returning however it lazy loads all children, meaning a large number of queries is performed.

Thanks for any help.

score 4 · Answer 1 · answered Oct 02 '17 at 10:25

4

You can just use childrenHierarchy() method for whole tree retrieve:

$tree = $repo->childrenHierarchy();

answered Oct 02 '17 at 10:25

vp_arth

14,461
4
37
66

score 3 · Accepted Answer · answered Aug 03 '16 at 07:55

Found a solution.

retrieve full list of node objects:

$repo = $this->getDoctrine()->getManager()->getRepository('NestedEntity');
$nodes = $repo->getChildren();

build tree with your nodes.

$tree = $repo->getRepoUtils()->buildTreeArray($nodes);

buildTreeArray method accepts array of node-arrays, so you must implement ArrayAccess interface in your Entity. Also it puts all children in __children key of node-array.

/**
 * @Gedmo\Tree(type="nested")
 * @ORM\Table(name="nested_entity")
 * @ORM\Entity(repositoryClass="Gedmo\Tree\Entity\Repository\NestedTreeRepository")
 */
 class NestedEntity implements \ArrayAccess
 {

     public function offsetExists($offset)
     {
         return property_exists($this, $offset);
     }

     public function &offsetGet($offset)
     {
         return $this->$offset;
     }

     public function offsetSet($offset, $value)
     {
         $this->$offset = $value;
     }

     public function offsetUnset($offset)
     {
         $this->$offset = null;
     }

     protected $__children = [];

     ...

Doctrine 2 nested set - retrieve full tree in single query

2 Answers2