php - 将 MySQL 查询转换为 Symfony Doctrine

Question

我有这个 MySQL 查询，我想将其转换为 Doctrine 理解的查询。

SELECT name from users where project = 10 and (classification = 12 
or classification is null)

所以我尝试在 Doctrine 中转换它，但它不起作用。

$query->AndWhere('users.classification = :classification');
$query->setParameter(':classification', $classification);
$query->orWhere('users.classification = :classification');
$query->setParameter(':classification', null);

我尝试使用表达式$query->expr()我没有成功

Answer 1

要将多个 where 语句分组在括号中，您可以使用 orx 和 andx

$queryBuilder->andWhere($queryBuilder->expr()->orX(
    'users.classification = :classification',
    'users.classification IS NULL'
))
->setParameter(':classification', $classification);

或者用 Doctrine 表达:

$queryBuilder->andWhere($queryBuilder->expr()->orX(
    $queryBuilder->expr()->eq('user.classification', ':classification'),
    $queryBuilder->expr()->isNull('users.classification')
))
->setParameter(':classification', $classification);

Doctrine 文档:https://www.doctrine-project.org/projects/doctrine-orm/en/2.6/reference/query-builder.html#the-expr-class