Text::Query::SolveSQL(3pm)

NAME

Text::Query::SolveSQL - Apply query expression to an SQL database

SYNOPSIS

  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);

DESCRIPTION

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".

SEE ALSO

Text::Query(3) Text::Query::Solve(3)

AUTHORS

Loic Dachary ([email protected])