Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
AbstractCount(3)      User Contributed Perl Documentation     AbstractCount(3)

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.

perl v5.24.1			  2009-07-01		      AbstractCount(3)

NAME | SYNOPSIS | DESCRIPTION | METHODS | TODO | SEE ALSO | AUTHOR | COPYRIGHT AND LICENSE

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Class::DBI::Plugin::AbstractCount&sektion=3&manpath=FreeBSD+12.1-RELEASE+and+Ports>

home | help