Skip to content
This repository

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

Fetching latest commit…

Octocat-spinner-32-eaf2f5

Cannot retrieve the latest commit at this time

Octocat-spinner-32 lib
Octocat-spinner-32 t
Octocat-spinner-32 xt
Octocat-spinner-32 .gitignore
Octocat-spinner-32 .shipit
Octocat-spinner-32 Changes
Octocat-spinner-32 MANIFEST.SKIP
Octocat-spinner-32 Makefile.PL
Octocat-spinner-32 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.