File Coverage

lib/DBIx/Skinny/Pager/Logic/MySQLFoundRows.pm

Criterion	Covered	Total	%
statement	18	18	100.0
branch			n/a
condition			n/a
subroutine	6	6	100.0
pod	0	2	0.0
total	24	26	92.3

package DBIx::Skinny::Pager::Logic::MySQLFoundRows;
use strict;
use warnings;
use base qw/DBIx::Skinny::Pager/;
use Data::Page;

sub as_sql {
    my $self = shift;
    my $result = $self->SUPER::as_sql;
    # TODO: 正規表現もいいかげんなのでもうちょいちゃんとやりたい
    # as_sqlの中身をいじるのは本家への追従を考えると難しそう
    $result =~ s/SELECT /SELECT SQL_CALC_FOUND_ROWS /; # mysql support only
    $result;
}

sub get_total_entries {
    my $self = shift;
    $self->skinny->search_by_sql(q{SELECT FOUND_ROWS() AS row})->first->row;
}

1;
__END__