Thanks to all again, my questions are closed. =) 2011/5/16 Bill Moseley <[email protected]>: > 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] >
_______________________________________________ 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]
