how to get ids of the rows updated by updateAll() function in cakephp?

Question

I am developing an application in cakephp. I need to get id's of all the rows that have been updated using updateAll() function in cakephp. Any suggestions would be highly appreciated. Thanx..

Is this what i should do in my App Model

class AppModel extends Model {

    var $infos = array();

    function updateAll($fields, $conditions = true) {
        $this->$infos = $this->find('all', array('conditions' => $conditions));
        $return = parent::updateAll($fields, $conditions);
        $this->afterUpdateAll();
        return $return;
    }


    function afterUpdateAll(){
        foreach ($this->$infos as $info) {
            //do something
        }
    }

}

Will this work..?

bfavaretto · Accepted Answer · 2012-04-09T13:58:39.723

1

You have to issue a find passing the same conditions you passed to updateAll.

If the update operation changes data in any of the columns used in the conditions, you should use find before calling updateAll.

edited Apr 09 '12 at 13:58

answered Apr 09 '12 at 13:46

bfavaretto

71,580
16
111
150

@vin.it, there is a catch on the code you posted, see my updated answer. – bfavaretto Apr 09 '12 at 14:01
thanx.. will let you know.. :) – Vineet Apr 09 '12 at 14:11

score 0 · Answer 2 · answered Apr 09 '12 at 13:46

0

If you UPDATE uncial rows - you may just SELECT them again after UPDATE

answered Apr 09 '12 at 13:46

dr.dimitru

2,645
1
27
36

how to get ids of the rows updated by updateAll() function in cakephp?

2 Answers2