ModelsDynamicOperationsTest.php

<?php

/*
  +------------------------------------------------------------------------+
  | Phalcon Framework                                                      |
  +------------------------------------------------------------------------+
  | Copyright (c) 2011-2012 Phalcon Team (http://www.phalconphp.com)       |
  +------------------------------------------------------------------------+
  | This source file is subject to the New BSD License that is bundled     |
  | with this package in the file docs/LICENSE.txt.                        |
  |                                                                        |
  | If you did not receive a copy of the license and are unable to         |
  | obtain it through the world-wide-web, please send an email             |
  | to license@phalconphp.com so we can send you a copy immediately.       |
  +------------------------------------------------------------------------+
  | Authors: Andres Gutierrez <andres@phalconphp.com>                      |
  |          Eduar Carvajal <eduar@phalconphp.com>                         |
  +------------------------------------------------------------------------+
*/

class ModelsDynamicOperationsTest extends PHPUnit\Framework\TestCase
{

	public function setUp()
	{
		spl_autoload_register(array($this, 'modelsAutoloader'));
	}

	public function tearDown()
	{
		spl_autoload_unregister(array($this, 'modelsAutoloader'));
	}

	public function modelsAutoloader($className)
	{
		$className = str_replace('\\', '/', $className);
		if (file_exists('unit-tests/models/' . $className . '.php')) {
			require 'unit-tests/models/' . $className . '.php';
		}
	}

	protected function _getDI()
	{

		Phalcon\Di::reset();

		$di = new Phalcon\Di();

		$di->set('modelsManager', function(){
			return new Phalcon\Mvc\Model\Manager();
		}, true);

		$di->set('modelsMetadata', function(){
			return new Phalcon\Mvc\Model\Metadata\Memory();
		}, true);

		$di->set('modelsQuery', 'Phalcon\Mvc\Model\Query');
		$di->set('modelsQueryBuilder', 'Phalcon\Mvc\Model\Query\Builder');
		$di->set('modelsCriteria', 'Phalcon\\Mvc\\Model\\Criteria');

		return $di;
	}

	public function testModelsMysql()
	{
		require 'unit-tests/config.db.php';
		if (empty($configMysql)) {
			$this->markTestSkipped('Test skipped');
			return;
		}

		$di = $this->_getDI();

		$tracer = array();

		$di->set('db', function() use (&$tracer) {

			require 'unit-tests/config.db.php';

			$eventsManager = new Phalcon\Events\Manager();

			$connection = new Phalcon\Db\Adapter\Pdo\Mysql($configMysql);

			$eventsManager->attach('db', function($event, $connection) use (&$tracer) {
				if ($event->getType() == 'beforeQuery'|| $event->getType() == 'beforeExecute') {
					$tracer[] = $connection->getSqlStatement();
				}
			});

			$connection->setEventsManager($eventsManager);

			return $connection;
		}, true);

		$this->_executeTestsNormal($di, $tracer);

		$tracer = array();
		$this->_executeTestsRenamed($di, $tracer);
	}

	protected function _executeTestsNormal($di, &$tracer)
	{

		$persona = Dynamic\Personas::findFirst();
		$this->assertTrue($persona->save());

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

		$persona->nombres = 'Other Name '.mt_rand(0, 150000);
		$this->assertEquals($persona->getChangedFields(), array('nombres'));
		$this->assertTrue($persona->save());

		$this->assertEquals('UPDATE `personas` SET `nombres` = :nombres WHERE `personas`.`cedula` = :pha_cedula', $tracer[3]);

		$persona->nombres = 'Other Name '.mt_rand(0, 150000);
		$persona->direccion = 'Address '.mt_rand(0, 150000);
		$this->assertEquals($persona->getChangedFields(), array('nombres', 'direccion'));
		$this->assertTrue($persona->save());

		$this->assertEquals('UPDATE `personas` SET `nombres` = :nombres, `direccion` = :direccion WHERE `personas`.`cedula` = :pha_cedula', $tracer[4]);
	}

	protected function _executeTestsRenamed($di, &$tracer)
	{
		$personer = Dynamic\Personers::findFirst();
		$this->assertTrue($personer->save());

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

		$personer->navnes = 'Other Name '.mt_rand(0, 150000);
		$this->assertEquals($personer->getChangedFields(), array('navnes'));
		$this->assertTrue($personer->save());

		$this->assertEquals('UPDATE `personas` SET `nombres` = :navnes WHERE `personas`.`cedula` = :pha_borgerId', $tracer[3]);

		$personer->navnes = 'Other Name '.mt_rand(0, 150000);
		$personer->adresse = 'Address '.mt_rand(0, 150000);
		$this->assertEquals($personer->getChangedFields(), array('navnes', 'adresse'));
		$this->assertTrue($personer->save());

		$this->assertEquals('UPDATE `personas` SET `nombres` = :navnes, `direccion` = :adresse WHERE `personas`.`cedula` = :pha_borgerId', $tracer[4]);
	}

}