如何删除 Eloquent 中的多态关系?

2021-12-26 00:00:00 php laravel eloquent polymorphic-associations

我有一个这样的模型:

<?php

class Post extends Eloquent {
    protected $fillable = [];


    public function photos()
    {
        return $this->morphMany('Upload', 'imageable');
    }

    public function attachments()
    {
        return $this->morphMany('Upload', 'attachable');
    }

}

和我的 morphMany 表的模式是这样的:

and my morphMany table's schema is like this:

CREATE TABLE `uploads` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `raw_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `size` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `downloads` int(11) NOT NULL DEFAULT '0', `imageable_id` int(11) DEFAULT NULL, `imageable_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `attachable_id` int(11) DEFAULT NULL, `attachable_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `user_id` int(10) unsigned NOT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `uploads_user_id_index` (`user_id`), CONSTRAINT `uploads_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

现在我需要删除此表的一行，我尝试了 $posts->photos()->delete(); 但它删除了与此 Post 相关的所有行.

now I need to remove one row of this table, I tried $posts->photos()->delete(); but it removed all rows associated to this Post.

有人可以帮我吗?

推荐答案

$posts->photos() 是返回帖子的所有照片的关系查询.如果您对此调用 delete()，它将删除所有这些记录.如果您只想删除特定记录，则需要确保只对要删除的记录调用 delete.例如:

$posts->photos() is the relationship query to return all of the photos for a post. If you call delete() on that, it will delete all of those records. If you only want to delete a specific record, you need to make sure you only call delete on the one you want to delete. For example:

$posts->photos()->where('id', '=', 1)->delete();

相关文章