Linux Certif

Toute la documentation sur la certification Linux LPI

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