On Sun, May 15, 2011 at 2:23 PM, Robert Kinyon <[email protected]> wrote:
> >
> > First, I make
> > my $user = $schema->resultset('User')->find(1);
> > Now I can get all user roles trought user object, but what can I do to
> > get this roles, ordered by role_rank?
>
> my @ordered_roles = map { $_->role } $user->user_roles( {}, { order_by
> => 'role_rank' } );
>
role_rank is on the role (or roles, as the table is named), not the
user_role.
BTW -- be careful doing things like that. Probably minor in this case, but
might as well do that in a single query. I tracked down a slow page the
other day and it turned out looping and and generating over a thousand
separate queries. It's one of the reasons we must run database slaves.
Avoid the looping.
--
Bill Moseley
[email protected]
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
