* @link http://www.gediminasm.org * @license MIT License (http://www.opensource.org/licenses/mit-license.php) */ class NestedTreeRootRepositoryTest extends BaseTestCaseORM { const CATEGORY = "Tree\\Fixture\\RootCategory"; protected function setUp() { parent::setUp(); $evm = new EventManager; $evm->addEventSubscriber(new TreeListener); $this->getMockSqliteEntityManager($evm); $this->populate(); } /** * Based on issue #342 * * @test */ function shouldBeAbleToShiftRootNode() { $repo = $this->em->getRepository(self::CATEGORY); $food = $repo->findOneByTitle('Food'); $acme = new RootCategory; $acme->setTitle('Acme'); $food->setParent($acme); $this->em->persist($acme); $this->em->persist($food); $this->em->flush(); $this->assertNull($acme->getParent()); $this->assertSame($acme, $food->getParent()); $this->assertSame($acme->getId(), $acme->getRoot()); $this->assertSame($acme->getId(), $food->getRoot()); $this->assertSame(1, $acme->getLeft()); $this->assertSame(12, $acme->getRight()); $this->assertSame(2, $food->getLeft()); $this->assertSame(11, $food->getRight()); } /** * @test */ function shouldSupportChildrenHierarchyAsArray() { $repo = $this->em->getRepository(self::CATEGORY); $result = $repo->childrenHierarchy(); $this->assertCount(2, $result); $this->assertTrue(isset($result[0]['__children'][0]['__children'])); $vegies = $repo->findOneByTitle('Vegitables'); $result = $repo->childrenHierarchy($vegies); $this->assertCount(2, $result); $this->assertCount(0, $result[0]['__children']); // Complete Tree $roots = $repo->getRootNodes(); $tree = $repo->childrenHierarchy(); $this->assertEquals(2, count($tree)); // Count roots $this->assertEquals('Food', $tree[0]['title']); $this->assertEquals('Sports', $tree[1]['title']); $this->assertEquals('Fruits', $tree[0]['__children'][0]['title']); $this->assertEquals('Vegitables', $tree[0]['__children'][1]['title']); $this->assertEquals('Carrots', $tree[0]['__children'][1]['__children'][0]['title']); $this->assertEquals('Potatoes', $tree[0]['__children'][1]['__children'][1]['title']); // Tree of one specific root, without the root node $roots = $repo->getRootNodes(); $tree = $repo->childrenHierarchy($roots[0]); $this->assertEquals(2, count($tree)); // Count roots $this->assertEquals('Fruits', $tree[0]['title']); $this->assertEquals('Vegitables', $tree[1]['title']); $this->assertEquals('Carrots', $tree[1]['__children'][0]['title']); $this->assertEquals('Potatoes', $tree[1]['__children'][1]['title']); // Tree of one specific root, with the root node $tree = $repo->childrenHierarchy($roots[0], false, array(), true); $this->assertEquals(1, count($tree)); // Count roots $this->assertEquals('Food', $tree[0]['title']); $this->assertEquals('Fruits', $tree[0]['__children'][0]['title']); $this->assertEquals('Vegitables', $tree[0]['__children'][1]['title']); $this->assertEquals('Carrots', $tree[0]['__children'][1]['__children'][0]['title']); $this->assertEquals('Potatoes', $tree[0]['__children'][1]['__children'][1]['title']); // Tree of one specific root only with direct children, without the root node $roots = $repo->getRootNodes(); $tree = $repo->childrenHierarchy($roots[0], true); $this->assertEquals(2, count($tree)); $this->assertEquals('Fruits', $tree[0]['title']); $this->assertEquals('Vegitables', $tree[1]['title']); // Tree of one specific root only with direct children, with the root node $tree = $repo->childrenHierarchy($roots[0], true, array(), true); $this->assertEquals(1, count($tree)); $this->assertEquals('Food', $tree[0]['title']); $this->assertEquals('Fruits', $tree[0]['__children'][0]['title']); $this->assertEquals('Vegitables', $tree[0]['__children'][1]['title']); } /** * @test */ function shouldSupportChildrenHierarchyAsHtml() { $repo = $this->em->getRepository(self::CATEGORY); $food = $repo->findOneByTitle('Food'); $decorate = true; $defaultHtmlTree = $repo->childrenHierarchy($food, false, compact('decorate')); $this->assertEquals( '', $defaultHtmlTree ); // custom title $nodeDecorator = function($node) { return ''.$node['title'].''; }; $decoratedHtmlTree = $repo->childrenHierarchy( $food, false, compact('decorate', 'nodeDecorator') ); $this->assertEquals( '', $decoratedHtmlTree ); // cli friendly output $rootOpen = ''; $rootClose = ''; $childOpen = ''; $childClose = ''; $nodeDecorator = function($node) { return str_repeat('-', $node['level']).$node['title']."\n"; }; $decoratedCliTree = $repo->childrenHierarchy( $food, false, compact('decorate', 'nodeDecorator', 'rootOpen', 'rootClose', 'childOpen', 'childClose') ); $this->assertEquals( "-Fruits\n-Vegitables\n--Carrots\n--Potatoes\n", $decoratedCliTree ); $rootOpen = function () {return '';}; $childOpen = function (&$node) { return '
  • '; }; // check support of the closures in childClose $childClose = function(&$node) { return '
  • '; }; $decoratedHtmlTree = $repo->childrenHierarchy( $food, false, compact('decorate', 'rootOpen', 'rootClose','childOpen','childClose') ); $this->assertEquals( '', $decoratedHtmlTree ); } /** * @test */ function shouldSupportChildrenHierarchyByBuildTreeFunction() { $repo = $this->em->getRepository(self::CATEGORY); $q = $this->em ->createQueryBuilder() ->select('node') ->from(self::CATEGORY, 'node') ->orderBy('node.root, node.lft', 'ASC') ->where('node.root = 1') ->getQuery() ; $tree = $repo->buildTree($q->getArrayResult()); $this->assertCount(1, $tree); $this->assertCount(2, $tree[0]['__children']); $nodes = array(); $options = array('decorate' => true); $this->assertEquals('', $repo->buildTree($nodes, $options), 'should give empty string when there are no nodes given'); } /** * @test */ public function shouldRemoveRootNodeFromTree() { $repo = $this->em->getRepository(self::CATEGORY); $this->populateMore(); $food = $repo->findOneByTitle('Food'); $repo->removeFromTree($food); $this->em->clear(); $food = $repo->findOneByTitle('Food'); $this->assertNull($food); $node = $repo->findOneByTitle('Fruits'); $this->assertEquals(1, $node->getLeft()); $this->assertEquals(2, $node->getRight()); $this->assertEquals(3, $node->getRoot()); $this->assertNull($node->getParent()); $node = $repo->findOneByTitle('Vegitables'); $this->assertEquals(1, $node->getLeft()); $this->assertEquals(10, $node->getRight()); $this->assertEquals(4, $node->getRoot()); $this->assertNull($node->getParent()); } /** * @test */ public function shouldHandleBasicRepositoryMethods() { $repo = $this->em->getRepository(self::CATEGORY); $carrots = $repo->findOneByTitle('Carrots'); $path = $repo->getPath($carrots); $this->assertCount(3, $path); $this->assertEquals('Food', $path[0]->getTitle()); $this->assertEquals('Vegitables', $path[1]->getTitle()); $this->assertEquals('Carrots', $path[2]->getTitle()); $vegies = $repo->findOneByTitle('Vegitables'); $childCount = $repo->childCount($vegies); $this->assertEquals(2, $childCount); $food = $repo->findOneByTitle('Food'); $childCount = $repo->childCount($food, true); $this->assertEquals(2, $childCount); $childCount = $repo->childCount($food); $this->assertEquals(4, $childCount); $childCount = $repo->childCount(); $this->assertEquals(6, $childCount); $childCount = $repo->childCount(null, true); $this->assertEquals(2, $childCount); } /** * @test */ public function shouldHandleAdvancedRepositoryFunctions() { $this->populateMore(); $repo = $this->em->getRepository(self::CATEGORY); // verification $this->assertTrue($repo->verify()); $dql = 'UPDATE ' . self::CATEGORY . ' node'; $dql .= ' SET node.lft = 5'; $dql .= ' WHERE node.id = 4'; $this->em->createQuery($dql)->getSingleScalarResult(); $this->em->clear(); // must clear cached entities $errors = $repo->verify(); $this->assertCount(2, $errors); $this->assertEquals('index [4], missing on tree root: 1', $errors[0]); $this->assertEquals('index [5], duplicate on tree root: 1', $errors[1]); // test recover functionality $repo->recover(); $this->em->flush(); $this->assertTrue($repo->verify()); $this->em->clear(); $onions = $repo->findOneByTitle('Onions'); $this->assertEquals(11, $onions->getLeft()); $this->assertEquals(12, $onions->getRight()); // move up $repo->moveUp($onions); $this->assertEquals(9, $onions->getLeft()); $this->assertEquals(10, $onions->getRight()); $repo->moveUp($onions, true); $this->assertEquals(5, $onions->getLeft()); $this->assertEquals(6, $onions->getRight()); // move down $repo->moveDown($onions, 2); $this->assertEquals(9, $onions->getLeft()); $this->assertEquals(10, $onions->getRight()); // reorder $node = $repo->findOneByTitle('Food'); $repo->reorder($node, 'title', 'ASC', false); $node = $repo->findOneByTitle('Cabbages'); $this->assertEquals(5, $node->getLeft()); $this->assertEquals(6, $node->getRight()); $node = $repo->findOneByTitle('Carrots'); $this->assertEquals(7, $node->getLeft()); $this->assertEquals(8, $node->getRight()); $node = $repo->findOneByTitle('Onions'); $this->assertEquals(9, $node->getLeft()); $this->assertEquals(10, $node->getRight()); $node = $repo->findOneByTitle('Potatoes'); $this->assertEquals(11, $node->getLeft()); $this->assertEquals(12, $node->getRight()); // leafs $leafs = $repo->getLeafs($node); $this->assertCount(5, $leafs); $this->assertEquals('Fruits', $leafs[0]->getTitle()); $this->assertEquals('Cabbages', $leafs[1]->getTitle()); $this->assertEquals('Carrots', $leafs[2]->getTitle()); $this->assertEquals('Onions', $leafs[3]->getTitle()); $this->assertEquals('Potatoes', $leafs[4]->getTitle()); // remove $node = $repo->findOneByTitle('Fruits'); $id = $node->getId(); $repo->removeFromTree($node); $this->assertNull($repo->find($id)); $node = $repo->findOneByTitle('Vegitables'); $id = $node->getId(); $repo->removeFromTree($node); $this->assertNull($repo->find($id)); $this->em->clear(); $node = $repo->findOneByTitle('Cabbages'); $this->assertEquals(1, $node->getRoot()); $this->assertEquals(1, $node->getParent()->getId()); } /** * @test */ public function shouldRemoveTreeLeafFromTree() { $this->populateMore(); $repo = $this->em->getRepository(self::CATEGORY); $onions = $repo->findOneByTitle('Onions'); $id = $onions->getId(); $repo->removeFromTree($onions); $this->assertNull($repo->find($id)); $this->em->clear(); $vegies = $repo->findOneByTitle('Vegitables'); $this->assertTrue($repo->verify()); } /** * @test */ public function getRootNodesTest() { $repo = $this->em->getRepository(self::CATEGORY); // Test getRootNodes without custom ordering $roots = $repo->getRootNodes(); $this->assertEquals(2, count($roots)); $this->assertEquals('Food', $roots[0]->getTitle()); $this->assertEquals('Sports', $roots[1]->getTitle()); // Test getRootNodes with custom ordering $roots = $repo->getRootNodes('title', 'desc'); $this->assertEquals(2, count($roots)); $this->assertEquals('Sports', $roots[0]->getTitle()); $this->assertEquals('Food', $roots[1]->getTitle()); } /** * @test */ public function changeChildrenIndexTest() { $repo = $this->em->getRepository(self::CATEGORY); $childrenIndex = 'myChildren'; $repo->setChildrenIndex($childrenIndex); $tree = $repo->childrenHierarchy(); $this->assertInternalType('array', $tree[0][$childrenIndex]); } protected function getUsedEntityFixtures() { return array( self::CATEGORY ); } private function populateMore() { $vegies = $this->em->getRepository(self::CATEGORY) ->findOneByTitle('Vegitables'); $cabbages = new RootCategory(); $cabbages->setParent($vegies); $cabbages->setTitle('Cabbages'); $onions = new RootCategory(); $onions->setParent($vegies); $onions->setTitle('Onions'); $this->em->persist($cabbages); $this->em->persist($onions); $this->em->flush(); } private function populate() { $root = new RootCategory(); $root->setTitle("Food"); $root2 = new RootCategory(); $root2->setTitle("Sports"); $child = new RootCategory(); $child->setTitle("Fruits"); $child->setParent($root); $child2 = new RootCategory(); $child2->setTitle("Vegitables"); $child2->setParent($root); $childsChild = new RootCategory(); $childsChild->setTitle("Carrots"); $childsChild->setParent($child2); $potatoes = new RootCategory(); $potatoes->setTitle("Potatoes"); $potatoes->setParent($child2); $this->em->persist($root); $this->em->persist($root2); $this->em->persist($child); $this->em->persist($child2); $this->em->persist($childsChild); $this->em->persist($potatoes); $this->em->flush(); } }