Subversion Repositories SmartDukaan

<?php

/**

 * Tests cross database HABTM. Requires $test and $test2 to both be set in DATABASE_CONFIG

 * NOTE: When testing on MySQL, you must set 'persistent' => false on *both* database connections,

 * or one connection will step on the other.

 *

 * 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

 * @since         CakePHP(tm) v 2.1

 * @license       http://www.opensource.org/licenses/mit-license.php MIT License

 */

require_once dirname(__FILE__) . DS . 'ModelTestBase.php';

/**

 * Class ModelCrossSchemaHabtmTest

 *

 * @package       Cake.Test.Case.Model

 */

class ModelCrossSchemaHabtmTest extends BaseModelTest {

/**

 * Fixtures to be used

 *

 * @var array

 */

	public $fixtures = array(

		'core.player', 'core.guild', 'core.guilds_player',

		'core.armor', 'core.armors_player',

	);

/**

 * Don't drop tables if they exist

 *

 * @var bool

 */

	public $dropTables = false;

/**

 * Don't auto load fixtures

 *

 * @var bool

 */

	public $autoFixtures = false;

/**

 * setUp method

 *

 * @return void

 */

	public function setUp() {

		parent::setUp();

		$this->_checkConfigs();

	}

/**

 * Check if primary and secondary test databases are configured.

 *

 * @return void

 */

	protected function _checkConfigs() {

		$config = ConnectionManager::enumConnectionObjects();

		$this->skipIf($this->db instanceof Sqlite, 'This test is not compatible with Sqlite.');

		$this->skipIf(

			!isset($config['test']) || !isset($config['test2']),

			'Primary and secondary test databases not configured, ' .

			'skipping cross-database join tests.' .

			' To run these tests, you must define $test and $test2 in your database configuration.'

		);

	}

/**

 * testModelDatasources method

 *

 * @return void

 */

	public function testModelDatasources() {

		$this->loadFixtures('Player', 'Guild', 'GuildsPlayer');

		$Player = ClassRegistry::init('Player');

		$this->assertEquals('test', $Player->useDbConfig);

		$this->assertEquals('test', $Player->Guild->useDbConfig);

		$this->assertEquals('test2', $Player->GuildsPlayer->useDbConfig);

		$this->assertEquals('test', $Player->getDataSource()->configKeyName);

		$this->assertEquals('test', $Player->Guild->getDataSource()->configKeyName);

		$this->assertEquals('test2', $Player->GuildsPlayer->getDataSource()->configKeyName);

	}

/**

 * testHabtmFind method

 *

 * @return void

 */

	public function testHabtmFind() {

		$this->loadFixtures('Player', 'Guild', 'GuildsPlayer');

		$Player = ClassRegistry::init('Player');

		$players = $Player->find('all', array(

			'fields' => array('id', 'name'),

			'contain' => array(

				'Guild' => array(

					'conditions' => array(

						'Guild.name' => 'Wizards',

					),

				),

			),

		));

		$this->assertEquals(4, count($players));

		$wizards = Hash::extract($players, '{n}.Guild.{n}[name=Wizards]');

		$this->assertEquals(1, count($wizards));

		$players = $Player->find('all', array(

			'fields' => array('id', 'name'),

			'conditions' => array(

				'Player.id' => 1,

			),

		));

		$this->assertEquals(1, count($players));

		$wizards = Hash::extract($players, '{n}.Guild.{n}');

		$this->assertEquals(2, count($wizards));

	}

/**

 * testHabtmSave method

 *

 * @return void

 */

	public function testHabtmSave() {

		$this->loadFixtures('Player', 'Guild', 'GuildsPlayer');

		$Player = ClassRegistry::init('Player');

		$players = $Player->find('count');

		$this->assertEquals(4, $players);

		$player = $Player->create(array(

			'name' => 'rchavik',

		));

		$results = $Player->saveAll($player, array('validate' => 'first'));

		$this->assertNotSame(false, $results);

		$count = $Player->find('count');

		$this->assertEquals(5, $count);

		$count = $Player->GuildsPlayer->find('count');

		$this->assertEquals(3, $count);

		$player = $Player->findByName('rchavik');

		$this->assertEmpty($player['Guild']);

		$player['Guild']['Guild'] = array(1, 2, 3);

		$Player->save($player);

		$player = $Player->findByName('rchavik');

		$this->assertEquals(3, count($player['Guild']));

		$players = $Player->find('all', array(

			'contain' => array(

				'conditions' => array(

					'Guild.name' => 'Rangers',

				),

			),

		));

		$rangers = Hash::extract($players, '{n}.Guild.{n}[name=Rangers]');

		$this->assertEquals(2, count($rangers));

	}

/**

 * testHabtmWithThreeDatabases method

 *

 * @return void

 */

	public function testHabtmWithThreeDatabases() {

		$config = ConnectionManager::enumConnectionObjects();

		$this->skipIf(

			!isset($config['test']) || !isset($config['test2']) || !isset($config['test_database_three']),

			'Primary, secondary, and tertiary test databases not configured,' .

			' skipping test. To run these tests, you must define ' .

			'$test, $test2, and $test_database_three in your database configuration.'

		);

		$this->loadFixtures('Player', 'Guild', 'GuildsPlayer', 'Armor', 'ArmorsPlayer');

		$Player = ClassRegistry::init('Player');

		$Player->bindModel(array(

			'hasAndBelongsToMany' => array(

				'Armor' => array(

					'with' => 'ArmorsPlayer',

					'unique' => true,

				),

			),

		), false);

		$this->assertEquals('test', $Player->useDbConfig);

		$this->assertEquals('test2', $Player->Armor->useDbConfig);

		$this->assertEquals('test_database_three', $Player->ArmorsPlayer->useDbConfig);

		$players = $Player->find('count');

		$this->assertEquals(4, $players);

		$spongebob = $Player->create(array(

			'id' => 10,

			'name' => 'spongebob',

		));

		$spongebob['Armor'] = array('Armor' => array(1, 2, 3, 4));

		$result = $Player->save($spongebob);

		$expected = array(

			'Player' => array(

				'id' => 10,

				'name' => 'spongebob',

			),

			'Armor' => array(

				'Armor' => array(

					1, 2, 3, 4,

				),

			),

		);

		unset($result['Player']['created']);

		unset($result['Player']['updated']);

		$this->assertEquals($expected, $result);

		$spongebob = $Player->find('all', array(

			'conditions' => array(

				'Player.id' => 10,

			)

		));

		$spongeBobsArmors = Hash::extract($spongebob, '{n}.Armor.{n}');

		$this->assertEquals(4, count($spongeBobsArmors));

	}

}