在Laravel Eloquent中获取和过滤关系

问题描述：

I have the following models in Eloquent: groups, threads, comments and users. I want to find all comments in a specific group from a specific user.

This is my current approach:

$group->threads->each(function ($thread) use ($user_id)
{
  $user_comments = $thread->comments->filter(function ($comment) use ($user_id)
  {
    return $comment->owner_id == $id;
  });
});

This looks ugly as hell, is probably slow as hell, and I just want to get rid of it. What is the fastest and most elegant way in Eloquent to get to my result set?

我在Eloquent中有以下模型：组，线程，注释和用户。我想查找来自特定用户的特定组中的所有评论。 p>

这是我当前的方法： p>

  $ group-＆gt  ; threads-＆gt; each（function（$ thread）use（$ user_id）
 {
 $ user_comments = $ thread-＆gt; comments-＆gt; filter（function（$ comment）use（$ user_id）
 {\  n返回$ comment-＆gt; owner_id == $ id; 
}）; 
}）; 
  code>  pre> 
 
 这看起来很丑陋，可能很慢 地狱，我只是想摆脱它。 在Eloquent中获取结果集的最快和最优雅的方法是什么？ p> 
  div>

答

patricus solution pointed me in the right direction. I cross posted my question to the laracasts Forum and got a lot of help from Jarek Tkaczyk who also frequently visits this site.

hasManyThrough() for the Group model is the way to go:

public function comments()
{
  return $this->hasManyThrough('ThreadComment', 'Thread');
}

There a couple of caveats, though:

Use the relation object instead of a collection ($group->comments(), NOT $group->comments)
If you use Laravel’s soft deletes you can’t just change the get() to a delete(), because you’ll get an ambiguity error for the column updated_at. You can’t prefix it either, it’s just how Eloquent works.

If you want to delete all comments from a specific user in a specific group you’ll have to do it a little bit differently:

$commentsToDelete = $group->comments()
        ->where('threads_comments.owner_id', $id)
        ->select('threads_comments.id')
        ->lists('id');

ThreadComment::whereIn('id', $commentsToDelete)->delete();

You basically fetch all relevant IDs in the first query and then batch delete them in a second one.

答

If a group hasMany threads, and a thread hasMany comments, you can add another relationship to group: group hasMany comments through threads.

On the group:

public function comments() {
    return $this->hasManyThrough('Comment', 'Thread');
}

Now, you can get the comments in a group by $group->comments;

From here, you can tack on the requirement for the user:

$user_comments = $group->comments()->where('owner_id', $user_id)->get();

If you want, you can extract the where out into a scope on the Comment.

在Laravel Eloquent中获取和过滤关系

相关推荐