Text::Query::SolveSQL3pm

Usage

  use Text::Query;
  my $q=new Text::Query('field1: ( hello and world )',
                        -parse => 'Text::Query::ParseAdvanced',
                        -solve => 'Text::Query::SolveSQL',
                        -build => 'Text::Query::BuildSQLFulcrum',
                        -select => 'select * from t1 where __WHERE__');

  my $db = DBI->connect(undef, undef, undef);

  my @rows = $q->match($db);

Overview

Applies a select order computed by a "Text::Query" object whose builder is derived from "Text::Query::BuildSQL" to a "DBI" object.

Methods

match (DB)

Applies the current select order to the database provided by the "DB" argument and returns a table of rows that match. Each row is a "hashref".