NAME
Search::QueryParser::SQL::Query - query object
SYNOPSIS
# see Search::QueryParser::SQLDESCRIPTION
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.