GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  SEARCH::QUERYPARSER::SQL::QUERY (3)

.ds Aq ’

NAME

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

CONTENTS

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.

Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 SEARCH::QUERYPARSER::SQL::QUERY (3) 2014-02-28

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.