/ 
Class-DBI-Search-Count-1.00
River stage zero No dependents
/ Class::DBI::Search::Count

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

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.