Breaking News: Grepper is joining You.com. Read the official announcement!

doctrine query builder arithmetic objects

Murat Cakmak answered on March 4, 2023 Popularity 7/10 Helpfulness 2/10

answer doctrine query builder arithmetic objects

related doctrine query builder function objects

doctrine query builder arithmetic objects

Comment

<?php
class Expr
{
    /** Arithmetic objects **/

    // Example - $qb->expr()->prod('u.id', '2') => u.id * 2
    public function prod($x, $y); // Returns Expr\Math instance

    // Example - $qb->expr()->diff('u.id', '2') => u.id - 2
    public function diff($x, $y); // Returns Expr\Math instance

    // Example - $qb->expr()->sum('u.id', '2') => u.id + 2
    public function sum($x, $y); // Returns Expr\Math instance

    // Example - $qb->expr()->quot('u.id', '2') => u.id / 2
    public function quot($x, $y); // Returns Expr\Math instance
}

Popularity 7/10 Helpfulness 2/10 Language php

Source: www.doctrine-project.org

Tags: php

Link to this answer
Share Copy Link

Contributed on Mar 04 2023

Murat Cakmak

0 Answers Avg Quality 2/10

Closely Related Answers

doctrine query builder function objects

Comment

<?php
class Expr
{
    /** Function objects **/

    // Example - $qb->expr()->trim('u.firstname')
    public function trim($x); // Returns Expr\Func

    // Example - $qb->expr()->concat('u.firstname', $qb->expr()->concat($qb->expr()->literal(' '), 'u.lastname'))
    public function concat($x, $y); // Returns Expr\Func

    // Example - $qb->expr()->substring('u.firstname', 0, 1)
    public function substring($x, $from, $len); // Returns Expr\Func

    // Example - $qb->expr()->lower('u.firstname')
    public function lower($x); // Returns Expr\Func

    // Example - $qb->expr()->upper('u.firstname')
    public function upper($x); // Returns Expr\Func

    // Example - $qb->expr()->length('u.firstname')
    public function length($x); // Returns Expr\Func

    // Example - $qb->expr()->avg('u.age')
    public function avg($x); // Returns Expr\Func

    // Example - $qb->expr()->max('u.age')
    public function max($x); // Returns Expr\Func

    // Example - $qb->expr()->min('u.age')
    public function min($x); // Returns Expr\Func

    // Example - $qb->expr()->abs('u.currentBalance')
    public function abs($x); // Returns Expr\Func

    // Example - $qb->expr()->sqrt('u.currentBalance')
    public function sqrt($x); // Returns Expr\Func

    // Example - $qb->expr()->mod('u.currentBalance', '10')
    public function mod($x); // Returns Expr\Func

    // Example - $qb->expr()->count('u.firstname')
    public function count($x); // Returns Expr\Func

    // Example - $qb->expr()->countDistinct('u.surname')
    public function countDistinct($x); // Returns Expr\Func
}

Popularity 8/10 Helpfulness 1/10 Language php

Source: www.doctrine-project.org

Tags: php

Link to this answer
Share Copy Link

Contributed on Mar 04 2023

Murat Cakmak

0 Answers Avg Quality 2/10

doctrine query builder arithmetic objects

Contents

More Related Answers

doctrine query builder arithmetic objects

Closely Related Answers

doctrine query builder function objects

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.