Tony Bowden > Class-DBI-Search-LIMITed > Class::DBI::Search::LIMITed

Download:
Class-DBI-Search-LIMITed-1.01.tar.gz

Dependencies

Annotate this POD

CPAN RT

Open  0
View/Report Bugs
Module Version: 1.01   Source  

NAME ^

Class::DBI::Search::LIMITed - add 'LIMIT' to Class::DBI searches

SYNOPSIS ^

        use base 'Class::DBI';

        __PACKAGE__->add_searcher(
                limited_search => 'Class::DBI::Search::LIMITed'
        );

        my @by_date = My::Class->limited_search( ... , {
                        order_by => 'name',
                        limit    => 10,
        });

        # or, if you want it to be the default search

        __PACKAGE__->add_searcher(
                search => 'Class::DBI::Search::LIMITed'
        );

        my @by_date = My::Class->search( ... , {
                        order_by => 'name',
                        limit    => '20, 10',
        });

DESCRIPTION ^

This is a simple search plugin to a Class::DBI subclass which allows for the addition of a LIMIT option to a SELECT query.

METHODS ^

add_searcher

        __PACKAGE__->add_searcher(
                method_name => 'Class::DBI::Search::LIMITed'
        );

As with all Search plugins you can choose the method name for the search that it generates. You can either make a distinct limit-ed search method (e.g. search_limited()), or just make it your default search() method.

fragment

This overrides the default 'fragment' method in Class::DBI::Search::Basic to add any 'limit' option passed in your search query.

CAVEATS ^

This is only useful for databases which support a LIMIT modifier, such as MySQL.

AUTHOR ^

Tony Bowden

BUGS and QUERIES ^

Please direct all correspondence regarding this module to: bug-Class-DBI-Search-LIMITed@rt.cpan.org

COPYRIGHT AND LICENSE ^

  Copyright (C) 2005 Tony Bowden.

  This program is free software; you can redistribute it and/or modify
  it under the terms of the GNU General Public License; either version
  2 of the License, or (at your option) any later version.

  This program is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
syntax highlighting: