/app/Plugin/Mongodb/Test/Case/Behavior/SqlCompatibleTest.php

<?php

/**

 * Tests specific to the sql compatible behavior

 *

 * PHP version 5

 *

 * Copyright (c) 2010, Andy Dawson

 *

 * Licensed under The MIT License

 * Redistributions of files must retain the above copyright notice.

 *

 * @filesource

 * @copyright     Copyright (c) 2010, Andy Dawson

 * @link          www.ad7six.com

 * @package       mongodb

 * @subpackage    mongodb.tests.cases.behaviors

 * @since         v 1.0 (14-Dec-2010)

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

 */





App::uses('Model', 'Model');

App::uses('AppModel', 'Model');





/**

 * SqlCompatiblePost class

 *

 * @uses          Post

 * @package       mongodb

 * @subpackage    mongodb.tests.cases.behaviors

 */

class SqlCompatiblePost extends AppModel {



/**

 * useDbConfig property

 *

 * @var string 'test_mongo'

 * @access public

 */

	public $useDbConfig = 'test_mongo';



/**

 * actsAs property

 *

 * @var array

 * @access public

 */

	public $actsAs = array(

		'Mongodb.SqlCompatible'

	);



	public $lastQuery = array();



	public function beforeFind($query) {

		$this->lastQuery = $query;

		return $query;

	}

}



/**

 * SqlCompatibleTest class

 *

 * @uses          CakeTestCase

 * @package       mongodb

 * @subpackage    mongodb.tests.cases.behaviors

 */

class SqlCompatibleTest extends CakeTestCase {



/**

 * Default db config. overriden by test db connection if present

 *

 * @var array

 * @access protected

 */

	protected $_config = array(

		'datasource' => 'Mongodb.MongodbSource',

		'host' => 'localhost',

		'login' => '',

		'password' => '',

		'database' => 'test_mongo',

		'port' => 27017,

		'prefix' => '',

		'persistent' => false,

	);



	public function setUp() {

		$connections = ConnectionManager::enumConnectionObjects();



		if (!empty($connections['test']['classname']) && $connections['test']['classname'] === 'mongodbSource') {

			$config = new DATABASE_CONFIG();

			$this->_config = $config->test;

		}



		if(!isset($connections['test_mongo'])) {

			ConnectionManager::create('test_mongo', $this->_config);

			$this->Mongo = new MongodbSource($this->_config);

		}



		$this->Post = ClassRegistry::init(array('class' => 'SqlCompatiblePost', 'alias' => 'Post', 'ds' => 'test_mongo'), true);

	}



/**

 * Sets up the environment for each test method

 *

 * @return void

 * @access public

 */

	public function startTest($method) {

		$this->_setupData();

	}



/**

 * Destroys the environment after each test method is run

 *

 * @return void

 * @access public

 */

	public function endTest($method) {

		$this->Post->deleteAll(true);

	}



	public function tearDown() {

		unset($this->Post);

		ClassRegistry::flush();

	}



/**

 * testNOT method

 *

 * @return void

 * @access public

 */

	public function testNOT() {

		$expected = array(1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20);

		$result = $this->Post->find('all', array(

			'conditions' => array(

				'title !=' => 10,

			),

			'fields' => array('_id', 'title', 'number'),

			'order' => array('number' => 'ASC')

		));



		$result = Hash::extract($result, '{n}.Post.title');

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



		$conditions = array(

			'title' => array('$ne' => 10)

		);

		$this->assertEqual($conditions, $this->Post->lastQuery['conditions']);



		$result = $this->Post->find('all', array(

			'conditions' => array(

				'NOT' => array(

					'title' => 10

				),

			),

			'fields' => array('_id', 'title', 'number'),

			'order' => array('number' => 'ASC')

		));

		$result = Hash::extract($result, '{n}.Post.title');

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



		$conditions = array(

			'title' => array('$nin' => array(10))

		);

		$this->assertEqual($conditions, $this->Post->lastQuery['conditions']);

	}



/**

 * testNOTIN method

 *

 * @return void

 * @access public

 */

	public function testNOTIN() {

		$expected = array(1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20);

		$result = $this->Post->find('all', array(

			'conditions' => array(

				'title NOT IN' => array(10),

			),

			'fields' => array('_id', 'title', 'number'),

			'order' => array('number' => 'ASC')

		));

		$result = Hash::extract($result, '{n}.Post.title');

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



		$conditions = array(

			'title' => array('$nin' => array(10))

		);

		$this->assertEqual($conditions, $this->Post->lastQuery['conditions']);

	}



/**

 * testGTLT method

 *

 * @return void

 * @access public

 */

	public function testGTLT() {

		$expected = array(8, 9, 10, 11, 12, 13);

		$result = $this->Post->find('all', array(

			'conditions' => array(

				'title >' => 7,

				'title <' => 14,

			),

			'fields' => array('_id', 'title', 'number'),

			'order' => array('number' => 'ASC')

		));

		$result = Hash::extract($result, '{n}.Post.title');

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



		$conditions = array(

			'title' => array(

				'$gt' => 7,

				'$lt' => 14

			)

		);

		$this->assertEqual($conditions, $this->Post->lastQuery['conditions']);

	}



/**

 * testGTE method

 *

 * @return void

 * @access public

 */

