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 (loic@senga.org)