cakephp/tests/TestCase/Database/Expression/CaseExpressionTest.php

<?php
/**
 * 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 Open Group Test Suite License
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright     Copyright 2005-2013, Cake Software Foundation, Inc. (http://cakefoundation.org)
 * @link          http://book.cakephp.org/2.0/en/development/testing.html CakePHP(tm) Tests
 * @since         3.0.0
 * @license       http://www.opensource.org/licenses/mit-license.php MIT License
 */
namespace Cake\Test\TestCase\Database\Expression;

use Cake\Database\Expression\QueryExpression;
use Cake\Database\ValueBinder;
use Cake\TestSuite\TestCase;
use Cake\Database\Expression\CaseExpression;

/**
 * Tests CaseExpression class
 */
class CaseExpressionTest extends TestCase {

/**
 * Test that the sql output works correctly
 *
 * @return void
 */
	public function testSqlOutput() {
		$expr = new QueryExpression();
		$expr->eq('test', 'true');
		$caseExpression = new CaseExpression($expr);

		$this->assertInstanceOf('Cake\Database\ExpressionInterface', $caseExpression);
		$expected = 'CASE WHEN test = :c0 THEN 1 ELSE 0 END';
		$this->assertSame($expected, $caseExpression->sql(new ValueBinder()));
	}

/**
 * Test that we can pass in things as the isTrue/isFalse part
 *
 * @return void
 */
	public function testSetTrue() {
		$expr = new QueryExpression();
		$expr->eq('test', 'true');
		$caseExpression = new CaseExpression($expr);
		$expr2 = new QueryExpression();

		$caseExpression->isTrue($expr2);
		$this->assertSame($expr2, $caseExpression->isTrue());

		$caseExpression->isTrue('test_string');
		$this->assertSame(['value' => 'test_string', 'type' => null], $caseExpression->isTrue());

		$caseExpression->isTrue(['test_string' => 'literal']);
		$this->assertSame('test_string', $caseExpression->isTrue());
	}

/**
 * Test that things are compiled correctly
 *
 * @return void
 */
	public function testSqlCompiler() {
		$expr = new QueryExpression();
		$expr->eq('test', 'true');
		$caseExpression = new CaseExpression($expr);
		$expr2 = new QueryExpression();
		$expr2->eq('test', 'false');

		$caseExpression->isTrue($expr2);
		$this->assertSame('CASE WHEN test = :c0 THEN test = :c1 ELSE 0 END', $caseExpression->sql(new ValueBinder()));

		$caseExpression->isTrue('test_string');
		$this->assertSame('CASE WHEN test = :c0 THEN :c1 ELSE 0 END', $caseExpression->sql(new ValueBinder()));

		$caseExpression->isTrue(['test_string' => 'literal']);
		$this->assertSame('CASE WHEN test = :c0 THEN test_string ELSE 0 END', $caseExpression->sql(new ValueBinder()));
	}

/**
 * Tests that the expression is correctly traversed
 *
 * @return void
 */
	public function testTraverse() {
		$count = 0;
		$visitor = function() use (&$count) {
			$count++;
		};

		$expr = new QueryExpression();
		$expr->eq('test', 'true');
		$caseExpression = new CaseExpression($expr);
		$caseExpression->traverse($visitor);
		$this->assertSame(2, $count);
	}
}