Symfony2 SoftDeleteable not working on QueryBuilder Delete

Question

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

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

score 12 · Accepted Answer · answered Jul 16 '13 at 19:47

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

Update:

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.

Docs: https://github.com/l3pp4rd/DoctrineExtensions/blob/master/doc/softdeleteable.md

Test Usage: https://github.com/l3pp4rd/DoctrineExtensions/blob/master/tests/Gedmo/SoftDeleteable/SoftDeleteableEntityTest.php

Thank you so much dear ,, I have solved them by edit code inside the library .. but this way is more professional and up to standard — HMagdy, Jul 29 '13 at 15:41

score 0 · Answer 2 · answered Jul 29 '13 at 15:55

my old solution after previous answer by @Ken Hannel is:

Edit: /vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php

Replace walkDeleteClause function as the following:

 public function walkDeleteClause(AST\DeleteClause $deleteClause)
    {
        $class = $this->em->getClassMetadata($deleteClause->abstractSchemaName);
        $tableName = $class->getTableName();
        $sql = 'DELETE FROM ' . $this->quoteStrategy->getTableName($class, $this->platform);
        $this->setSQLTableAlias($tableName, $tableName, $deleteClause->aliasIdentificationVariable);
        $this->rootAliases[] = $deleteClause->aliasIdentificationVariable;
        //check if SoftDeleteableListener is attached 
        foreach ($this->em->getEventManager()->getListeners() as $eventName => $listeners) {
            foreach ($listeners as $listener) {
                if ($listener instanceof \Gedmo\SoftDeleteable\SoftDeleteableListener) {
                    $date = date('Y-m-d H:i:s');
                $sql = 'UPDATE ' . $this->quoteStrategy->getTableName($class, $this->platform) . " SET deletedAt = ' " . $date . " ' ";
                }
            }
        }
        return $sql;
    }

but really but I think Ken Hannel way is more professional and up to standard.

Symfony2 SoftDeleteable not working on QueryBuilder Delete

2 Answers2

Linked

Related