phalcon softDelete : how to find

Question

phalcon softDelete : how to find

cullsin Feb '19

Created Feb '19	Last Reply Feb '19	Replies 1	Views 329	Votes 0

cullsin 13.2k

Feb '19

Hi,

I have successfully configured below softDelete and It works fine. But the find() method returns all the records. Do I need to override find() method to find([[ is_deleted => 0 ]]) ?

public function initialize() {
$this->addBehavior(new SoftDelete(
    array(
        'field' => 'is_deleted',
        'value' => 1
    )
)); 
}

Armonov · Answer 1 · 2019-02-10T12:31:48-07:00

When you use softdelete - you not delete rows in reallity. So you can't use :beforeDelete and :afterDelete. If you want find all "softdeleted" rows - you can do it:

Model::find("is_deleted=1");

or

Model::find(
    [
        'conditions' => 'is_deleted = ?1',
        'bind'       => [
            1 => 1,
        ]
    ]
);