* @link http://www.gediminasm.org * @license MIT License (http://www.opensource.org/licenses/mit-license.php) */ class NestedTreeRootTest extends BaseTestCaseORM { const CATEGORY = "Tree\\Fixture\\RootCategory"; protected function setUp() { parent::setUp(); $evm = new EventManager; $evm->addEventSubscriber(new TreeListener); $this->getMockSqliteEntityManager($evm); $this->populate(); } /** * @test */ function shouldRemoveAndSynchronize() { $repo = $this->em->getRepository(self::CATEGORY); $vegies = $repo->findOneByTitle('Vegitables'); $this->em->remove($vegies); $this->em->flush(); $food = $repo->findOneByTitle('Food'); $this->assertEquals(1, $food->getLeft()); $this->assertEquals(4, $food->getRight()); $vegies = new RootCategory; $vegies->setTitle('Vegies'); $repo->persistAsFirstChildOf($vegies, $food); $this->em->flush(); $this->assertEquals(1, $food->getLeft()); $this->assertEquals(6, $food->getRight()); $this->assertEquals(2, $vegies->getLeft()); $this->assertEquals(3, $vegies->getRight()); } /*public function testHeavyLoad() { $start = microtime(true); $dumpTime = function($start, $msg) { $took = microtime(true) - $start; $minutes = intval($took / 60); $seconds = $took % 60; echo sprintf("%s --> %02d:%02d", $msg, $minutes, $seconds) . PHP_EOL; }; $repo = $this->em->getRepository(self::CATEGORY); $parent = null; $num = 800; for($i = 0; $i < 500; $i++) { $cat = new RootCategory; $cat->setParent($parent); $cat->setTitle('cat'.$i); $this->em->persist($cat); // siblings $rnd = rand(0, 3); for ($j = 0; $j < $rnd; $j++) { $siblingCat = new RootCategory; $siblingCat->setTitle('cat'.$i.$j); $siblingCat->setParent($cat); $this->em->persist($siblingCat); } $num += $rnd; $parent = $cat; } $this->em->flush(); $dumpTime($start, $num.' - inserts took:'); $start = microtime(true); // test moving $target = $repo->findOneByTitle('cat300'); $dest = $repo->findOneByTitle('cat2000'); $target->setParent($dest); $target2 = $repo->findOneByTitle('cat450'); $dest2 = $repo->findOneByTitle('cat2500'); $target2->setParent($dest2); $this->em->flush(); $dumpTime($start, 'moving took:'); }*/ public function testTheTree() { $repo = $this->em->getRepository(self::CATEGORY); $node = $repo->findOneByTitle('Food'); $this->assertEquals(1, $node->getRoot()); $this->assertEquals(1, $node->getLeft()); $this->assertEquals(0, $node->getLevel()); $this->assertEquals(10, $node->getRight()); $node = $repo->findOneByTitle('Sports'); $this->assertEquals(2, $node->getRoot()); $this->assertEquals(1, $node->getLeft()); $this->assertEquals(0, $node->getLevel()); $this->assertEquals(2, $node->getRight()); $node = $repo->findOneByTitle('Fruits'); $this->assertEquals(1, $node->getRoot()); $this->assertEquals(2, $node->getLeft()); $this->assertEquals(1, $node->getLevel()); $this->assertEquals(3, $node->getRight()); $node = $repo->findOneByTitle('Vegitables'); $this->assertEquals(1, $node->getRoot()); $this->assertEquals(4, $node->getLeft()); $this->assertEquals(1, $node->getLevel()); $this->assertEquals(9, $node->getRight()); $node = $repo->findOneByTitle('Carrots'); $this->assertEquals(1, $node->getRoot()); $this->assertEquals(5, $node->getLeft()); $this->assertEquals(2, $node->getLevel()); $this->assertEquals(6, $node->getRight()); $node = $repo->findOneByTitle('Potatoes'); $this->assertEquals(1, $node->getRoot()); $this->assertEquals(7, $node->getLeft()); $this->assertEquals(2, $node->getLevel()); $this->assertEquals(8, $node->getRight()); } public function testSetParentToNull() { $repo = $this->em->getRepository(self::CATEGORY); $node = $repo->findOneByTitle('Vegitables'); $node->setParent(null); $this->em->persist($node); $this->em->flush(); $this->em->clear(); $node = $repo->findOneByTitle('Vegitables'); $this->assertEquals(4, $node->getRoot()); $this->assertEquals(1, $node->getLeft()); $this->assertEquals(6, $node->getRight()); $this->assertEquals(0, $node->getLevel()); } public function testTreeUpdateShiftToNextBranch() { $repo = $this->em->getRepository(self::CATEGORY); $sport = $repo->findOneByTitle('Sports'); $food = $repo->findOneByTitle('Food'); $sport->setParent($food); $this->em->persist($sport); $this->em->flush(); $this->em->clear(); $node = $repo->findOneByTitle('Food'); $this->assertEquals(1, $node->getLeft()); $this->assertEquals(12, $node->getRight()); $node = $repo->findOneByTitle('Sports'); $this->assertEquals(1, $node->getRoot()); $this->assertEquals(2, $node->getLeft()); $this->assertEquals(1, $node->getLevel()); $this->assertEquals(3, $node->getRight()); $node = $repo->findOneByTitle('Vegitables'); $this->assertEquals(6, $node->getLeft()); $this->assertEquals(11, $node->getRight()); } public function testTreeUpdateShiftToRoot() { $repo = $this->em->getRepository(self::CATEGORY); $vegies = $repo->findOneByTitle('Vegitables'); $vegies->setParent(null); $this->em->persist($vegies); $this->em->flush(); $this->em->clear(); $node = $repo->findOneByTitle('Food'); $this->assertEquals(1, $node->getLeft()); $this->assertEquals(4, $node->getRight()); $node = $repo->findOneByTitle('Vegitables'); $this->assertEquals(4, $node->getRoot()); $this->assertEquals(1, $node->getLeft()); $this->assertEquals(0, $node->getLevel()); $this->assertEquals(6, $node->getRight()); $node = $repo->findOneByTitle('Potatoes'); $this->assertEquals(4, $node->getRoot()); $this->assertEquals(4, $node->getLeft()); $this->assertEquals(1, $node->getLevel()); $this->assertEquals(5, $node->getRight()); } public function testTreeUpdateShiftToOtherParent() { $repo = $this->em->getRepository(self::CATEGORY); $carrots = $repo->findOneByTitle('Carrots'); $food = $repo->findOneByTitle('Food'); $carrots->setParent($food); $this->em->persist($carrots); $this->em->flush(); $this->em->clear(); $node = $repo->findOneByTitle('Food'); $this->assertEquals(1, $node->getLeft()); $this->assertEquals(10, $node->getRight()); $node = $repo->findOneByTitle('Carrots'); $this->assertEquals(1, $node->getRoot()); $this->assertEquals(2, $node->getLeft()); $this->assertEquals(1, $node->getLevel()); $this->assertEquals(3, $node->getRight()); $node = $repo->findOneByTitle('Potatoes'); $this->assertEquals(1, $node->getRoot()); $this->assertEquals(7, $node->getLeft()); $this->assertEquals(2, $node->getLevel()); $this->assertEquals(8, $node->getRight()); } /** * @expectedException UnexpectedValueException */ public function testTreeUpdateShiftToChildParent() { $repo = $this->em->getRepository(self::CATEGORY); $vegies = $repo->findOneByTitle('Vegitables'); $food = $repo->findOneByTitle('Food'); $food->setParent($vegies); $this->em->persist($food); $this->em->flush(); $this->em->clear(); } public function testTwoUpdateOperations() { $repo = $this->em->getRepository(self::CATEGORY); $sport = $repo->findOneByTitle('Sports'); $food = $repo->findOneByTitle('Food'); $sport->setParent($food); $vegies = $repo->findOneByTitle('Vegitables'); $vegies->setParent(null); $this->em->persist($vegies); $this->em->persist($sport); $this->em->flush(); $this->em->clear(); $node = $repo->findOneByTitle('Carrots'); $this->assertEquals(4, $node->getRoot()); $this->assertEquals(2, $node->getLeft()); $this->assertEquals(1, $node->getLevel()); $this->assertEquals(3, $node->getRight()); $node = $repo->findOneByTitle('Vegitables'); $this->assertEquals(4, $node->getRoot()); $this->assertEquals(1, $node->getLeft()); $this->assertEquals(0, $node->getLevel()); $this->assertEquals(6, $node->getRight()); $node = $repo->findOneByTitle('Sports'); $this->assertEquals(1, $node->getRoot()); $this->assertEquals(2, $node->getLeft()); $this->assertEquals(1, $node->getLevel()); $this->assertEquals(3, $node->getRight()); } public function testRemoval() { $repo = $this->em->getRepository(self::CATEGORY); $vegies = $repo->findOneByTitle('Vegitables'); $this->em->remove($vegies); $this->em->flush(); $this->em->clear(); $node = $repo->findOneByTitle('Food'); $this->assertEquals(1, $node->getLeft()); $this->assertEquals(4, $node->getRight()); } protected function getUsedEntityFixtures() { return array( self::CATEGORY ); } 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(); $this->em->clear(); } }