cakephp/tests/TestCase/Database/FunctionsBuilderTest.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;

use Cake\Database\FunctionsBuilder;
use Cake\Database\ValueBinder;

/**
 * Tests FunctionsBuilder class
 *
 */
class FunctionsBuilderTest extends \Cake\TestSuite\TestCase {

/**
 * Setups a mock for FunctionsBuilder
 *
 * @return void
 */
	public function setUp() {
		parent::setUp();
		$this->functions = new FunctionsBuilder;
	}

/**
 * Tests generating a generic function call
 *
 * @return void
 */
	public function testArbitrary() {
		$function = $this->functions->MyFunc(['b' => 'literal']);
		$this->assertInstanceOf('\Cake\Database\Expression\FunctionExpression', $function);
		$this->assertEquals('MyFunc', $function->name());
		$this->assertEquals('MyFunc(b)', $function->sql(new ValueBinder));
	}

/**
 * Tests generating a SUM() function
 *
 * @return void
 */
	public function testSum() {
		$function = $this->functions->sum('total');
		$this->assertInstanceOf('\Cake\Database\Expression\FunctionExpression', $function);
		$this->assertEquals('SUM(total)', $function->sql(new ValueBinder));
	}

/**
 * Tests generating a AVG() function
 *
 * @return void
 */
	public function testAvg() {
		$function = $this->functions->avg('salary');
		$this->assertInstanceOf('\Cake\Database\Expression\FunctionExpression', $function);
		$this->assertEquals('AVG(salary)', $function->sql(new ValueBinder));
	}

/**
 * Tests generating a MAX() function
 *
 * @return void
 */
	public function testMAX() {
		$function = $this->functions->max('created');
		$this->assertInstanceOf('\Cake\Database\Expression\FunctionExpression', $function);
		$this->assertEquals('MAX(created)', $function->sql(new ValueBinder));
	}

/**
 * Tests generating a MIN() function
 *
 * @return void
 */
	public function testMin() {
		$function = $this->functions->min('created');
		$this->assertInstanceOf('\Cake\Database\Expression\FunctionExpression', $function);
		$this->assertEquals('MIN(created)', $function->sql(new ValueBinder));
	}

/**
 * Tests generating a COUNT() function
 *
 * @return void
 */
	public function testCount() {
		$function = $this->functions->count('*');
		$this->assertInstanceOf('\Cake\Database\Expression\FunctionExpression', $function);
		$this->assertEquals('COUNT(*)', $function->sql(new ValueBinder));
	}

/**
 * Tests generating a CONCAT() function
 *
 * @return void
 */
	public function testConcat() {
		$function = $this->functions->concat(['title' => 'literal', ' is a string']);
		$this->assertInstanceOf('\Cake\Database\Expression\FunctionExpression', $function);
		$this->assertEquals("CONCAT(title, :c0)", $function->sql(new ValueBinder));
	}

/**
 * Tests generating a COALESCE() function
 *
 * @return void
 */
	public function testCoalesce() {
		$function = $this->functions->coalesce(['NULL' => 'literal', '1', '2']);
		$this->assertInstanceOf('\Cake\Database\Expression\FunctionExpression', $function);
		$this->assertEquals("COALESCE(NULL, :c0, :c1)", $function->sql(new ValueBinder));
	}

/**
 * Tests generating a NOW(), CURRENT_TIME() and CURRENT_DATE() function
 *
 * @return void
 */
	public function testNow() {
		$function = $this->functions->now();
		$this->assertInstanceOf('\Cake\Database\Expression\FunctionExpression', $function);
		$this->assertEquals("NOW()", $function->sql(new ValueBinder));

		$function = $this->functions->now('date');
		$this->assertInstanceOf('\Cake\Database\Expression\FunctionExpression', $function);
		$this->assertEquals("CURRENT_DATE()", $function->sql(new ValueBinder));

		$function = $this->functions->now('time');
		$this->assertInstanceOf('\Cake\Database\Expression\FunctionExpression', $function);
		$this->assertEquals("CURRENT_TIME()", $function->sql(new ValueBinder));
	}
}