NAME

Teng::Plugin::SQLPager - Paginate with SQL

SYNOPSIS

package My::DB;
use parent qw/Teng/;
__PACKAGE__->load_plugin(qw/SQLPager/);

# in your application
$db->search_by_sql_with_pager(
    q{SELECT * FROM member ORDER BY id DESC},
    [],
    {page => 1, rows => 20}
);

DESCRIPTION

This module searches database by SQL with paginate.

search_by_sql_with_pager method adds LIMIT clause automatically.

ARGUMENTS FOR search_by_sql_with_pager

You can pass arguments as following.

$db->search_by_sql_with_pager($sql, $binds, $opt[, $table_name]);

$sql: Str

This is a SQL statement in string.

$binds: ArrayRef[Str]

This is a bind values in arrayref.

$opt: HashRef

Options for search_by_sql_with_pager. Important options are 'page' and 'rows'.

page is a current page number. rows is a entries per page.

$table_name: Str

You can pass a table name.

This argument is optional. If you don't pass a table name, Teng guess table name automatically.

LIMITATIONS

This module does not work with Oracle since Oracle does not support limit clause.