previousnext/nested-set

A PHP Doctrine DBAL implementation for Nested Sets.

Nested Set

A PHP Doctrine DBAL implementation for Nested Sets., _(*1)

, _(*2)

Using

Create table schema

Create the table schema, passing in a a DBAL connection and table name (defaults to 'tree')., _(*3)

$schema = new DbalNestedSetSchema($connection, 'my_tree');
schema->create();

Set up the nested set client

Create a new DbalNestedSet passing in the DBAL connection and the table name., _(*4)

$nestedSet = new DbalNestedSet($connection, 'my_tree');

Add a root node

A NodeKey represents a unique ID for a node in the tree. It supports the idea of a node ID and a revision ID, mostly for compatibility with Drupal., _(*5)

$nodeKey = new NodeKey($id, $revisionId);
$rootNode = $nestedSet->addRootNode($nodeKey);

Add a child node

To add a child node, you provide the parent node, and a child node key., _(*6)

$nodeKey = new NodeKey($id, $revisionId);
$nestedSet->addNodeBelow($rootNode, $nodeKey);

Find Descendants

To find descendents, you provide the parent node key., _(*7)

$nodeKey = new NodeKey($id, $revisionId);
$descendants = $this->nestedSet->findDescendants($nodeKey);

Find ancestors

To find ancestors, you provide the child node key., _(*8)

$nodeKey = new NodeKey($id, $revisionId);
$ancestors = $this->nestedSet->findAncestors($nodeKey);

See \PNX\NestedSet\NestedSetInterface for many more methods that can be used for interacting with the nested set., _(*9)

Developing

Dependencies

To install all dependencies, run:, _(*10)

make init

Linting

Uses the Drupal coding standard., _(*11)

To validate code sniffs run:, _(*12)

make lint-php

To automatically fix code sniff issues, run:, _(*13)

make fix-php

Testing

To run all phpunit tests, run:, _(*14)

make test