doctrine / orm

     *

     * @return string The SQL.

     */

    public function walkGeneralCaseExpression(AST\GeneralCaseExpression $generalCaseExpression)

    {

        $sql = 'CASE';

        foreach ($generalCaseExpression->whenClauses as $whenClause) {

            $sql .= ' WHEN ' . $this->walkConditionalExpression($whenClause->caseConditionExpression);

            $sql .= ' THEN ' . $this->walkSimpleArithmeticExpression($whenClause->thenScalarExpression);

        }

        $sql .= ' ELSE ' . $this->walkSimpleArithmeticExpression($generalCaseExpression->elseScalarExpression) . ' END';

        return $sql;

    }

    /**

     * Walks down a SimpleCaseExpression AST node and generates the corresponding SQL.

     *

     * @return string The SQL.

     */

    public function walkSimpleCaseExpression($simpleCaseExpression)

    {

        $sql = 'CASE ' . $this->walkStateFieldPathExpression($simpleCaseExpression->caseOperand);

        foreach ($simpleCaseExpression->simpleWhenClauses as $simpleWhenClause) {

            $sql .= ' WHEN ' . $this->walkSimpleArithmeticExpression($simpleWhenClause->caseScalarExpression);

            $sql .= ' THEN ' . $this->walkSimpleArithmeticExpression($simpleWhenClause->thenScalarExpression);

        }

        $sql .= ' ELSE ' . $this->walkSimpleArithmeticExpression($simpleCaseExpression->elseScalarExpression) . ' END';

        return $sql;

    }

    /**

     * {@inheritdoc}