Peter Karman > Search-QueryParser-SQL > Search::QueryParser::SQL::Query

Download:
Search-QueryParser-SQL-0.010.tar.gz

Dependencies

Annotate this POD

Website

CPAN RT

Open  0
View/Report Bugs
Module Version: 0.010   Source  

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.

syntax highlighting: