CODEWITHSUNDEEP
phpsymfonydoctrine-orm
Dezigo
Dezigo

Reputation: 3256

Symfony2 ,doctrine custom DQL function

I've created a custom 'REPLACE' function in Doctrine. But I have an error ,when I use it.

$result->andWhere("replace(weight,X,C) <= :weight_from")
       ->setParameter('weight_from',$data['weight_from']);

Replace function:

namespace Doctrine\ORM\Query\AST\Functions;

use Doctrine\ORM\Query\Lexer;

/**
 * "REPLACE" "(" StringPrimary "," StringSecondary "," StringThird ")"
 *
 * 
 * @link    www.prohoney.com
 * @since   2.0
 * @author  Igor Aleksejev
 */
class ReplaceFunction extends FunctionNode {

    public $stringPrimary;
    public $stringSecondary;
    public $stringThird;

    /**
     * @override
     */
    public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker) {
        return $sqlWalker->getConnection()->getDatabasePlatform()->getReplaceExpression(
                        $this->stringPrimary, $this->stringSecondary, $this->stringThird
        );
    }

    /**
     * @override
     */
    public function parse(\Doctrine\ORM\Query\Parser $parser) {
        $parser->match(Lexer::T_IDENTIFIER);
        $parser->match(Lexer::T_OPEN_PARENTHESIS);
        $this->stringPrimary = $parser->StringPrimary();
        $parser->match(Lexer::T_COMMA);
        $this->stringSecondary = $parser->StringPrimary();
        $parser->match(Lexer::T_COMMA);
        $this->stringThird = $parser->StringPrimary();
        $parser->match(Lexer::T_CLOSE_PARENTHESIS);
    }

}

AbstracPlatfrom.php contains:

/**
 * Returns the replace of a text field.
 *
 * @param string $column
 * @param string $x
 * @param string $y
 *
 * @return string
 */
public function getReplaceExpression($column,$x,$y)
{
    return "REPLACE($column,'$x','$y')";
}

Error:

[
   {
      "message":"[Syntax Error] line 0, col 103: Error: Expected '.' or '(', got 'weight'",
      "class":"Doctrine\\ORM\\Query\\QueryException",
      "trace":[
         {
            "namespace":"",
            "short_class":"",
            "class":"",
            "type":"",
            "function":"",
            "file":"C:\\webserver\\symfony\\vendor\\doctrine\\orm\\lib\\Doctrine\\ORM\\Query\\QueryException.php",
            "line":44,
            "args":[

            ]
         },
         {
            "namespace":"Doctrine\\ORM\\Query",
            "short_class":"QueryException",
            "class":"Doctrine\\ORM\\Query\\QueryException",
            "type":"::",
            "function":"syntaxError",
            // ...

Upvotes: 2

Views: 2510

Answers (1)

Ivonne Belz
Ivonne Belz

Reputation: 31

I had a similar issue and I suppose that you just should add a prefix to your table field "weight" (e.g. "a."): 

$result->andWhere("replace(a.weight,X,C) <= :weight_from")
   ->setParameter('weight_from',$data['weight_from']);

Upvotes: 2

Related Questions