Doctrine\ORM\Query\Expr
This class is used to generate DQL expressions via a set of PHP static functions
- Author: Guilherme Blanco <guilhermeblanco@hotmail.com>
Synopsis
class Expr
{
- // methods
- public Andx andX()
- public Orx orX()
- public OrderBy asc()
- public OrderBy desc()
- public Comparison eq()
- public Comparison neq()
- public Comparison lt()
- public Comparison lte()
- public Comparison gt()
- public Comparison gte()
- public Func avg()
- public Func max()
- public Func min()
- public Func count()
- public string countDistinct()
- public Func exists()
- public Func all()
- public Func some()
- public Func any()
- public Func not()
- public Func abs()
- public Math prod()
- public Math diff()
- public Math sum()
- public Math quot()
- public Func sqrt()
- public Func in()
- public Func notIn()
- public string isNull()
- public string isNotNull()
- public Comparison like()
- public Func concat()
- public Func substring()
- public Func lower()
- public Func upper()
- public Func length()
- public Literal literal()
- private string _quoteLiteral()
- public Func between()
- public Func trim()
Tasks
Line | Task |
---|---|
34+ | Rename: ExpressionBuilder |
Methods
private
- _quoteLiteral() — Quotes a literal value, if necessary, according to the DQL syntax.
public
- abs() — Creates an ABS() function expression with the given argument.
- all() — Creates an instance of ALL() function, with the given DQL Subquery.
- andX() — Creates a conjunction of the given boolean expressions.
- any() — Creates an ANY() function expression with the given DQL subquery.
- asc() — Creates an ASCending order expression.
- avg() — Creates an instance of AVG() function, with the given argument.
- between() — Creates an instance of BETWEEN() function, with the given argument.
- concat() — Creates a CONCAT() function expression with the given arguments.
- count() — Creates an instance of COUNT() function, with the given argument.
- countDistinct() — Creates an instance of COUNT(DISTINCT) function, with the given argument.
- desc() — Creates a DESCending order expression.
- diff() — Creates a difference mathematical expression with the given arguments.
- eq() — Creates an equality comparison expression with the given arguments.
- exists() — Creates an instance of EXISTS() function, with the given DQL Subquery.
- gt() — Creates an instance of Expr\Comparison, with the given arguments.
- gte() — Creates an instance of Expr\Comparison, with the given arguments.
- in() — Creates an IN() expression with the given arguments.
- isNotNull() — Creates an IS NOT NULL expression with the given arguments.
- isNull() — Creates an IS NULL expression with the given arguments.
- length() — Creates a LENGTH() function expression with the given argument.
- like() — Creates a LIKE() comparison expression with the given arguments.
- literal() — Creates a literal expression of the given argument.
- lower() — Creates a LOWER() function expression with the given argument.
- lt() — Creates an instance of Expr\Comparison, with the given arguments.
- lte() — Creates an instance of Expr\Comparison, with the given arguments.
- max() — Creates an instance of MAX() function, with the given argument.
- min() — Creates an instance of MIN() function, with the given argument.
- neq() — Creates an instance of Expr\Comparison, with the given arguments.
- not() — Creates a negation expression of the given restriction.
- notIn() — Creates a NOT IN() expression with the given arguments.
- orX() — Creates a disjunction of the given boolean expressions.
- prod() — Creates a product mathematical expression with the given arguments.
- quot() — Creates a quotient mathematical expression with the given arguments.
- some() — Creates a SOME() function expression with the given DQL subquery.
- sqrt() — Creates a SQRT() function expression with the given argument.
- substring() — Creates a SUBSTRING() function expression with the given arguments.
- sum() — Creates a sum mathematical expression with the given arguments.
- trim() — Creates an instance of TRIM() function, with the given argument.
- upper() — Creates an UPPER() function expression with the given argument.