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 | ||
return | 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(); }