Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Perl

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
lib/DBIx/Skinny
t
xt
.gitignore
.shipit
Changes
MANIFEST.SKIP
Makefile.PL
README

README

NAME
    DBIx::Skinny::Pager -

SYNOPSIS
      package Proj::DB;
      use DBIx::Skinny;
      use DBIx::Skinny::Mixin modules => ['Pager'];

      package main;
      use Proj::DB;

      my $rs = Proj::DB->resultset_with_pager('MySQLFoundRows');
      # $rs can handle like DBIx::Skinny::SQL.
      $rs->from(['some_table']);
      $rs->add_where('foo' => 'bar');
      $rs->limit(10);
      $rs->offset(20);
      $rs->select([qw(foo bar baz)]);
      my ($iter, $pager) = $rs->retrieve;
      # $iter is a DBIx::Skinny::Iterator
      # $pager is a Data::Page

      # or you can set page
      my $rs2 = Proj::DB->resultset_with_pager;
      $rs2->from(['some_table']);
      $rs2->add_where('foo' => 'bar');
      $rs2->limit(10);
      $rs2->page(2); # offset is 10 * ( 2 - 1) = 10.
      $rs2->select([qw(foo bar baz)]);
      my $result = $rs2->retrieve;
      $result->iterator #=> DBIx::Skinny::Iterator
      $result->pager #=> Data::Page

DESCRIPTION
    DBIx::Skinny::Pager is resultset pager interface for DBIx::Skinny. This
    module is not support for search_by_sql or search_named.

    and This modele is not support Oracle connection.

    XXX: THIS PROJECT IS EARLY DEVELOPMENT. API may change in future.

AUTHOR
    Keiji Yoshimi <walf443 at gmail dot com>

SEE ALSO
    +<DBIx::Skinny>, +<DBIx::Skinny::SQL>, +<DBIx::Skinny::Mixin>,
    +<Data::Page>

LICENSE
    This library is free software; you can redistribute it and/or modify it
    under the same terms as Perl itself.

Something went wrong with that request. Please try again.