How to bulk update related records in cakephp3?

Asked Apr 11 '19 at 20:27

Active Apr 12 '19 at 15:18

Viewed 100 times

Can somebody help me with the correct approach on updating multiple records related to a table and based on a condition.

I am trying to update the field is_deleted for all comments in comment table, if the comment is related to a deleted post.

Below is the code I tried.

$commentsTable->query()
->join([
    'table' => 'Posts',
    'type' => 'inner',
    'conditions'=>  ['Posts.id = Comments.post_id', 'Posts.is_deleted = 1'],
])->updateAll(['Comments.is_deleted' => 1],[]);

I can use simple query to do this, but want to know how to handle this using Cakephp Query Builder.

edited Apr 12 '19 at 15:18

asked Apr 11 '19 at 20:27

Yogesh Gupta

Is the field in `Posts` called `is_delete` or `is_deleted`? – Greg Schmidt Apr 11 '19 at 22:47
updateAll function needs 2 parameters Cake\ORM\Table::updateAll($fields, $conditions) – Sehdev Apr 12 '19 at 06:22
Sorry @GregSchmidt - that was a typo. It is **is_deleted** – Yogesh Gupta Apr 12 '19 at 14:09
Then in addition to what @Sehdev said, you might need to disambiguate with `'Comments.is_deleted' => 1` in your `updateAll` call. – Greg Schmidt Apr 12 '19 at 14:12
I tried to add condition to `updateAll`, but doesn't help. I also changed it to `Comments.is_deleted` but isn't helping – Yogesh Gupta Apr 12 '19 at 15:17

How to bulk update related records in cakephp3?

0 Answers0