Class::DBI::AbstractSeUser(Contributed Perl DocClass::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)

Czas wygenerowania: 0.00050 sek.

Created with the man page lookup class by Andrew Collington.
Based on a C man page viewer by Vadim Pavlov
Unicode soft-hyphen fix (as used by RedHat) by Dan Edwards
Some optimisations by Eli Argon
Caching idea and code contribution by James Richardson

Copyright © 2003-2023 Linux.pl
Hosted by Hosting Linux.pl