Example:
$qb = $em->createQueryBuilder();
$expr = $em->getExpressionBuilder();
$qb->select('u')->from('User', 'u')
->where($expr->orX($expr->eq('u.id', 1), $expr->eq('u.id', 2)));
| public getExpressionBuilder ( ) : ExpressionBuilder | ||
| Résultat | ExpressionBuilder | |
/**
* get DQL expression for id value
*
* @param integer|string $id
* @param EntityManager $em
* @return string
*/
private function getIdExpression($id, EntityManager $em)
{
if (is_string($id)) {
$id = $em->getExpressionBuilder()->literal($id);
}
if ($id === null) {
$id = 'NULL';
}
return (string) $id;
}
/**
* Gets an ExpressionBuilder used for object-oriented construction of query expressions.
* Intended for convenient inline usage. Example:
*
* [php]
* $qb = $em->createQueryBuilder()
* ->select('u')
* ->from('User', 'u')
* ->where($qb->expr()->eq('u.id', 1));
*
* @return Expr
*/
public function expr()
{
return $this->_em->getExpressionBuilder();
}
/**
* {@inheritDoc}
*
* @static
*/
public static function getExpressionBuilder()
{
return \Doctrine\ORM\EntityManager::getExpressionBuilder();
}
/**
* @group DDC-1211
*/
public function testEmptyNumericLiteral()
{
$expr = $this->_em->getExpressionBuilder();
$qb = $this->_em->createQueryBuilder()->select('u')->from('Doctrine\\Tests\\Models\\CMS\\CmsUser', 'u')->where($expr->eq('u.username', $expr->literal(0)));
$this->assertEquals('SELECT u FROM Doctrine\\Tests\\Models\\CMS\\CmsUser u WHERE u.username = 0', $qb->getDQL());
}
/**
* {@inheritdoc}
*/
public function getExpressionBuilder()
{
return $this->wrapped->getExpressionBuilder();
}
