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
|
package DBIx::Class::Storage::DBI::MultiDistinctEmulation;
use strict;
use warnings;
use base qw/DBIx::Class::Storage::DBI/;
sub _select {
my ($self, $ident, $select, $condition, $attrs) = @_;
# hack to make count distincts with multiple columns work in SQLite and Oracle
if (ref $select eq 'ARRAY') {
@{$select} = map {$self->replace_distincts($_)} @{$select};
} else {
$select = $self->replace_distincts($select);
}
return $self->next::method($ident, $select, $condition, $attrs);
}
sub replace_distincts {
my ($self, $select) = @_;
$select->{count}->{distinct} = join("||", @{$select->{count}->{distinct}})
if (ref $select eq 'HASH' && $select->{count} && ref $select->{count} eq 'HASH' &&
$select->{count}->{distinct} && ref $select->{count}->{distinct} eq 'ARRAY');
return $select;
}
1;
=head1 NAME
DBIx::Class::Storage::DBI::MultiDistinctEmulation - Some databases can't handle count distincts with multiple cols. They should use base on this.
=head1 SYNOPSIS
=head1 DESCRIPTION
This class allows count distincts with multiple columns for retarded databases (Oracle and SQLite)
=head1 AUTHORS
Luke Saunders <luke.saunders@gmail.com>
=head1 LICENSE
You may distribute this code under the same terms as Perl itself.
=cut
|
