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

NAME

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

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" });

DESCRIPTION

Class::DBI::AbstractSearch is a Class::DBI plugin to glue SQL::Abstract 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 the SQL::Abstract manpage for hash options.

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

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

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

    $clsas->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

the Class::DBI manpage, the SQL::Abstract manpage

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