File Coverage

blib/lib/DBIx/Pager.pm

Criterion	Covered	Total	%
statement	15	54	27.7
branch	0	10	0.0
condition	0	4	0.0
subroutine	5	13	38.4
pod	7	7	100.0
total	27	88	30.6

package DBIx::Pager;
# $Id: Pager.pm,v 1.2 2002/08/06 02:06:14 ikechin Exp $
use strict;
use Carp;
use vars qw($VERSION);
use base qw(Class::Accessor);
use POSIX ();

__PACKAGE__->mk_accessors(qw(total limit offset));

$VERSION = '0.02';

sub new {
    my $class = shift;
    my %args = @_;
    my $self = bless {
	dsn => $args{dsn},
	user => $args{user},
	password => $args{password},
	dbh => $args{dbh},
	table => $args{table},
	offset => $args{offset} || 0,
	limit => $args{limit},
	where_clause => $args{where_clause},
    }, $class;
    if ($self->{dsn}) {
	eval " require DBI; ";
	$self->{dbh} = DBI->connect(
	    $self->{dsn}, $self->{user}, $self->{password},
	    {
		RaiseError => 1,
		PrintError => 1
	    }
	) or die $DBI::errstr;
    }
    $self->_load_page_info;
    $self;
}

sub _load_page_info {
    my $self = shift;
    my $dbh = $self->{dbh};
    my $table = $self->{table};
    my $sth;
    if (ref $self->{where_clause} eq 'ARRAY') {
	my @args = @{$self->{where_clause}};
	my $where = shift @args;
	$sth = $dbh->prepare("SELECT COUNT(*) FROM $table $where");
	$sth->execute(@args)
    }
    else {
	my $where = $self->{where_clause} || "";
	$sth = $dbh->prepare("SELECT COUNT(*) FROM $table $where");
	$sth->execute;
    }
    my $count = $sth->fetchrow_arrayref->[0];
    $sth->finish;
    $dbh->disconnect;
    $self->{total} = $count;
}

sub has_next {
    my $self = shift;
    if ($self->{total} > $self->{offset} + $self->{limit}) {
	return 1;
    }
    return 0;
}

sub has_prev {
    my $self = shift;
    return $self->{offset} ? 1 : 0;
}

sub next_offset {
    my $self = shift;
    return $self->{offset} + $self->{limit};
}

sub prev_offset {
    my $self = shift;
    my $prev = $self->{offset} - $self->{limit};
}

sub page_count {
    my $self = shift;
    return POSIX::ceil($self->{total} / $self->{limit});
}

sub current_page {
    my $self = shift;
    return int($self->{offset} / $self->{limit}) + 1;
}

1;
__END__