table = TableRegistry::get('NumberTrees'); $this->table->addBehavior('Tree'); } public function tearDown() { parent::tearDown(); TableRegistry::clear(); } /** * Tests the find('path') method * * @return void */ public function testFindPath() { $nodes = $this->table->find('path', ['for' => 9]); $this->assertEquals([1, 6, 9], $nodes->extract('id')->toArray()); $nodes = $this->table->find('path', ['for' => 10]); $this->assertEquals([1, 6, 10], $nodes->extract('id')->toArray()); $nodes = $this->table->find('path', ['for' => 5]); $this->assertEquals([1, 2, 5], $nodes->extract('id')->toArray()); $nodes = $this->table->find('path', ['for' => 1]); $this->assertEquals([1], $nodes->extract('id')->toArray()); // find path with scope $table = TableRegistry::get('MenuLinkTrees'); $table->addBehavior('Tree', ['scope' => ['menu' => 'main-menu']]); $nodes = $table->find('path', ['for' => 5]); $this->assertEquals([1, 3, 4, 5], $nodes->extract('id')->toArray()); } /** * Tests the childCount() method * * @return void */ public function testChildCount() { // direct children for the root node $countDirect = $this->table->childCount(1, true); $this->assertEquals(2, $countDirect); // counts all the children of root $count = $this->table->childCount(1, false); $this->assertEquals(9, $count); // counts direct children $count = $this->table->childCount(2, false); $this->assertEquals(3, $count); // count children for a middle-node $count = $this->table->childCount(6, false); $this->assertEquals(4, $count); // count leaf children $count = $this->table->childCount(10, false); $this->assertEquals(0, $count); // test scoping $table = TableRegistry::get('MenuLinkTrees'); $table->addBehavior('Tree', ['scope' => ['menu' => 'main-menu']]); $count = $table->childCount(3, false); $this->assertEquals(2, $count); } /** * Tests the childCount() plus callable scoping * * @return void */ public function testCallableScoping() { $table = TableRegistry::get('MenuLinkTrees'); $table->addBehavior('Tree', [ 'scope' => function ($query) { return $query->where(['menu' => 'main-menu']); } ]); $count = $table->childCount(1, false); $this->assertEquals(4, $count); } /** * Tests the find('children') method * * @return void */ public function testFindChildren() { $table = TableRegistry::get('MenuLinkTrees'); $table->addBehavior('Tree', ['scope' => ['menu' => 'main-menu']]); // root $nodeIds = []; $nodes = $table->find('children', ['for' => 1])->all(); $this->assertEquals([2, 3, 4, 5], $nodes->extract('id')->toArray()); // leaf $nodeIds = []; $nodes = $table->find('children', ['for' => 5])->all(); $this->assertEquals(0, count($nodes->extract('id')->toArray())); // direct children $nodes = $table->find('children', ['for' => 1, 'direct' => true])->all(); $this->assertEquals([2, 3], $nodes->extract('id')->toArray()); } /** * Tests that find('children') will throw an exception if the node was not found * * @expectedException \Cake\ORM\Error\RecordNotFoundException * @return void */ public function testFindChildrenException() { $table = TableRegistry::get('MenuLinkTrees'); $table->addBehavior('Tree', ['scope' => ['menu' => 'main-menu']]); $query = $table->find('children', ['for' => 500]); } /** * Tests the moveUp() method * * @return void */ public function testMoveUp() { $table = TableRegistry::get('MenuLinkTrees'); $table->addBehavior('Tree', ['scope' => ['menu' => 'main-menu']]); // top level, wont move $this->assertEquals(false, $this->table->moveUp(1, 10)); // edge cases $this->assertEquals(false, $this->table->moveUp(1, 0)); $this->assertEquals(false, $this->table->moveUp(1, -10)); // move inner node $nodeIds = []; $result = $table->moveUp(3, 1); $nodes = $table->find('children', ['for' => 1])->all(); $this->assertEquals([3, 4, 5, 2], $nodes->extract('id')->toArray()); $this->assertEquals(true, $result); // move leaf $this->assertEquals(false, $table->moveUp(5, 1)); // move to first position $table->moveUp(8, true); $nodes = $table->find() ->select(['id']) ->where(['parent_id' => 0, 'menu' => 'main-menu']) ->order(['lft' => 'ASC']) ->all(); $this->assertEquals([8, 1, 6], $nodes->extract('id')->toArray()); } /** * Tests that moveUp() will throw an exception if the node was not found * * @expectedException \Cake\ORM\Error\RecordNotFoundException * @return void */ public function testMoveUpException() { $table = TableRegistry::get('MenuLinkTrees'); $table->addBehavior('Tree', ['scope' => ['menu' => 'main-menu']]); $table->moveUp(500, 1); } /** * Tests the moveDown() method * * @return void */ public function testMoveDown() { $table = TableRegistry::get('MenuLinkTrees'); $table->addBehavior('Tree', ['scope' => ['menu' => 'main-menu']]); // latest node, wont move $this->assertEquals(false, $this->table->moveDown(8, 10)); // edge cases $this->assertEquals(false, $this->table->moveDown(8, 0)); $this->assertEquals(false, $this->table->moveUp(8, -10)); // move inner node $nodeIds = []; $result = $table->moveDown(2, 1); $nodes = $table->find('children', ['for' => 1])->all(); $this->assertEquals([3, 4, 5, 2], $nodes->extract('id')->toArray()); $this->assertEquals(true, $result); // move leaf $this->assertEquals(false, $table->moveDown(5, 1)); // move to last position $table->moveDown(1, true); $nodes = $table->find() ->select(['id']) ->where(['parent_id' => 0, 'menu' => 'main-menu']) ->order(['lft' => 'ASC']) ->all(); $this->assertEquals([6, 8, 1], $nodes->extract('id')->toArray()); } /** * Tests that moveDown() will throw an exception if the node was not found * * @expectedException \Cake\ORM\Error\RecordNotFoundException * @return void */ public function testMoveDownException() { $table = TableRegistry::get('MenuLinkTrees'); $table->addBehavior('Tree', ['scope' => ['menu' => 'main-menu']]); $table->moveDown(500, 1); } /** * Tests the recover function * * @return void */ public function testRecover() { $table = TableRegistry::get('NumberTrees'); $table->addBehavior('Tree'); $expected = $table->find()->order('lft')->hydrate(false)->toArray(); $table->updateAll(['lft' => null, 'rght' => null], []); $table->recover(); $result = $table->find()->order('lft')->hydrate(false)->toArray(); $this->assertEquals($expected, $result); } /** * Tests the recover function with a custom scope * * @return void */ public function testRecoverScoped() { $table = TableRegistry::get('MenuLinkTrees'); $table->addBehavior('Tree', ['scope' => ['menu' => 'main-menu']]); $expected = $table->find() ->where(['menu' => 'main-menu']) ->order('lft') ->hydrate(false) ->toArray(); $table->updateAll(['lft' => null, 'rght' => null], ['menu' => 'main-menu']); $table->recover(); $result = $table->find() ->where(['menu' => 'main-menu']) ->order('lft') ->hydrate(false) ->toArray(); $this->assertEquals($expected, $result); } }