Eager load relationship for authenticated user

Interesting question im curious if someone has an answer.

Anyway for this situation two queries will be issued eager loading or not. Eager loading is made to resolve the N + 1 query problem not for loading all the model data in one query.

But if I do \Auth::user()->properties->count() in 3-4 different places throughout my app/view, will that be 3-4 additional queries? Or just 1?

Protected property $with in Illuminate\Database\Eloquent\Model can be used. I am sure it will work for you. The only issue of this approach is that 'properties' will be eager loaded with all other User models.

@theshiftexchange I don't know. I think count will query every time its used.

@theshiftexchange It will be only one query because you call the count method of the collection.

what is the right thing to do here? if don't want to execute a query when i call "\Auth::user()->properties->count()" in the view, where should i load 'properties' to the AuthUser Model?

I'm curious as well. I eager load some relationships on the authed user on every page load, so could be interesting how we could reduce the queries, so that the relationship is called when the user is Authed.

I think it gets cached. If you use Laravel Debugbar you get a queries tab, which is super handy for catching pages that you forget to use eager loading. You can see how many and what queries get ran.

My template:

  {{ auth()->user()->roles->count() }}
  {{ auth()->user()->roles->count() }}
  {{ auth()->user()->roles->count() }}
  {{ auth()->user()->roles->count() }}

It runs 2 queries, one to get the authenticated user, the other to get the relationship. Any subsequent call to the relationship is cached. I'm using an employees table and model for my auth model:

select * from `employees` where `employees`.`id` = '1' limit 1
select `roles`.*, `employee_role`.`employee_id` as `pivot_employee_id`, `employee_role`.`role_id` as `pivot_role_id` from `roles` inner join `employee_role` on `roles`.`id` = `employee_role`.`role_id` where `employee_role`.`employee_id` = '1'

The auth manager is a singleton + the user is cached (see line Guard.php line: 130) + relations are also not loaded every time (see: Model.php line: 2674).

So, I don't think you need eager loading, since the database hit will only occur for the first time.

As @Cocoon said, the count() method is called on the resulting collection not the relationship.

You can do this in your controller to eager load your properties relation on the user :

$user = Auth::user();
$user->load('properties');

And it works ! You can pass $user variable after to your view.

If I'm not mistaken there is a method withCount() that you can directly call on your relationship like this:

public function properties()
    {
        return $this->hasMany('\App\Property')->withCount('properties');
    }

You might have to experiment to find the exact correct usage for this.

EDIT:

From the Let's build a forum series:

1. Use a global scope to always eager load a relationship, you can do this in your model

protected static function boot() {
  parent::boot();
  static::addGlobalScope('propertiesCount', function($builder) {
    $builder->withCount('properties');
  }
}

1. Use the $with property:

protected $with = ['properties'];

Hope this helps.

@guillaume @Borisu

guys... it's a 2 year old thread. Hopefully the original poster has moved on by now...

@Snapey so it is :D Hopefully it helps someone :)

It made my day :D

@Borisu Thanks a lot.. just googled this and it saved me

save me too

I know it's been a long time since this was asked, but he's what I did: (this is a Inertia+React scenario, by the way)

# app/Http/Middleware/HandleInertiaRequests.php
public function share(Request $request): array
{
        $user = $request->user();
        $user?->load(['roles']);
        return array_merge(parent::share($request), [
            'auth' => [
                'user' => $user,
            ],
            'ziggy' => function () use ($request) {
                return array_merge((new Ziggy)->toArray(), [
                    'location' => $request->url(),
                ]);
            },
            // ...
        ]);
}