Nextcloud PHP API (master)

IExpressionBuilder

in

• Application

This class provides a wrapper around Doctrine's ExpressionBuilder

Tags

since

8.2.0

psalm-taint-specialize

Table of Contents

Constants

EQ  = \Doctrine\DBAL\Query\Expression\ExpressionBuilder::EQ

GT  = \Doctrine\DBAL\Query\Expression\ExpressionBuilder::GT

GTE  = \Doctrine\DBAL\Query\Expression\ExpressionBuilder::GTE

LT  = \Doctrine\DBAL\Query\Expression\ExpressionBuilder::LT

LTE  = \Doctrine\DBAL\Query\Expression\ExpressionBuilder::LTE

NEQ  = \Doctrine\DBAL\Query\Expression\ExpressionBuilder::NEQ

Methods

andX()  : ICompositeExpression

Creates a conjunction of the given boolean expressions.

bitwiseAnd()  : IQueryFunction

Creates a bitwise AND comparison

bitwiseOr()  : IQueryFunction

Creates a bitwise OR comparison

castColumn()  : IQueryFunction

Returns a IQueryFunction that casts the column to the given type

comparison()  : string

Creates a comparison expression.

emptyString()  : string

Creates a $x = '' statement, because Oracle needs a different check

eq()  : string

Creates an equality comparison expression with the given arguments.

gt()  : string

Creates a greater-than comparison expression with the given arguments.

gte()  : string

Creates a greater-than-equal comparison expression with the given arguments.

iLike()  : string

Creates a ILIKE() comparison expression with the given arguments.

in()  : string

Creates a IN () comparison expression with the given arguments.

isNotNull()  : string

Creates an IS NOT NULL expression with the given arguments.

isNull()  : string

Creates an IS NULL expression with the given arguments.

like()  : string

Creates a LIKE() comparison expression with the given arguments.

literal()  : ILiteral

Quotes a given input parameter.

lt()  : string

Creates a lower-than comparison expression with the given arguments.

lte()  : string

Creates a lower-than-equal comparison expression with the given arguments.

neq()  : string

Creates a non equality comparison expression with the given arguments.

nonEmptyString()  : string

Creates a `$x <> ''` statement, because Oracle needs a different check

notIn()  : string

Creates a NOT IN () comparison expression with the given arguments.

notLike()  : string

Creates a NOT LIKE() comparison expression with the given arguments.

orX()  : ICompositeExpression

Creates a disjunction of the given boolean expressions.

[php]
// u.id = ?
$expr->eq('u.id', '?');

[php]
// u.id > ?
$q->where($q->expr()->gt('u.id', '?'));

[php]
// u.id >= ?
$q->where($q->expr()->gte('u.id', '?'));

[php]
// u.id < ?
$q->where($q->expr()->lt('u.id', '?'));

[php]
// u.id <= ?
$q->where($q->expr()->lte('u.id', '?'));

[php]
// u.id <> 1
$q->where($q->expr()->neq('u.id', '1'));