Rechercher une page de manuel
Class::DBI::Plugin::AbstractCount.3pm
Langue: en
Version: 2006-06-14 (mandriva - 01/05/08)
Section: 3 (Bibliothèques de fonctions)
NAME
Class::DBI::Plugin::AbstractCount - get COUNT(*) results with abstract SQLSYNOPSIS
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
- SQL::Abstract for details about the where-clause and the attributes.
- Class::DBI::AbstractSearch
- Class::DBI::Plugin::CountSearch
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 ZeusThis library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre