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