PHP Doctrine SoftDelete - Include deleted records?

Question

If I have one of my PHP Doctrine objects act as a SoftDelete, is it possible to include deleted items in the results of certain queries? What I'm looking for is something like this...

$q = Doctrine_Query::create()
    ->select('*')
    ->from('Test t')
    ->where('id < ?', 25)
    *->includeDeleted()*;

Something like this would be useful as for most queries I want deleted records excluded, but sometimes (for example, to administrators) I want to be able to include records that have been soft deleted. Is there some good way to do this with SoftDelete or should I simply add an additional where clause onto most queries?

score 4 · Answer 1 · answered Jan 29 '17 at 09:48

Looks like you may disable soft-deleteable filter http://atlantic18.github.io/DoctrineExtensions/doc/softdeleteable.html

// This will disable the SoftDeleteable filter, so entities which were "soft-deleted" will appear in results $em->getFilters()->disable('soft-deleteable');

factorlabs · Answer 2 · 2011-07-14T10:36:56.953

4

It returns all records from table (include softDeleted)

public function findAllWithDeleted()
{
    $query = $this->createQuery('a');
    $query->addWhere('(a.deleted_at IS NULL OR a.deleted_at IS NOT NULL)');
    return $query->execute();
}

edited Jul 14 '11 at 10:36

answered Jul 14 '11 at 10:30

factorlabs

41
3

life saver!! Cant believe they wrote like billion lines of code without giving this as an option! – Raheel Hasan Jun 22 '22 at 05:40

score 2 · Accepted Answer · answered Sep 01 '09 at 21:29

From a cursory glance at the source here and here, this functionality does not seem to provided by the SoftDelete behaviour. You have to add a where clause manually like you suggest.

(I may be wrong, but I'm pretty sure Doctrine_Query can not be extended dynamically by way of a behaviour like you can with Doctrine_Record. You could always write a special Doctrine_Query subclass which adds includeDeleted(), but that seems like more thouble than it's worth :) )

score 2 · Answer 4 · edited Nov 12 '12 at 05:32

2

$manager = Doctrine_Manager::getInstance();
$manager->setAttribute(Doctrine_Core::ATTR_USE_DQL_CALLBACKS, false);

After this you can select, update, delete data like softDelete is off.

edited Nov 12 '12 at 05:32

Jason Sturges

15,855
14
59
80

answered Sep 12 '11 at 06:33

unlexx

21
1

score 1 · Answer 5 · edited Dec 17 '10 at 08:44

1

We had a bug in Doctrine 1.2.2 where ATTR_USE_DQL_CALLBACKS was ignored AND the softdelete column had the wrong name. The solution is to overwrite the listener:

$m = new MyModel;
$m->setListener(new MockListener());
$m->getTable()->getQueryObject(); //... and so forth

with a dummy class:

class MockListener implements Doctrine_Overloadable
{
    public function __call($m, $a){}
}

edited Dec 17 '10 at 08:44

Jeff Atwood

63,320
48
150
153

answered Aug 17 '10 at 13:25

Daniel Pozzi

11
2

PHP Doctrine SoftDelete - Include deleted records?

5 Answers5