Jean-Christophe Zeus > Class-DBI-Plugin-AbstractCount > Class::DBI::Plugin::AbstractCount

Download:
Class-DBI-Plugin-AbstractCount-0.08.tar.gz

Dependencies

Annotate this POD

CPAN RT

Open  0
View/Report Bugs
Module Version: 0.08   Source  

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 ^

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 Zeus

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

syntax highlighting: