public function testfindTree()
 {
     list($t1, $t2, $t3, $t4, $t5, $t6, $t7) = $this->initTree();
     $tree = Table9Query::create()->findTree();
     $coll = $this->buildCollection(array($t1, $t2, $t3, $t4, $t5, $t6, $t7));
     $this->assertEquals($coll, $tree, 'findTree() retrieves the whole tree, ordered by branch');
 }
 public function testInsertAsNextSiblingOfExistingObject()
 {
     Table9Query::create()->deleteAll();
     $t = new Table9();
     $t->makeRoot();
     $t->save();
     $t1 = new Table9();
     $t1->insertAsFirstChildOf($t);
     $t1->save();
     $this->assertEquals(1, $t->getLeftValue());
     $this->assertEquals(4, $t->getRightValue());
     $this->assertEquals(0, $t->getLevel());
     $this->assertEquals(2, $t1->getLeftValue());
     $this->assertEquals(3, $t1->getRightValue());
     $this->assertEquals(1, $t1->getLevel());
     $t2 = new Table9();
     $t2->save();
     $t2->insertAsNextSiblingOf($t1);
     $this->assertEquals(4, $t2->getLeftValue());
     $this->assertEquals(5, $t2->getRightValue());
     $this->assertEquals(1, $t2->getLevel());
     $t2->save();
     $this->assertEquals(1, $t->getLeftValue());
     $this->assertEquals(6, $t->getRightValue());
     $this->assertEquals(0, $t->getLevel());
     $this->assertEquals(2, $t1->getLeftValue());
     $this->assertEquals(3, $t1->getRightValue());
     $this->assertEquals(1, $t1->getLevel());
     $this->assertEquals(4, $t2->getLeftValue());
     $this->assertEquals(5, $t2->getRightValue());
     $this->assertEquals(1, $t2->getLevel());
 }