This relationship retrieves all videos from the same category:
Model Video {
...
public function relatedByCategory(): HasMany
{
return $this->hasMany(Video::class, 'category_id', 'category_id')
->where('id', '!=', $this->id); // Exclude the current video
}
The problem is that it still retrieves the current video itself even with where('id', '!=', $this->id);. How to achieve this goal?
If this does not work, I would probably create a scope
public function relatedByCategory(): HasMany
{
return $this->hasMany(Video::class, 'category_id', 'category_id');
}
public function scopeNotSelf($query)
{
$query->where('id', '!=', $this->id); // Exclude the current video
}
and use it like $relatedVideos = $video->relatedByCategory()->notSelf()->get();
@Snapey This is, interestingly, still retrieving the current video. I did some debugging and for some reason $this->id is evaluated to null.
This is the results of the query
> $video = Video::find('01jvjn1xqcv1h9bp6y94kx6k5c');
= App\Models\Video {#3951
id: "01jvjn1xqcv1h9bp6y94kx6k5c",
uploader_id: "01jvjmw7qtqkqe057bepab9f4k",
category_id: "01jvjmw5h47na9cfvyjgnp560r",
...
slug: "save-title",
}
> $relatedVideos = $video->relatedByCategory()->notSelf()->get()
= Illuminate\Database\Eloquent\Collection {#11001
all: [
// Other videos from the same category
App\Models\Video {#3718
id: "01jvjn1tmzbp4d171a28581j9m",
uploader_id: "01jvjmw7qtqkqe057bepab9f4k",
...
},
...
// This is the same $video item
App\Models\Video {#8401
id: "01jvjn1xqcv1h9bp6y94kx6k5c",
uploader_id: "01jvjmw7qtqkqe057bepab9f4k",
category_id: "01jvjmw5h47na9cfvyjgnp560r",
...
slug: "save-title",
},
...
],
}
@Snapey Debugging more into the issue:
This query, with eager loading, Retruns the same video in the results
Video::with('relatedByCategory')->find('VIDEO_ID')->relatedByCategory
Without Eager loading, it excludes the current video and works as expected.
Video::find('VIDEO_ID')->relatedByCategory
Does eager loading affect the relationship query?
Defining a relationship this way is very unconventional and surely does not scale. I suggest defining a different relationship or just writing a database query scope.
Also, ->where('id', '!=', $this->id) can be rewritten to simply ->whereKeyNot($this->id).
Please or to participate in this conversation.