[Dbix-class] Order by

[brett gardner]

Is there anyway in DBIx::Class to set in the table class object the 
fields you want the results to be sorted by by default. eg

__PACKAGE__->table('foo');
__PACKAGE__->add_columns(qw/foo_id foo bar/);
__PACKAGE__->sort_column('bar');

Or do you have to manually set the order_by field statement everywhere 
you try and retrieve these items?

Also, is there an ability to have named groups of columns similar to 
Class::DBI? eg

__PACKAGE__->add_column_group('menu'=>qw/foo bar/);

This would be useful for a default handler to display a menu of items. I 
have actually implemented this myself but I don't think I did it in a 
very smart or efficient way.

Cheers,
Brett Gardner

-- 
Brett Gardner
Clientcomm
Phone : 02 9699 1888
Fax   : 02 9318 6499