| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547 |
- <?php
- /**
- * TreeBehaviorNumberTest file
- *
- * This is the basic Tree behavior test
- *
- * PHP 5
- *
- * CakePHP(tm) Tests <http://book.cakephp.org/2.0/en/development/testing.html>
- * Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
- *
- * Licensed under The MIT License
- * For full copyright and license information, please see the LICENSE.txt
- * Redistributions of files must retain the above copyright notice
- *
- * @copyright Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
- * @link http://book.cakephp.org/2.0/en/development/testing.html CakePHP(tm) Tests
- * @package Cake.Test.Case.Model.Behavior
- * @since CakePHP(tm) v 1.2.0.5330
- * @license http://www.opensource.org/licenses/mit-license.php MIT License
- */
- App::uses('Model', 'Model');
- App::uses('AppModel', 'Model');
- require_once dirname(dirname(__FILE__)) . DS . 'models.php';
- /**
- * TreeBehaviorNumberTest class
- *
- * @package Cake.Test.Case.Model.Behavior
- */
- class TreeBehaviorNumberTest extends CakeTestCase {
- /**
- * Whether backup global state for each test method or not
- *
- * @var bool false
- */
- public $backupGlobals = false;
- /**
- * settings property
- *
- * @var array
- */
- public $settings = array(
- 'modelClass' => 'NumberTree',
- 'leftField' => 'lft',
- 'rightField' => 'rght',
- 'parentField' => 'parent_id'
- );
- /**
- * fixtures property
- *
- * @var array
- */
- public $fixtures = array('core.number_tree', 'core.person');
- /**
- * testInitialize method
- *
- * @return void
- */
- public function testInitialize() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $result = $this->Tree->find('count');
- $this->assertEquals(7, $result);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testDetectInvalidLeft method
- *
- * @return void
- */
- public function testDetectInvalidLeft() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $result = $this->Tree->findByName('1.1');
- $save[$modelClass]['id'] = $result[$modelClass]['id'];
- $save[$modelClass][$leftField] = 0;
- $this->Tree->save($save);
- $result = $this->Tree->verify();
- $this->assertNotSame($result, true);
- $result = $this->Tree->recover();
- $this->assertSame($result, true);
- $result = $this->Tree->verify();
- $this->assertSame($result, true);
- }
- /**
- * testDetectInvalidRight method
- *
- * @return void
- */
- public function testDetectInvalidRight() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $result = $this->Tree->findByName('1.1');
- $save[$modelClass]['id'] = $result[$modelClass]['id'];
- $save[$modelClass][$rightField] = 0;
- $this->Tree->save($save);
- $result = $this->Tree->verify();
- $this->assertNotSame($result, true);
- $result = $this->Tree->recover();
- $this->assertSame($result, true);
- $result = $this->Tree->verify();
- $this->assertSame($result, true);
- }
- /**
- * testDetectInvalidParent method
- *
- * @return void
- */
- public function testDetectInvalidParent() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $result = $this->Tree->findByName('1.1');
- // Bypass behavior and any other logic
- $this->Tree->updateAll(array($parentField => null), array('id' => $result[$modelClass]['id']));
- $result = $this->Tree->verify();
- $this->assertNotSame($result, true);
- $result = $this->Tree->recover();
- $this->assertSame($result, true);
- $result = $this->Tree->verify();
- $this->assertSame($result, true);
- }
- /**
- * testDetectNoneExistentParent method
- *
- * @return void
- */
- public function testDetectNoneExistentParent() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $result = $this->Tree->findByName('1.1');
- $this->Tree->updateAll(array($parentField => 999999), array('id' => $result[$modelClass]['id']));
- $result = $this->Tree->verify();
- $this->assertNotSame($result, true);
- $result = $this->Tree->recover('MPTT');
- $this->assertSame($result, true);
- $result = $this->Tree->verify();
- $this->assertSame($result, true);
- }
- /**
- * testRecoverUsingParentMode method
- *
- * @return void
- */
- public function testRecoverUsingParentMode() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->Behaviors->disable('Tree');
- $this->Tree->save(array('name' => 'Main', $parentField => null, $leftField => 0, $rightField => 0));
- $node1 = $this->Tree->id;
- $this->Tree->create();
- $this->Tree->save(array('name' => 'About Us', $parentField => $node1, $leftField => 0, $rightField => 0));
- $node11 = $this->Tree->id;
- $this->Tree->create();
- $this->Tree->save(array('name' => 'Programs', $parentField => $node1, $leftField => 0, $rightField => 0));
- $node12 = $this->Tree->id;
- $this->Tree->create();
- $this->Tree->save(array('name' => 'Mission and History', $parentField => $node11, $leftField => 0, $rightField => 0));
- $this->Tree->create();
- $this->Tree->save(array('name' => 'Overview', $parentField => $node12, $leftField => 0, $rightField => 0));
- $this->Tree->Behaviors->enable('Tree');
- $result = $this->Tree->verify();
- $this->assertNotSame($result, true);
- $result = $this->Tree->recover();
- $this->assertTrue($result);
- $result = $this->Tree->verify();
- $this->assertTrue($result);
- $result = $this->Tree->find('first', array(
- 'fields' => array('name', $parentField, $leftField, $rightField),
- 'conditions' => array('name' => 'Main'),
- 'recursive' => -1
- ));
- $expected = array(
- $modelClass => array(
- 'name' => 'Main',
- $parentField => null,
- $leftField => 1,
- $rightField => 10
- )
- );
- $this->assertEquals($expected, $result);
- }
- /**
- * testRecoverUsingParentModeAndDelete method
- *
- * @return void
- */
- public function testRecoverUsingParentModeAndDelete() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->Behaviors->disable('Tree');
- $this->Tree->save(array('name' => 'Main', $parentField => null, $leftField => 0, $rightField => 0));
- $node1 = $this->Tree->id;
- $this->Tree->create();
- $this->Tree->save(array('name' => 'About Us', $parentField => $node1, $leftField => 0, $rightField => 0));
- $node11 = $this->Tree->id;
- $this->Tree->create();
- $this->Tree->save(array('name' => 'Programs', $parentField => $node1, $leftField => 0, $rightField => 0));
- $node12 = $this->Tree->id;
- $this->Tree->create();
- $this->Tree->save(array('name' => 'Mission and History', $parentField => $node11, $leftField => 0, $rightField => 0));
- $this->Tree->create();
- $this->Tree->save(array('name' => 'Overview', $parentField => $node12, $leftField => 0, $rightField => 0));
- $this->Tree->create();
- $this->Tree->save(array('name' => 'Lost', $parentField => 9, $leftField => 0, $rightField => 0));
- $this->Tree->Behaviors->enable('Tree');
- $this->Tree->bindModel(array('belongsTo' => array('Parent' => array(
- 'className' => $this->Tree->name,
- 'foreignKey' => $parentField
- ))));
- $this->Tree->bindModel(array('hasMany' => array('Child' => array(
- 'className' => $this->Tree->name,
- 'foreignKey' => $parentField
- ))));
- $result = $this->Tree->verify();
- $this->assertNotSame($result, true);
- $count = $this->Tree->find('count');
- $this->assertEquals(6, $count);
- $result = $this->Tree->recover('parent', 'delete');
- $this->assertTrue($result);
- $result = $this->Tree->verify();
- $this->assertTrue($result);
- $count = $this->Tree->find('count');
- $this->assertEquals(5, $count);
- $result = $this->Tree->find('first', array(
- 'fields' => array('name', $parentField, $leftField, $rightField),
- 'conditions' => array('name' => 'Main'),
- 'recursive' => -1
- ));
- $expected = array(
- $modelClass => array(
- 'name' => 'Main',
- $parentField => null,
- $leftField => 1,
- $rightField => 10
- )
- );
- $this->assertEquals($expected, $result);
- }
- /**
- * testRecoverFromMissingParent method
- *
- * @return void
- */
- public function testRecoverFromMissingParent() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $result = $this->Tree->findByName('1.1');
- $this->Tree->updateAll(array($parentField => 999999), array('id' => $result[$modelClass]['id']));
- $result = $this->Tree->verify();
- $this->assertNotSame($result, true);
- $result = $this->Tree->recover();
- $this->assertSame($result, true);
- $result = $this->Tree->verify();
- $this->assertSame($result, true);
- }
- /**
- * testDetectInvalidParents method
- *
- * @return void
- */
- public function testDetectInvalidParents() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $this->Tree->updateAll(array($parentField => null));
- $result = $this->Tree->verify();
- $this->assertNotSame($result, true);
- $result = $this->Tree->recover();
- $this->assertSame($result, true);
- $result = $this->Tree->verify();
- $this->assertSame($result, true);
- }
- /**
- * testDetectInvalidLftsRghts method
- *
- * @return void
- */
- public function testDetectInvalidLftsRghts() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $this->Tree->updateAll(array($leftField => 0, $rightField => 0));
- $result = $this->Tree->verify();
- $this->assertNotSame($result, true);
- $this->Tree->recover();
- $result = $this->Tree->verify();
- $this->assertSame($result, true);
- }
- /**
- * Reproduces a situation where a single node has lft= rght, and all other lft and rght fields follow sequentially
- *
- * @return void
- */
- public function testDetectEqualLftsRghts() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(1, 3);
- $result = $this->Tree->findByName('1.1');
- $this->Tree->updateAll(array($rightField => $result[$modelClass][$leftField]), array('id' => $result[$modelClass]['id']));
- $this->Tree->updateAll(array($leftField => $this->Tree->escapeField($leftField) . ' -1'),
- array($leftField . ' >' => $result[$modelClass][$leftField]));
- $this->Tree->updateAll(array($rightField => $this->Tree->escapeField($rightField) . ' -1'),
- array($rightField . ' >' => $result[$modelClass][$leftField]));
- $result = $this->Tree->verify();
- $this->assertNotSame($result, true);
- $result = $this->Tree->recover();
- $this->assertTrue($result);
- $result = $this->Tree->verify();
- $this->assertTrue($result);
- }
- /**
- * testAddOrphan method
- *
- * @return void
- */
- public function testAddOrphan() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $this->Tree->save(array($modelClass => array('name' => 'testAddOrphan', $parentField => null)));
- $result = $this->Tree->find('first', array('fields' => array('name', $parentField), 'order' => $modelClass . '.' . $leftField . ' desc'));
- $expected = array($modelClass => array('name' => 'testAddOrphan', $parentField => null));
- $this->assertEquals($expected, $result);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testAddMiddle method
- *
- * @return void
- */
- public function testAddMiddle() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.1')));
- $initialCount = $this->Tree->find('count');
- $this->Tree->create();
- $result = $this->Tree->save(array($modelClass => array('name' => 'testAddMiddle', $parentField => $data[$modelClass]['id'])));
- $expected = array_merge(array($modelClass => array('name' => 'testAddMiddle', $parentField => '2')), $result);
- $this->assertSame($expected, $result);
- $laterCount = $this->Tree->find('count');
- $this->assertEquals($initialCount + 1, $laterCount);
- $children = $this->Tree->children($data[$modelClass]['id'], true, array('name'));
- $expects = array(array($modelClass => array('name' => '1.1.1')),
- array($modelClass => array('name' => '1.1.2')),
- array($modelClass => array('name' => 'testAddMiddle')));
- $this->assertSame($children, $expects);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testAddWithPreSpecifiedId method
- *
- * @return void
- */
- public function testAddWithPreSpecifiedId() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $data = $this->Tree->find('first', array(
- 'fields' => array('id'),
- 'conditions' => array($modelClass . '.name' => '1.1')
- ));
- $this->Tree->create();
- $result = $this->Tree->save(array($modelClass => array(
- 'id' => 100,
- 'name' => 'testAddMiddle',
- $parentField => $data[$modelClass]['id'])
- ));
- $expected = array_merge(
- array($modelClass => array('id' => 100, 'name' => 'testAddMiddle', $parentField => '2')),
- $result
- );
- $this->assertSame($expected, $result);
- $this->assertTrue($this->Tree->verify());
- }
- /**
- * testAddInvalid method
- *
- * @return void
- */
- public function testAddInvalid() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $this->Tree->id = null;
- $initialCount = $this->Tree->find('count');
- //$this->expectError('Trying to save a node under a none-existant node in TreeBehavior::beforeSave');
- $saveSuccess = $this->Tree->save(array($modelClass => array('name' => 'testAddInvalid', $parentField => 99999)));
- $this->assertSame($saveSuccess, false);
- $laterCount = $this->Tree->find('count');
- $this->assertSame($initialCount, $laterCount);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testAddNotIndexedByModel method
- *
- * @return void
- */
- public function testAddNotIndexedByModel() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $this->Tree->save(array('name' => 'testAddNotIndexed', $parentField => null));
- $result = $this->Tree->find('first', array('fields' => array('name', $parentField), 'order' => $modelClass . '.' . $leftField . ' desc'));
- $expected = array($modelClass => array('name' => 'testAddNotIndexed', $parentField => null));
- $this->assertEquals($expected, $result);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testMovePromote method
- *
- * @return void
- */
- public function testMovePromote() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $this->Tree->id = null;
- $parent = $this->Tree->find('first', array('conditions' => array($modelClass . '.name' => '1. Root')));
- $parentId = $parent[$modelClass]['id'];
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.1.1')));
- $this->Tree->id = $data[$modelClass]['id'];
- $this->Tree->saveField($parentField, $parentId);
- $direct = $this->Tree->children($parentId, true, array('id', 'name', $parentField, $leftField, $rightField));
- $expects = array(array($modelClass => array('id' => 2, 'name' => '1.1', $parentField => 1, $leftField => 2, $rightField => 5)),
- array($modelClass => array('id' => 5, 'name' => '1.2', $parentField => 1, $leftField => 6, $rightField => 11)),
- array($modelClass => array('id' => 3, 'name' => '1.1.1', $parentField => 1, $leftField => 12, $rightField => 13)));
- $this->assertEquals($direct, $expects);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testMoveWithWhitelist method
- *
- * @return void
- */
- public function testMoveWithWhitelist() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $this->Tree->id = null;
- $parent = $this->Tree->find('first', array('conditions' => array($modelClass . '.name' => '1. Root')));
- $parentId = $parent[$modelClass]['id'];
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.1.1')));
- $this->Tree->id = $data[$modelClass]['id'];
- $this->Tree->whitelist = array($parentField, 'name', 'description');
- $this->Tree->saveField($parentField, $parentId);
- $result = $this->Tree->children($parentId, true, array('id', 'name', $parentField, $leftField, $rightField));
- $expected = array(array($modelClass => array('id' => 2, 'name' => '1.1', $parentField => 1, $leftField => 2, $rightField => 5)),
- array($modelClass => array('id' => 5, 'name' => '1.2', $parentField => 1, $leftField => 6, $rightField => 11)),
- array($modelClass => array('id' => 3, 'name' => '1.1.1', $parentField => 1, $leftField => 12, $rightField => 13)));
- $this->assertEquals($expected, $result);
- $this->assertTrue($this->Tree->verify());
- }
- /**
- * testInsertWithWhitelist method
- *
- * @return void
- */
- public function testInsertWithWhitelist() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $this->Tree->whitelist = array('name', $parentField);
- $this->Tree->save(array($modelClass => array('name' => 'testAddOrphan', $parentField => null)));
- $result = $this->Tree->findByName('testAddOrphan', array('name', $parentField, $leftField, $rightField));
- $expected = array('name' => 'testAddOrphan', $parentField => null, $leftField => '15', $rightField => 16);
- $this->assertEquals($expected, $result[$modelClass]);
- $this->assertSame($this->Tree->verify(), true);
- }
- /**
- * testMoveBefore method
- *
- * @return void
- */
- public function testMoveBefore() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $this->Tree->id = null;
- $parent = $this->Tree->find('first', array('conditions' => array($modelClass . '.name' => '1.1')));
- $parentId = $parent[$modelClass]['id'];
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.2')));
- $this->Tree->id = $data[$modelClass]['id'];
- $this->Tree->saveField($parentField, $parentId);
- $result = $this->Tree->children($parentId, true, array('name'));
- $expects = array(array($modelClass => array('name' => '1.1.1')),
- array($modelClass => array('name' => '1.1.2')),
- array($modelClass => array('name' => '1.2')));
- $this->assertEquals($expects, $result);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testMoveAfter method
- *
- * @return void
- */
- public function testMoveAfter() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $this->Tree->id = null;
- $parent = $this->Tree->find('first', array('conditions' => array($modelClass . '.name' => '1.2')));
- $parentId = $parent[$modelClass]['id'];
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.1')));
- $this->Tree->id = $data[$modelClass]['id'];
- $this->Tree->saveField($parentField, $parentId);
- $result = $this->Tree->children($parentId, true, array('name'));
- $expects = array(array($modelClass => array('name' => '1.2.1')),
- array($modelClass => array('name' => '1.2.2')),
- array($modelClass => array('name' => '1.1')));
- $this->assertEquals($expects, $result);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testMoveDemoteInvalid method
- *
- * @return void
- */
- public function testMoveDemoteInvalid() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $this->Tree->id = null;
- $parent = $this->Tree->find('first', array('conditions' => array($modelClass . '.name' => '1. Root')));
- $parentId = $parent[$modelClass]['id'];
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.1.1')));
- $expects = $this->Tree->find('all');
- $before = $this->Tree->read(null, $data[$modelClass]['id']);
- $this->Tree->id = $parentId;
- $this->Tree->saveField($parentField, $data[$modelClass]['id']);
- $results = $this->Tree->find('all');
- $after = $this->Tree->read(null, $data[$modelClass]['id']);
- $this->assertEquals($expects, $results);
- $this->assertEquals($before, $after);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testMoveInvalid method
- *
- * @return void
- */
- public function testMoveInvalid() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $this->Tree->id = null;
- $initialCount = $this->Tree->find('count');
- $data = $this->Tree->findByName('1.1');
- $this->Tree->id = $data[$modelClass]['id'];
- $this->Tree->saveField($parentField, 999999);
- $laterCount = $this->Tree->find('count');
- $this->assertSame($initialCount, $laterCount);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testMoveSelfInvalid method
- *
- * @return void
- */
- public function testMoveSelfInvalid() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $this->Tree->id = null;
- $initialCount = $this->Tree->find('count');
- $data = $this->Tree->findByName('1.1');
- $this->Tree->id = $data[$modelClass]['id'];
- $saveSuccess = $this->Tree->saveField($parentField, $this->Tree->id);
- $this->assertSame($saveSuccess, false);
- $laterCount = $this->Tree->find('count');
- $this->assertSame($initialCount, $laterCount);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testMoveUpSuccess method
- *
- * @return void
- */
- public function testMoveUpSuccess() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.2')));
- $this->Tree->moveUp($data[$modelClass]['id']);
- $parent = $this->Tree->findByName('1. Root', array('id'));
- $this->Tree->id = $parent[$modelClass]['id'];
- $result = $this->Tree->children(null, true, array('name'));
- $expected = array(array($modelClass => array('name' => '1.2')),
- array($modelClass => array('name' => '1.1')));
- $this->assertSame($expected, $result);
- }
- /**
- * testMoveUpFail method
- *
- * @return void
- */
- public function testMoveUpFail() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $data = $this->Tree->find('first', array('conditions' => array($modelClass . '.name' => '1.1')));
- $this->Tree->moveUp($data[$modelClass]['id']);
- $parent = $this->Tree->findByName('1. Root', array('id'));
- $this->Tree->id = $parent[$modelClass]['id'];
- $result = $this->Tree->children(null, true, array('name'));
- $expected = array(array($modelClass => array('name' => '1.1')),
- array($modelClass => array('name' => '1.2')));
- $this->assertSame($expected, $result);
- }
- /**
- * testMoveUp2 method
- *
- * @return void
- */
- public function testMoveUp2() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(1, 10);
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.5')));
- $this->Tree->moveUp($data[$modelClass]['id'], 2);
- $parent = $this->Tree->findByName('1. Root', array('id'));
- $this->Tree->id = $parent[$modelClass]['id'];
- $result = $this->Tree->children(null, true, array('name'));
- $expected = array(
- array($modelClass => array('name' => '1.1')),
- array($modelClass => array('name' => '1.2')),
- array($modelClass => array('name' => '1.5')),
- array($modelClass => array('name' => '1.3')),
- array($modelClass => array('name' => '1.4')),
- array($modelClass => array('name' => '1.6')),
- array($modelClass => array('name' => '1.7')),
- array($modelClass => array('name' => '1.8')),
- array($modelClass => array('name' => '1.9')),
- array($modelClass => array('name' => '1.10')));
- $this->assertSame($expected, $result);
- }
- /**
- * testMoveUpFirst method
- *
- * @return void
- */
- public function testMoveUpFirst() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(1, 10);
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.5')));
- $this->Tree->moveUp($data[$modelClass]['id'], true);
- $parent = $this->Tree->findByName('1. Root', array('id'));
- $this->Tree->id = $parent[$modelClass]['id'];
- $result = $this->Tree->children(null, true, array('name'));
- $expected = array(
- array($modelClass => array('name' => '1.5')),
- array($modelClass => array('name' => '1.1')),
- array($modelClass => array('name' => '1.2')),
- array($modelClass => array('name' => '1.3')),
- array($modelClass => array('name' => '1.4')),
- array($modelClass => array('name' => '1.6')),
- array($modelClass => array('name' => '1.7')),
- array($modelClass => array('name' => '1.8')),
- array($modelClass => array('name' => '1.9')),
- array($modelClass => array('name' => '1.10')));
- $this->assertSame($expected, $result);
- }
- /**
- * testMoveDownSuccess method
- *
- * @return void
- */
- public function testMoveDownSuccess() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.1')));
- $this->Tree->moveDown($data[$modelClass]['id']);
- $parent = $this->Tree->findByName('1. Root', array('id'));
- $this->Tree->id = $parent[$modelClass]['id'];
- $result = $this->Tree->children(null, true, array('name'));
- $expected = array(array($modelClass => array('name' => '1.2')),
- array($modelClass => array('name' => '1.1')));
- $this->assertSame($expected, $result);
- }
- /**
- * testMoveDownFail method
- *
- * @return void
- */
- public function testMoveDownFail() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $data = $this->Tree->find('first', array('conditions' => array($modelClass . '.name' => '1.2')));
- $this->Tree->moveDown($data[$modelClass]['id']);
- $parent = $this->Tree->findByName('1. Root', array('id'));
- $this->Tree->id = $parent[$modelClass]['id'];
- $result = $this->Tree->children(null, true, array('name'));
- $expected = array(array($modelClass => array('name' => '1.1')),
- array($modelClass => array('name' => '1.2')));
- $this->assertSame($expected, $result);
- }
- /**
- * testMoveDownLast method
- *
- * @return void
- */
- public function testMoveDownLast() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(1, 10);
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.5')));
- $this->Tree->moveDown($data[$modelClass]['id'], true);
- $parent = $this->Tree->findByName('1. Root', array('id'));
- $this->Tree->id = $parent[$modelClass]['id'];
- $result = $this->Tree->children(null, true, array('name'));
- $expected = array(
- array($modelClass => array('name' => '1.1')),
- array($modelClass => array('name' => '1.2')),
- array($modelClass => array('name' => '1.3')),
- array($modelClass => array('name' => '1.4')),
- array($modelClass => array('name' => '1.6')),
- array($modelClass => array('name' => '1.7')),
- array($modelClass => array('name' => '1.8')),
- array($modelClass => array('name' => '1.9')),
- array($modelClass => array('name' => '1.10')),
- array($modelClass => array('name' => '1.5')));
- $this->assertSame($expected, $result);
- }
- /**
- * testMoveDown2 method
- *
- * @return void
- */
- public function testMoveDown2() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(1, 10);
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.5')));
- $this->Tree->moveDown($data[$modelClass]['id'], 2);
- $parent = $this->Tree->findByName('1. Root', array('id'));
- $this->Tree->id = $parent[$modelClass]['id'];
- $result = $this->Tree->children(null, true, array('name'));
- $expected = array(
- array($modelClass => array('name' => '1.1')),
- array($modelClass => array('name' => '1.2')),
- array($modelClass => array('name' => '1.3')),
- array($modelClass => array('name' => '1.4')),
- array($modelClass => array('name' => '1.6')),
- array($modelClass => array('name' => '1.7')),
- array($modelClass => array('name' => '1.5')),
- array($modelClass => array('name' => '1.8')),
- array($modelClass => array('name' => '1.9')),
- array($modelClass => array('name' => '1.10')));
- $this->assertSame($expected, $result);
- }
- /**
- * testSaveNoMove method
- *
- * @return void
- */
- public function testSaveNoMove() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(1, 10);
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.5')));
- $this->Tree->id = $data[$modelClass]['id'];
- $this->Tree->saveField('name', 'renamed');
- $parent = $this->Tree->findByName('1. Root', array('id'));
- $this->Tree->id = $parent[$modelClass]['id'];
- $result = $this->Tree->children(null, true, array('name'));
- $expected = array(
- array($modelClass => array('name' => '1.1')),
- array($modelClass => array('name' => '1.2')),
- array($modelClass => array('name' => '1.3')),
- array($modelClass => array('name' => '1.4')),
- array($modelClass => array('name' => 'renamed')),
- array($modelClass => array('name' => '1.6')),
- array($modelClass => array('name' => '1.7')),
- array($modelClass => array('name' => '1.8')),
- array($modelClass => array('name' => '1.9')),
- array($modelClass => array('name' => '1.10')));
- $this->assertSame($expected, $result);
- }
- /**
- * testMoveToRootAndMoveUp method
- *
- * @return void
- */
- public function testMoveToRootAndMoveUp() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(1, 1);
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.1')));
- $this->Tree->id = $data[$modelClass]['id'];
- $this->Tree->save(array($parentField => null));
- $result = $this->Tree->verify();
- $this->assertSame($result, true);
- $this->Tree->moveUp();
- $result = $this->Tree->find('all', array('fields' => 'name', 'order' => $modelClass . '.' . $leftField . ' ASC'));
- $expected = array(array($modelClass => array('name' => '1.1')),
- array($modelClass => array('name' => '1. Root')));
- $this->assertSame($expected, $result);
- }
- /**
- * testDelete method
- *
- * @return void
- */
- public function testDelete() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $initialCount = $this->Tree->find('count');
- $result = $this->Tree->findByName('1.1.1');
- $return = $this->Tree->delete($result[$modelClass]['id']);
- $this->assertEquals(true, $return);
- $laterCount = $this->Tree->find('count');
- $this->assertEquals($initialCount - 1, $laterCount);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- $initialCount = $this->Tree->find('count');
- $result = $this->Tree->findByName('1.1');
- $return = $this->Tree->delete($result[$modelClass]['id']);
- $this->assertEquals(true, $return);
- $laterCount = $this->Tree->find('count');
- $this->assertEquals($initialCount - 2, $laterCount);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * Test deleting a record that doesn't exist.
- *
- * @return void
- */
- public function testDeleteDoesNotExist() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $this->Tree->delete(99999);
- }
- /**
- * testRemove method
- *
- * @return void
- */
- public function testRemove() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $initialCount = $this->Tree->find('count');
- $result = $this->Tree->findByName('1.1');
- $this->Tree->removeFromTree($result[$modelClass]['id']);
- $laterCount = $this->Tree->find('count');
- $this->assertEquals($initialCount, $laterCount);
- $children = $this->Tree->children($result[$modelClass][$parentField], true, array('name'));
- $expects = array(array($modelClass => array('name' => '1.1.1')),
- array($modelClass => array('name' => '1.1.2')),
- array($modelClass => array('name' => '1.2')));
- $this->assertEquals($children, $expects);
- $topNodes = $this->Tree->children(false, true, array('name'));
- $expects = array(array($modelClass => array('name' => '1. Root')),
- array($modelClass => array('name' => '1.1')));
- $this->assertEquals($topNodes, $expects);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testRemoveLastTopParent method
- *
- * @return void
- */
- public function testRemoveLastTopParent() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $initialCount = $this->Tree->find('count');
- $initialTopNodes = $this->Tree->childCount(false);
- $result = $this->Tree->findByName('1. Root');
- $this->Tree->removeFromTree($result[$modelClass]['id']);
- $laterCount = $this->Tree->find('count');
- $laterTopNodes = $this->Tree->childCount(false);
- $this->assertEquals($initialCount, $laterCount);
- $this->assertEquals($initialTopNodes, $laterTopNodes);
- $topNodes = $this->Tree->children(false, true, array('name'));
- $expects = array(array($modelClass => array('name' => '1.1')),
- array($modelClass => array('name' => '1.2')),
- array($modelClass => array('name' => '1. Root')));
- $this->assertEquals($topNodes, $expects);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testRemoveNoChildren method
- *
- * @return void
- */
- public function testRemoveNoChildren() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $initialCount = $this->Tree->find('count');
- $result = $this->Tree->findByName('1.1.1');
- $this->Tree->removeFromTree($result[$modelClass]['id']);
- $laterCount = $this->Tree->find('count');
- $this->assertEquals($initialCount, $laterCount);
- $nodes = $this->Tree->find('list', array('order' => $leftField));
- $expects = array(
- 1 => '1. Root',
- 2 => '1.1',
- 4 => '1.1.2',
- 5 => '1.2',
- 6 => '1.2.1',
- 7 => '1.2.2',
- 3 => '1.1.1',
- );
- $this->assertEquals($nodes, $expects);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testRemoveAndDelete method
- *
- * @return void
- */
- public function testRemoveAndDelete() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $initialCount = $this->Tree->find('count');
- $result = $this->Tree->findByName('1.1');
- $this->Tree->removeFromTree($result[$modelClass]['id'], true);
- $laterCount = $this->Tree->find('count');
- $this->assertEquals($initialCount - 1, $laterCount);
- $children = $this->Tree->children($result[$modelClass][$parentField], true, array('name'), $leftField . ' asc');
- $expects = array(
- array($modelClass => array('name' => '1.1.1')),
- array($modelClass => array('name' => '1.1.2')),
- array($modelClass => array('name' => '1.2'))
- );
- $this->assertEquals($children, $expects);
- $topNodes = $this->Tree->children(false, true, array('name'));
- $expects = array(array($modelClass => array('name' => '1. Root')));
- $this->assertEquals($topNodes, $expects);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testRemoveAndDeleteNoChildren method
- *
- * @return void
- */
- public function testRemoveAndDeleteNoChildren() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $initialCount = $this->Tree->find('count');
- $result = $this->Tree->findByName('1.1.1');
- $this->Tree->removeFromTree($result[$modelClass]['id'], true);
- $laterCount = $this->Tree->find('count');
- $this->assertEquals($initialCount - 1, $laterCount);
- $nodes = $this->Tree->find('list', array('order' => $leftField));
- $expects = array(
- 1 => '1. Root',
- 2 => '1.1',
- 4 => '1.1.2',
- 5 => '1.2',
- 6 => '1.2.1',
- 7 => '1.2.2',
- );
- $this->assertEquals($nodes, $expects);
- $validTree = $this->Tree->verify();
- $this->assertSame($validTree, true);
- }
- /**
- * testChildren method
- *
- * @return void
- */
- public function testChildren() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $data = $this->Tree->find('first', array('conditions' => array($modelClass . '.name' => '1. Root')));
- $this->Tree->id = $data[$modelClass]['id'];
- $direct = $this->Tree->children(null, true, array('id', 'name', $parentField, $leftField, $rightField));
- $expects = array(array($modelClass => array('id' => 2, 'name' => '1.1', $parentField => 1, $leftField => 2, $rightField => 7)),
- array($modelClass => array('id' => 5, 'name' => '1.2', $parentField => 1, $leftField => 8, $rightField => 13)));
- $this->assertEquals($direct, $expects);
- $total = $this->Tree->children(null, null, array('id', 'name', $parentField, $leftField, $rightField));
- $expects = array(array($modelClass => array('id' => 2, 'name' => '1.1', $parentField => 1, $leftField => 2, $rightField => 7)),
- array($modelClass => array('id' => 3, 'name' => '1.1.1', $parentField => 2, $leftField => 3, $rightField => 4)),
- array($modelClass => array('id' => 4, 'name' => '1.1.2', $parentField => 2, $leftField => 5, $rightField => 6)),
- array($modelClass => array('id' => 5, 'name' => '1.2', $parentField => 1, $leftField => 8, $rightField => 13)),
- array($modelClass => array('id' => 6, 'name' => '1.2.1', $parentField => 5, $leftField => 9, $rightField => 10)),
- array($modelClass => array('id' => 7, 'name' => '1.2.2', $parentField => 5, $leftField => 11, $rightField => 12)));
- $this->assertEquals($total, $expects);
- $this->assertEquals(array(), $this->Tree->children(10000));
- }
- /**
- * testCountChildren method
- *
- * @return void
- */
- public function testCountChildren() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $data = $this->Tree->find('first', array('conditions' => array($modelClass . '.name' => '1. Root')));
- $this->Tree->id = $data[$modelClass]['id'];
- $direct = $this->Tree->childCount(null, true);
- $this->assertEquals(2, $direct);
- $total = $this->Tree->childCount();
- $this->assertEquals(6, $total);
- $this->Tree->read(null, $data[$modelClass]['id']);
- $id = $this->Tree->field('id', array($modelClass . '.name' => '1.2'));
- $total = $this->Tree->childCount($id);
- $this->assertEquals(2, $total);
- }
- /**
- * testGetParentNode method
- *
- * @return void
- */
- public function testGetParentNode() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $data = $this->Tree->find('first', array('conditions' => array($modelClass . '.name' => '1.2.2')));
- $this->Tree->id = $data[$modelClass]['id'];
- $result = $this->Tree->getParentNode(null, array('name'));
- $expects = array($modelClass => array('name' => '1.2'));
- $this->assertSame($expects, $result);
- }
- /**
- * testGetPath method
- *
- * @return void
- */
- public function testGetPath() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $data = $this->Tree->find('first', array('conditions' => array($modelClass . '.name' => '1.2.2')));
- $this->Tree->id = $data[$modelClass]['id'];
- $result = $this->Tree->getPath(null, array('name'));
- $expects = array(array($modelClass => array('name' => '1. Root')),
- array($modelClass => array('name' => '1.2')),
- array($modelClass => array('name' => '1.2.2')));
- $this->assertSame($expects, $result);
- }
- /**
- * testNoAmbiguousColumn method
- *
- * @return void
- */
- public function testNoAmbiguousColumn() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->bindModel(array('belongsTo' => array('Dummy' =>
- array('className' => $modelClass, 'foreignKey' => $parentField, 'conditions' => array('Dummy.id' => null)))), false);
- $this->Tree->initialize(2, 2);
- $data = $this->Tree->find('first', array('conditions' => array($modelClass . '.name' => '1. Root')));
- $this->Tree->id = $data[$modelClass]['id'];
- $direct = $this->Tree->children(null, true, array('id', 'name', $parentField, $leftField, $rightField));
- $expects = array(array($modelClass => array('id' => 2, 'name' => '1.1', $parentField => 1, $leftField => 2, $rightField => 7)),
- array($modelClass => array('id' => 5, 'name' => '1.2', $parentField => 1, $leftField => 8, $rightField => 13)));
- $this->assertEquals($direct, $expects);
- $total = $this->Tree->children(null, null, array('id', 'name', $parentField, $leftField, $rightField));
- $expects = array(
- array($modelClass => array('id' => 2, 'name' => '1.1', $parentField => 1, $leftField => 2, $rightField => 7)),
- array($modelClass => array('id' => 3, 'name' => '1.1.1', $parentField => 2, $leftField => 3, $rightField => 4)),
- array($modelClass => array('id' => 4, 'name' => '1.1.2', $parentField => 2, $leftField => 5, $rightField => 6)),
- array($modelClass => array('id' => 5, 'name' => '1.2', $parentField => 1, $leftField => 8, $rightField => 13)),
- array($modelClass => array('id' => 6, 'name' => '1.2.1', $parentField => 5, $leftField => 9, $rightField => 10)),
- array($modelClass => array('id' => 7, 'name' => '1.2.2', $parentField => 5, $leftField => 11, $rightField => 12))
- );
- $this->assertEquals($total, $expects);
- }
- /**
- * testReorderTree method
- *
- * @return void
- */
- public function testReorderTree() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(3, 3);
- $nodes = $this->Tree->find('list', array('order' => $leftField));
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.1')));
- $this->Tree->moveDown($data[$modelClass]['id']);
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.2.1')));
- $this->Tree->moveDown($data[$modelClass]['id']);
- $data = $this->Tree->find('first', array('fields' => array('id'), 'conditions' => array($modelClass . '.name' => '1.3.2.2')));
- $this->Tree->moveDown($data[$modelClass]['id']);
- $unsortedNodes = $this->Tree->find('list', array('order' => $leftField));
- $this->assertEquals($nodes, $unsortedNodes);
- $this->assertNotEquals(array_keys($nodes), array_keys($unsortedNodes));
- $this->Tree->reorder();
- $sortedNodes = $this->Tree->find('list', array('order' => $leftField));
- $this->assertSame($nodes, $sortedNodes);
- }
- /**
- * test reordering large-ish trees with cacheQueries = true.
- * This caused infinite loops when moving down elements as stale data is returned
- * from the memory cache
- *
- * @return void
- */
- public function testReorderBigTreeWithQueryCaching() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 10);
- $original = $this->Tree->cacheQueries;
- $this->Tree->cacheQueries = true;
- $this->Tree->reorder(array('field' => 'name', 'direction' => 'DESC'));
- $this->assertTrue($this->Tree->cacheQueries, 'cacheQueries was not restored after reorder(). %s');
- $this->Tree->cacheQueries = $original;
- }
- /**
- * testGenerateTreeListWithSelfJoin method
- *
- * @return void
- */
- public function testGenerateTreeListWithSelfJoin() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->bindModel(array('belongsTo' => array('Dummy' =>
- array('className' => $modelClass, 'foreignKey' => $parentField, 'conditions' => array('Dummy.id' => null)))), false);
- $this->Tree->initialize(2, 2);
- $result = $this->Tree->generateTreeList();
- $expected = array(1 => '1. Root', 2 => '_1.1', 3 => '__1.1.1', 4 => '__1.1.2', 5 => '_1.2', 6 => '__1.2.1', 7 => '__1.2.2');
- $this->assertSame($expected, $result);
- }
- /**
- * Test the formatting options of generateTreeList()
- *
- * @return void
- */
- public function testGenerateTreeListFormatting() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(2, 2);
- $result = $this->Tree->generateTreeList(
- null,
- "{n}.$modelClass.id",
- array('%s - %s', "{n}.$modelClass.id", "{n}.$modelClass.name")
- );
- $this->assertEquals('1 - 1. Root', $result[1]);
- $this->assertEquals('_2 - 1.1', $result[2]);
- $this->assertEquals('__3 - 1.1.1', $result[3]);
- }
- /**
- * testArraySyntax method
- *
- * @return void
- */
- public function testArraySyntax() {
- extract($this->settings);
- $this->Tree = new $modelClass();
- $this->Tree->order = null;
- $this->Tree->initialize(3, 3);
- $this->assertSame($this->Tree->childCount(2), $this->Tree->childCount(array('id' => 2)));
- $this->assertSame($this->Tree->getParentNode(2), $this->Tree->getParentNode(array('id' => 2)));
- $this->assertSame($this->Tree->getPath(4), $this->Tree->getPath(array('id' => 4)));
- }
- /**
- * testFindThreaded method
- *
- * @return void
- */
- public function testFindThreaded() {
- $Model = new Person();
- $Model->recursive = -1;
- $Model->Behaviors->attach('Tree', array('parent' => 'mother_id'));
- $result = $Model->find('threaded');
- $expected = array(
- array(
- 'Person' => array(
- 'id' => '4',
- 'name' => 'mother - grand mother',
- 'mother_id' => '0',
- 'father_id' => '0'
- ),
- 'children' => array(
- array(
- 'Person' => array(
- 'id' => '2',
- 'name' => 'mother',
- 'mother_id' => '4',
- 'father_id' => '5'
- ),
- 'children' => array(
- array(
- 'Person' => array(
- 'id' => '1',
- 'name' => 'person',
- 'mother_id' => '2',
- 'father_id' => '3'
- ),
- 'children' => array()
- )
- )
- )
- )
- ),
- array(
- 'Person' => array(
- 'id' => '5',
- 'name' => 'mother - grand father',
- 'mother_id' => '0',
- 'father_id' => '0'
- ),
- 'children' => array()
- ),
- array(
- 'Person' => array(
- 'id' => '6',
- 'name' => 'father - grand mother',
- 'mother_id' => '0',
- 'father_id' => '0'
- ),
- 'children' => array(
- array(
- 'Person' => array(
- 'id' => '3',
- 'name' => 'father',
- 'mother_id' => '6',
- 'father_id' => '7'
- ),
- 'children' => array()
- )
- )
- ),
- array(
- 'Person' => array(
- 'id' => '7',
- 'name' => 'father - grand father',
- 'mother_id' => '0',
- 'father_id' => '0'
- ),
- 'children' => array()
- )
- );
- $this->assertEquals($expected, $result);
- }
- }
|