debian man page for class::dbi::abstractsearch

Query: class::dbi::abstractsearch

OS: debian

Section: 3pm

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

Class::DBI::AbstractSearch(3pm) 			User Contributed Perl Documentation			   Class::DBI::AbstractSearch(3pm)

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: o order_by Array reference of fields that will be used to order the results of your query. o 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. o limit Scalar value that will be used for LIMIT argument in a query. o 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 perl v5.10.0 2009-07-21 Class::DBI::AbstractSearch(3pm)
Related Man Pages
class::dbi::search::basic(3pm) - debian
class::dbi::plugin::pager(3pm) - debian
class::dbi::query(3pm) - debian
dbix::class::storage::dbi::sqlanywhere(3pm) - debian
dbix::class::sqlmaker5.12(3) - osx
Similar Topics in the Unix Linux Community
please help immediately
Perl Programming for Splitting
How to extract WHERE clause from a SQL using UNIX???
Read input file and used it to SQL query
Perform SQL query then FTP