class::dbi::plugin::abstractcount(3pm) [debian man page]

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

       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.10.0							    2009-07-01							AbstractCount(3pm)

Class::DBI::Search::Basic(3pm)				User Contributed Perl Documentation			    Class::DBI::Search::Basic(3pm)

NAME

       Class::DBI::Search::Basic - Simple Class::DBI search

SYNOPSIS

	       my $searcher = Class::DBI::Search::Basic->new(
		       $cdbi_class, @search_args
	       );

	       my @results = $searcher->run_search;

	       # Over in your Class::DBI subclass:

	       __PACKAGE__->add_searcher(
		       search  => "Class::DBI::Search::Basic",
		 isearch => "Class::DBI::Search::Plugin::CaseInsensitive",
	       );

DESCRIPTION

       This is the start of a pluggable Search infrastructure for Class::DBI.

       At the minute Class::DBI::Search::Basic doubles up as both the default search within Class::DBI as well as the search base class. We will
       probably need to tease this apart more later and create an abstract base class for search plugins.

METHODS

   new
	       my $searcher = Class::DBI::Search::Basic->new(
		       $cdbi_class, @search_args
	       );

       A Searcher is created with the class to which the results will belong, and the arguments passed to the search call by the user.

   opt
	       if (my $order = $self->opt('order_by')) { ... }

       The arguments passed to search may contain an options hash. This will return the value of a given option.

   run_search
	       my @results = $searcher->run_search;
	       my $iterator = $searcher->run_search;

       Actually run the search.

SUBCLASSING

   sql / bind / fragment
       The actual mechanics of generating the SQL and executing it split up into a variety of methods for you to override.

       run_search() is implemented as:

	 return $cdbi->sth_to_objects($self->sql, $self->bind);

       Where sql() is

	 $cdbi->sql_Retrieve($self->fragment);

       There are also a variety of private methods underneath this that could be overridden in a pinch, but if you need to do this I'd rather you
       let me know so that I can make them public, or at least so that I don't remove them from under your feet.

perl v5.12.4							    2011-08-10					    Class::DBI::Search::Basic(3pm)