Skip to content

Instantly share code, notes, and snippets.

@smottt
Created January 16, 2012 15:14
Show Gist options
  • Save smottt/1621306 to your computer and use it in GitHub Desktop.
Save smottt/1621306 to your computer and use it in GitHub Desktop.
<?php
/**
* DoctrineExtensions Mysql Function Pack
*
* LICENSE
*
* This source file is subject to the new BSD license that is bundled
* with this package in the file 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 [email protected] so I can send you a copy immediately.
*/
namespace DoctrineExtensions\Query\Mysql;
use Doctrine\ORM\Query\AST\Functions\FunctionNode,
Doctrine\ORM\Query\Lexer;
/**
* "CHAR_LENGTH" "(" SimpleArithmeticExpression ")"
*
* @category DoctrineExtensions
* @package DoctrineExtensions\Query\Mysql
* @author Metod <[email protected]>
* @license BSD License
*/
class CharLength extends FunctionNode
{
private $expr;
/**
* @override
*/
public function parse(\Doctrine\ORM\Query\Parser $parser)
{
$parser->match(Lexer::T_IDENTIFIER);
$parser->match(Lexer::T_OPEN_PARENTHESIS);
$this->expr1 = $parser->ArithmeticExpression();
$parser->match(Lexer::T_CLOSE_PARENTHESIS);
}
/**
* @override
*/
public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker)
{
return 'CHAR_LENGTH('.$sqlWalker->walkArithmeticPrimary($this->expr1).')';
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment