table of contents
| AbstractCount(3pm) | User Contributed Perl Documentation | AbstractCount(3pm) |
NAME¶
Class::DBI::Plugin::AbstractCount - get COUNT(*) results with abstract SQL
SYNOPSIS¶
use base 'Class::DBI';
use Class::DBI::Plugin::AbstractCount;
my $count = Music::Vinyl->count_search_where(
{ artist => 'Frank Zappa'
, title => { like => '%Shut Up 'n Play Yer Guitar%' }
, released => { between => [ 1980, 1982 ] }
});
DESCRIPTION¶
This Class::DBI plugin combines the functionality from Class::DBI::Plugin::CountSearch (counting objects without having to use an array or an iterator), and Class::DBI::AbstractSearch, which allows complex where-clauses a la SQL::Abstract.
METHODS¶
count_search_where¶
Takes a hashref with the abstract where-clause. An additional attribute hashref can be passed to influence the default behaviour: arrayrefs are OR'ed, hashrefs are AND'ed.
TODO¶
More tests, more doc.
SEE ALSO¶
AUTHOR¶
Jean-Christophe Zeus, <mail@jczeus.com> with some help from Tatsuhiko Myagawa and Todd Holbrook.
COPYRIGHT AND LICENSE¶
Copyright (C) 2004 by Jean-Christophe Zeus
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
| 2022-11-19 | perl v5.36.0 |