README
1NAME
2 DBIx::Skinny::Pager -
3
4SYNOPSIS
5 package Proj::DB;
6 use DBIx::Skinny;
7 use DBIx::Skinny::Mixin modules => ['Pager'];
8
9 package main;
10 use Proj::DB;
11
12 my $rs = Proj::DB->resultset_with_pager('MySQLFoundRows');
13 # $rs can handle like DBIx::Skinny::SQL.
14 $rs->from(['some_table']);
15 $rs->add_where('foo' => 'bar');
16 $rs->limit(10);
17 $rs->offset(20);
18 $rs->select([qw(foo bar baz)]);
19 my ($iter, $pager) = $rs->retrieve;
20 # $iter is a DBIx::Skinny::Iterator
21 # $pager is a Data::Page
22
23 # or you can set page
24 my $rs2 = Proj::DB->resultset_with_pager;
25 $rs2->from(['some_table']);
26 $rs2->add_where('foo' => 'bar');
27 $rs2->limit(10);
28 $rs2->page(2); # offset is 10 * ( 2 - 1) = 10.
29 $rs2->select([qw(foo bar baz)]);
30 my $result = $rs2->retrieve;
31 $result->iterator #=> DBIx::Skinny::Iterator
32 $result->pager #=> Data::Page
33
34DESCRIPTION
35 DBIx::Skinny::Pager is resultset pager interface for DBIx::Skinny. This
36 module is not support for search_by_sql or search_named.
37
38 and This modele is not support Oracle connection.
39
40 XXX: THIS PROJECT IS EARLY DEVELOPMENT. API may change in future.
41
42AUTHOR
43 Keiji Yoshimi <walf443 at gmail dot com>
44
45SEE ALSO
46 DBIx::Skinny, DBIx::Skinny::SQL, DBIx::Skinny::Mixin, Data::Page
47
48LICENSE
49 This library is free software; you can redistribute it and/or modify it
50 under the same terms as Perl itself.
51
52