Doctrine\DBAL\Query\Expression\ExpressionBuilder
ExpressionBuilder class is responsible to dynamically create SQL query parts.
- Author: Guilherme Blanco <guilhermeblanco@hotmail.com>
- License: http://www.opensource.org/licenses/lgpl-license.php LGPL
Synopsis
class ExpressionBuilder
{
- // constants
- const EQ = '=';
- const NEQ = '<>';
- const LT = '<';
- const LTE = '<=';
- const GT = '>';
- const GTE = '>=';
- // members
- private Connection $connection;
- // methods
- public void __construct()
- public CompositeExpression andX()
- public CompositeExpression orX()
- public string comparison()
- public string eq()
- public string neq()
- public string lt()
- public string lte()
- public string gt()
- public string gte()
- public string isNull()
- public string isNotNull()
- public string like()
- public string literal()
Constants
Name | Value |
---|---|
EQ | '=' |
NEQ | '<>' |
LT | '<' |
LTE | '<=' |
GT | '>' |
GTE | '>=' |
Members
private
- $connection — Doctrine\DBAL\Query\Expression\Doctrine\DBAL\Connection
Methods
public
- __construct() — Initializes a new <tt>ExpressionBuilder</tt>.
- andX() — Creates a conjunction of the given boolean expressions.
- comparison() — Creates a comparison expression.
- eq() — Creates an equality comparison expression with the given arguments.
- gt() — Creates a greater-than comparison expression with the given arguments.
- gte() — Creates a greater-than-equal comparison 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.
- like() — Creates a LIKE() comparison expression with the given arguments.
- literal() — Quotes a given input parameter.
- lt() — Creates a lower-than comparison expression with the given arguments.
- lte() — Creates a lower-than-equal comparison expression with the given arguments.
- neq() — Creates a non equality comparison expression with the given arguments.
- orX() — Creates a disjunction of the given boolean expressions.