Class::DBI::AbstractSearch man page on Pidora

Man page or keyword search:  
man Server   31170 pages
apropos Keyword Search (all sections)
Output format
Pidora logo
[printable version]

Class::DBI::AbstractSeUser(Contributed Perl DocumClass::DBI::AbstractSearch(3)

NAME
       Class::DBI::AbstractSearch - Abstract Class::DBI's SQL with
       SQL::Abstract::Limit

SYNOPSIS
	 package CD::Music;
	 use Class::DBI::AbstractSearch;

	 package main;
	 my @music = CD::Music->search_where(
	     artist => [ 'Ozzy', 'Kelly' ],
	     status => { '!=', 'outdated' },
	 );

	 my @misc = CD::Music->search_where(
	     { artist => [ 'Ozzy', 'Kelly' ],
	       status => { '!=', 'outdated' } },
	     { order_by	     => "reldate DESC",
	       limit_dialect => 'LimitOffset',
	       limit	     => 1
	       offset	     => 2 });

DESCRIPTION
       Class::DBI::AbstractSearch is a Class::DBI plugin to glue
       SQL::Abstract::Limit into Class::DBI.

METHODS
       Using this module adds following methods into your data class.

       search_where
	     $class->search_where(%where);

	   Takes a hash to specify WHERE clause. See SQL::Abstract for hash
	   options.

	     $class->search_where(\%where,\%attrs);

	   Takes hash reference to specify WHERE clause. See SQL::Abstract for
	   hash options. Takes a hash reference to specify additional query
	   attributes. Class::DBI::AbstractSearch uses these attributes:

	   ·   order_by

	       Array reference of fields that will be used to order the
	       results of your query.

	   ·   limit_dialect

	       Scalar, DBI handle, object class, etc. that describes the
	       syntax model for a LIMIT/OFFSET SQL clause.  Please see
	       SQL::Abstract::Limit for more information.

	   ·   limit

	       Scalar value that will be used for LIMIT argument in a query.

	   ·   offset

	       Scalar value that will be used for OFFSET argument in a query.

	   Any other attributes are passed to the SQL::Abstract::Limit
	   constructor, and can be used to control how queries are created.
	   For example, to use 'AND' instead of 'OR' by default, use:

	       $class->search_where(\%where, { logic => 'AND' });

AUTHOR
       Tatsuhiko Miyagawa <miyagawa@bulknews.net> with some help from cdbi-
       talk mailing list, especially:

	 Tim Bunce
	 Simon Wilcox
	 Tony Bowden

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

SEE ALSO
       Class::DBI, SQL::Abstract, SQL::Abstract::Limit

POD ERRORS
       Hey! The above document had some coding errors, which are explained
       below:

       Around line 123:
	   You forgot a '=back' before '=head1'

perl v5.14.1			  2005-10-06	 Class::DBI::AbstractSearch(3)
[top]

List of man pages available for Pidora

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net