1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
package DBIx::Class::Helper::ResultSet::Shortcut::OrderByMagic;
$DBIx::Class::Helper::ResultSet::Shortcut::OrderByMagic::VERSION = '2.033002';
use strict;
use warnings;
use parent 'DBIx::Class::Helper::ResultSet::Shortcut::OrderBy', 'DBIx::Class::ResultSet';
sub order_by {
my ($self, @order) = @_;
return $self->next::method(@order)
if @order && ref($order[0]);
my @clauses;
foreach (@order) {
foreach my $col (split(/\s*,\s*/)) {
my $dir = 'asc';
if (substr($col, 0, 1) eq '!') {
$col = substr($col, 1); # take everything after '!'
$dir = 'desc';
}
# add csa prefix if necessary
$col = join('.', $self->current_source_alias, $col)
if index($col, '.') == -1;
push @clauses, { "-$dir" => $col };
}
}
return $self->next::method(\@clauses);
}
1;
__END__
=pod
=head1 NAME
DBIx::Class::Helper::ResultSet::Shortcut::OrderByMagic
=head1 AUTHOR
Arthur Axel "fREW" Schmidt <frioux+cpan@gmail.com>
=head1 COPYRIGHT AND LICENSE
This software is copyright (c) 2016 by Arthur Axel "fREW" Schmidt.
This is free software; you can redistribute it and/or modify it under
the same terms as the Perl 5 programming language system itself.
=cut
|
