Symfony2 SoftDeleteable无法在QueryBuilder上删除 [英] Symfony2 SoftDeleteable not working on QueryBuilder Delete
问题描述
在通过实体管理器执行delete语句时,Softdelete行为可以正常工作,如下所示:
Softdelete behavior works fine on execute delete statement via the entity manager as the following code:
$entity = $this->em->getRepository('Users')->find(7);
$this->em->remove($entity);
$this->em->flush();
但是当通过QueryBuilder执行相同的功能时,硬删除将在数据库上执行
but when execute the same functionality via QueryBuilder hard delete will execute on database
$qb = $this->em->createQueryBuilder();
$qb->delete('Users', 'p');
$qb->where($qb->expr()->eq('p.id', ':id'));
$qb->setParameters(array("id" => 7));
$result = $qb->getQuery()->getResult();
在所有情况下,如何通过实体管理器或查询生成器允许软删除
How can I allow softdelete in all cases either via entity manager or query builder
推荐答案
如果使用DQL,则必须使用查询提示.这应该可以解决问题:
If you use DQL then you have to use a Query Hint. This should do the trick:
$query = $qb->getQuery()
$query->setHint(
\Doctrine\ORM\Query::HINT_CUSTOM_OUTPUT_WALKER,
'Gedmo\SoftDeleteable\Query\TreeWalker\SoftDeleteableWalker'
);
$result = $query->getResult();
更新:
文档提到您必须使用查询提示,但没有提供示例,因此我从他们的测试中删除了用法.
The docs mention that you have to use a Query Hint but don't provide an example so I pulled the usage from their tests.
文档: https://github.com/l3pp4rd/DoctrineExtensions/blob/master/doc/softdeleteable.md
这篇关于Symfony2 SoftDeleteable无法在QueryBuilder上删除的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!