Peter Karman

NAME

Search::QueryParser::SQL::Query - query object

SYNOPSIS

 # see Search::QueryParser::SQL

DESCRIPTION

This class is primarily for unparsing Search::QueryParser data structures into valid SQL.

METHODS

Only new or overridden method are documented here.

stringify

Returns Query as a string suitable for plugging into a WHERE clause.

dbi

Like stringify(), but returns array ref of two items: the SQL string and an array ref of values. The SQL string uses the ? placeholder as expected by the DBI API.

pairs

Returns array ref of array refs of column/op/value pairs. Note that the logical AND/OR connectors will not be present.

rdbo

Returns array ref ready for passing to Rose::DB::Object::Querybuilder build_select() method as the query argument.

dbic

Returns array ref ready for passing to DBIx::Class as search query. This is the SQL::Abstract format.

parser

Returns the original parser object that generated the query.

AUTHOR

Peter Karman, <karman@cpan.org>

BUGS

Please report any bugs or feature requests to bug-search-queryparser-sql@rt.cpan.org, or through the web interface at http://rt.cpan.org. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.

ACKNOWLEDGEMENTS

The Minnesota Supercomputing Institute http://www.msi.umn.edu/ sponsored the development of this software.

COPYRIGHT & LICENSE

Copyright 2008 by the Regents of the University of Minnesota.

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