NAME

Class::DBI::Search::Count - return count of results rather than results

SYNOPSIS

use base 'Class::DBI';

            __PACKAGE__->add_searcher(
                    search_count => 'Class::DBI::Search::Count'
            );

            my $recent = CD->search_count(year => 2005);

This is equivalent to, but, as the counting is done at the database rather than in perl, faster than:

my $recent = CD->search(year => 2005)->count;

DESCRIPTION

This is a simple search plugin for Class::DBI to return a count of results rather than the results themselves.

METHODS
add_searcher

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

As with all Search plugins you can choose the method name for the search that it generates.

sql
We override the SQL to be our own COUNT(*) version

run_search
We override this to return our count rather than the search results.

AUTHOR

Tony Bowden

BUGS and QUERIES

Please direct all correspondence regarding this module to: bug-Class-DBI-Search-Count@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.