HasOne Through as an Eloquent relationship

[dwightwatson]

I'd like to suggest that we add hasOneThrough() as an additional Eloquent relationship. I'll use the example of the hasManyThrough() relationship to explain the use case. You can use the hasManyThrough() relationship to get the posts of a country. A hasOneThrough() relationship would allow you to get the country of a post.

class Post extends Model
{
    public function country()
    {
        return $this->hasOneThrough('App\Country', 'App\User');
    }
}

This effectively allows inverse transversal of the relationship between the chain of models. This relationship exists in Rails, and I've supplied the SQL statement used by ActiveRecord to fetch the country from a post model.

SELECT  "countries".* FROM "countries" INNER JOIN "users" ON "countries"."id" = "users"."country_id" WHERE "users"."id" = ? LIMIT 1

[ChangePlaces]

Maybe I'm misunderstanding - why not use a getCountryAttribute method and return $this->user->country?

[dwightwatson]

Because that's abusing attributes to work like relations. You can't eager load it, you can't query it and you can't assign it.

[keevitaja]

+1

[IVIR3zaM]

+1

[djtarazona]

+1

I could definitely use this.

[samuel-cloete]

+1

[EricWVGG]

+1

[ovp87]

+1

[JapSeyz]

+1

[brandfocus]

+1

[GrahamCampbell]

Please don't 👍 issues. It doesn't really help anyone. Sending a PR would help, adding a +1 does not.

[GrahamCampbell]

Thanks for the report, but we don't process feature requests. We are, however, open to PRs.

[nejtr0n]

+1

[Barbery]

+1