	public function testGTE() {

		$expected = array(19, 20);

		$result = $this->Post->find('all', array(

			'conditions' => array(

				'title >=' => 19,

			),

			'fields' => array('_id', 'title', 'number'),

			'order' => array('number' => 'ASC')

		));

		$result = Hash::extract($result, '{n}.Post.title');

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



		$conditions = array(

			'title' => array('$gte' => 19)

		);

		$this->assertEqual($conditions, $this->Post->lastQuery['conditions']);

	}



/**

 * testOR method

 *

 * @return void

 * @access public

 */

	public function testOR() {

		$expected = array(1, 2, 19, 20);

		$result = $this->Post->find('all', array(

			'conditions' => array(

				'OR' => array(

					'title <=' => 2,

					'title >=' => 19,

				)

			),

			'fields' => array('_id', 'title', 'number'),

			'order' => array('number' => 'ASC')

		));

		$result = Hash::extract($result, '{n}.Post.title');

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



		$conditions = array(

			'$or' => array(

				array('title' => array('$lte' => 2)),

				array('title' => array('$gte' => 19))

			)

		);

		$this->assertEqual($conditions, $this->Post->lastQuery['conditions']);

	}





	/**

	 * Tests find method with conditions _id=>array()

	 *

	 * @return void

	 * @access public

	 */

	public function testFindConditionIn() {



		for ($i = 1; $i <= 5; $i++) {

			$data = array(

					'_id' => 'A1' . $i,

					'title' => $i,

					);

			$saveData['Post'] = $data;

			$this->Post->create();

			$this->Post->save($saveData);

		}



		$params = array('conditions' => array('_id' => array('A11', 'A12')));

		$result = $this->Post->find('all', $params);



		$expected = array('A11','A12');

		$result = Hash::extract($result, '{n}.Post._id');

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

		$this->assertEqual(2, count($result));



		$conditions = array(

			'_id' => array(

				'$in' => array('A11', 'A12')

			)

		);

		$this->assertEqual($conditions, $this->Post->lastQuery['conditions']);





		$params = array('conditions' => array('_id' => array('$nin' => array('A11', 'A12'))));

		$result = $this->Post->find('all', $params);

		//$expected = array('A13','A14');

		$result = Hash::extract($result, '{n}.Post._id');

		$this->assertTrue(in_array('A13', $result));

		$this->assertFalse(in_array('A11', $result));

		$this->assertFalse(in_array('A12', $result));

		$this->assertEqual(23, count($result));





		$conditions = array(

			'_id' => array(

				'$nin' => array('A11', 'A12')

			)

		);

		$this->assertEqual($conditions, $this->Post->lastQuery['conditions']);

	}





/**

 * Order method

 *

 * @return void

 * @access public

 */

	public function testOrderDESC() {

		$expected = array(20, 19);

		$result = $this->Post->find('all', array(

			'conditions' => array('title >' => 18),

			'fields' => array('_id', 'title'),

			'order' => array('title DESC')

		));

		$result = Hash::extract($result, '{n}.Post.title');

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



		$order = array(array('title' => 'DESC'));

		$this->assertEqual($order, $this->Post->lastQuery['order']);

	}



/**

 * Order method

 *

 * @return void

 * @access public

 */

	public function testOrderASC() {

		$expected = array(19, 20);

		$result = $this->Post->find('all', array(

			'conditions' => array('title >' => 18),

			'fields' => array('_id', 'title'),

			'order' => array('title ASC')

		));

		$result = Hash::extract($result, '{n}.Post.title');

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



		$order = array(array('title' => 'ASC'));

		$this->assertEqual($order, $this->Post->lastQuery['order']);

	}





/**

 * Order method with model alias

 *

 * @return void

 * @access public

 */

	public function testOrderWithModelAlias() {

		$expected = array(20, 19);

		$result = $this->Post->find('all', array(

			'conditions' => array('title >' => 18),

			'fields' => array('_id', 'title'),

			'order' => array('Post.title DESC')

		));

		$result = Hash::extract($result, '{n}.Post.title');

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

	}



/**

 * Convert MongoDate objects to strings

 *

 * @return void

 * @access public

 */

	public function testConvertDates() {

		$expected = '2011-Nov-22 00:00:00';

		$data = array('title' => 'date', 'created_at' => new MongoDate(strtotime('2011-11-22 00:00:00')));

		$this->Post->save($data);

		$result = $this->Post->read();

		$this->assertEqual($expected, $result['Post']['created_at']);

	}



/**

 * Convert MongoDate objects to another format strings

 *

 * @return void

 * @access public

 */

	public function testConvertDatesAnotherFormat() {

		$this->Post->Behaviors->detach('SqlCompatible');

		$this->Post->Behaviors->attach('Mongodb.SqlCompatible', array('dateFormat' => 'Y-m-d H:i:s'));



		$expected = '2011-11-22 00:00:00';

		$data = array('title' => 'date', 'created_at' => new MongoDate(strtotime('2011-11-22 00:00:00')));

		$this->Post->save($data);

		$result = $this->Post->read();

		$this->assertEqual($expected, $result['Post']['created_at']);

	}



/**

 * setupData method

 *

 * @return void

 * @access protected

 */

	protected function _setupData() {

		$this->Post->deleteAll(true, false);

		$this->Post->primaryKey = '_id';



		for ($i = 1; $i <= 20; $i++) {

			$data = array(

				'title' => $i,

			);

			$saveData['Post'] = $data;

			$this->Post->create();

			$this->Post->save($saveData);

		}

	}

}