[Catalyst] $c->user->some_relationship always retrives user id from the db

[Jay K]

Thanks for the suggestion, I will probably go that route.  It's
somewhat simpler than my previous plan.

Jay

On Feb 14, 2008, at 1:19 PM, Matt S Trout wrote:

> On Thu, Feb 14, 2008 at 11:06:09AM -0700, Jay K wrote:
>>> So why do I need to recovery the whole user row for every request?
>>> I could use
>>> $user_id = $c->session->{user_id};
>>> @albums = $c->model('albums')->search({ user_id => $user_id });
>>> as Mitchell suggested but I'd prefer to fetch the data by using $c-
>>>> user because its the way one should do it.
>>>
>>> might it be possible to store the user row in the session at login
>>> and recover $c->user from the session on every request?
>>> I know this might break if I change something in the user row.
>>
>>
>> Hi again Moritz,
>>
>> Matt is correct - Because nobody has written the 'store everything in
>> the session' bit yet.   I have a plan to change the DBIx::Class store
>> so that it will save the row info into the session - but I have not
>> done so yet.   The next release will include that functionality, but
>> at this time I can't tell you when exactly that will be.  I'm going
>> to
>> try to get it done this weekend.
>>
>> In anticipation of that - I can tell you that you should use $c-
>> >user-
>>> get('fieldname');  When my code is complete, that will be the 'don't
>> hit the database' way of accessing row information.   Accessing $c-
>>> user->obj or $c->user->get_object will trigger the DB hit.  And
>> since $c->user->fieldname just relays to $c->user->get_object-
>>> fieldname - the shortcut method won't work either if you want to
>> avoid the db hit.
>
> But then you can't follow even PK relationships without the db hit.
>
> Which means the entire thing would be pointless. What you want to do
> really is
>
>  $class->new({ %saved_stuff, -result_source => $schema-
> >source($class) });
>  $new_obj->in_storage(1);
>
> then it'll work "as if" you re-fetched the object (%saved_stuff
> being the
> return of $obj->get_columns). Making stuff work with only the PK
> stashed
> in the session is left as an exercise to the reader, but would
> probably
> be best done using Data::Thunk and Data::Swap.
>
> --
>      Matt S Trout       Need help with your Catalyst or DBIx::Class
> project?
>   Technical Director                    http://www.shadowcat.co.uk/catalyst/
> Shadowcat Systems Ltd.  Want a managed development or deployment
> platform?
> http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/
>
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/

---
"Those who can make you believe absurdities can make you commit
atrocities." --Voltaire