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

doctrine query builder comparison objects

Add Answer

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

answer doctrine query builder comparison objects

related doctrine query builder conditional objects

related doctrine query builder function objects

doctrine query builder comparison objects

Comment

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

    // Example - $qb->expr()->eq('u.id', '?1') => u.id = ?1
    public function eq($x, $y); // Returns Expr\Comparison instance

    // Example - $qb->expr()->neq('u.id', '?1') => u.id <> ?1
    public function neq($x, $y); // Returns Expr\Comparison instance

    // Example - $qb->expr()->lt('u.id', '?1') => u.id < ?1
    public function lt($x, $y); // Returns Expr\Comparison instance

    // Example - $qb->expr()->lte('u.id', '?1') => u.id <= ?1
    public function lte($x, $y); // Returns Expr\Comparison instance

    // Example - $qb->expr()->gt('u.id', '?1') => u.id > ?1
    public function gt($x, $y); // Returns Expr\Comparison instance

    // Example - $qb->expr()->gte('u.id', '?1') => u.id >= ?1
    public function gte($x, $y); // Returns Expr\Comparison instance

    // Example - $qb->expr()->isNull('u.id') => u.id IS NULL
    public function isNull($x); // Returns string

    // Example - $qb->expr()->isNotNull('u.id') => u.id IS NOT NULL
    public function isNotNull($x); // Returns string

    // Example - $qb->expr()->isMemberOf('?1', 'u.groups') => ?1 MEMBER OF u.groups
    public function isMemberOf($x, $y); // Returns Expr\Comparison instance

    // Example - $qb->expr()->isInstanceOf('u', Employee::class) => u INSTANCE OF Employee
    public function isInstanceOf($x, $y); // Returns Expr\Comparison instance
}

Popularity 3/10 Helpfulness 4/10 Language php

Source: www.doctrine-project.org

Tags: comparison 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 conditional objects

Comment

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

    // Example - $qb->expr()->andX($cond1 [, $condN])->add(...)->...
    public function andX($x = null); // Returns Expr\AndX instance

    // Example - $qb->expr()->orX($cond1 [, $condN])->add(...)->...
    public function orX($x = null); // Returns Expr\OrX instance
}

Popularity 1/10 Helpfulness 3/10 Language php

Source: www.doctrine-project.org

Tags: conditional php

Link to this answer
Share Copy Link

Contributed on Mar 04 2023

Murat Cakmak

0 Answers Avg Quality 2/10

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 comparison objects

Contents

More Related Answers

doctrine query builder comparison objects

Closely Related Answers

doctrine query builder conditional objects

doctrine query builder function objects

Grepper

Documentation

Social

Legal

Contact

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