Yii2 Delete Query Using Relations

Question

I have defined a relation in Yii2 in which every website can have multiple feeds:

public function getFeeds() {
    return $this->hasMany(Feed::className(), ['website_id' => 'id']);
}

Now consider following query:

$ids = [2, 3];
$feeds = Website::find()->where(['user_id' => 1])->with(['feeds' => function($query) use ($ids) {
    $query->where(['id' => $ids);
}])->all();

The corresponding raw SQL queries are:

SELECT * FROM `website` WHERE `user_id`= 1 // returns 4, 5, 6
SELECT * FROM `feed` WHERE (`id` IN (2, 3)) AND (`website_id` IN (4, 5, 6))

My questions is, can I have delete version of this query using Active Record? Something like this:

SELECT * FROM `website` WHERE `user_id`= 1
DELETE FROM `feed` WHERE (`id` IN (2, 3)) AND (`website_id` IN (4, 5, 6))

Any help would be appreciated.

Paul · Accepted Answer · 2018-01-02 02:12:42Z

1

You may do as this:

$query = Website::find()
    ->select('id')
    ->where(['user_id' => 1]);

Feed::deleteAll([
    'id' => [2, 3],
    'website_id' => $query
]);

answered Jan 2, 2018 at 2:12

Paul

1,6871 gold badge16 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ScaisEdge · Accepted Answer · 2016-11-09 22:04:59Z

0

In this case could be better a CreateCommand

for do this you should bild raw query using join eg:

select * 
from `feed` 
join `website` on `website`.id = `feed`.`website_id`
WHERE website`.`user_id`= 1
AND  `feed`.id  IN (2, 3)

or for delete

delete 
from `feed` 
join `website` on `website`.id = `feed`.`website_id`
WHERE website`.`user_id`= 1
AND  `feed`.id  IN (2, 3)

then for Yii2

$sql = "delete 
        from `feed` 
        join `website` on `website`.id = `feed`.`website_id`
        WHERE website`.`user_id`= 1
        AND  `feed`.id  IN (2, 3);"

Yii::$app->db->createCommand($sql)->execute();

answered Nov 9, 2016 at 22:04

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

1 Comment

Hamid Mohayeji Over a year ago

Thanks, but I want to create this query using Active Record, just like the select version.

Collectives™ on Stack Overflow

Yii2 Delete Query Using Relations

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related