man Text::Query::SolveSQL () - Apply query expression to an SQL database
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 CWText::Query object whose builder is derived from CWText::Query::BuildSQL to a CWDBI object.
METHODS
- match (DB)
- Applies the current select order to the database provided by the CWDB argument and returns a table of rows that match. Each row is a CWhashref.
SEE ALSO
AUTHORS
Loic Dachary (loic@senga.org)