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

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)

Check Out this Related Man Page

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

NAME

       Class::DBI::Query - Deprecated SQL manager for Class::DBI

SYNOPSIS

	       my $sth = Class::DBI::Query
		       ->new({
			       owner => $class,
			       sqlname => $type,
			       essential => @columns,
			       where_columns => @where_cols,
		       })
		       ->run($val);

DESCRIPTION

       This abstracts away many of the details of the Class::DBI underlying SQL mechanism. For the most part you probably don't want to be
       interfacing directly with this.

       The underlying mechanisms are not yet stable, and are subject to change at any time.

OPTIONS

       A Query can have many options set before executing. Most can either be passed as an option to new(), or set later if you are building the
       query up dynamically:

   owner
       The Class::DBI subclass that 'owns' this query. In the vast majority of cases a query will return objects - the owner is the class of which
       instances will be returned.

   sqlname
       This should be the name of a query set up using set_sql.

   where_clause
       This is the raw SQL that will substituted into the 'WHERE %s' in your query. If you have multiple %s's in your query then you should supply
       a listref of where_clauses. This SQL can include placeholders, which will be used when you call run().

   essential
       When retrieving rows from the database that match the WHERE clause of the query, these are the columns that we fetch back and pre-load the
       resulting objects with. By default this is the Essential column group of the owner class.

METHODS

   where()
	       $query->where($match, @columns);

       This will extend your 'WHERE' clause by adding a 'AND $column = ?' (or whatever $match is, isntead of "=") for each column passed. If you
       have multiple WHERE clauses this will extend the last one.

perl v5.12.4							    2004-04-25						    Class::DBI::Query(3pm)

Linux and UNIX Man Pages

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

Check Out this Related Man Page