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

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