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


Text-Query-SQL documentation  | view source Contained in the Text-Query-SQL distribution.

Index


NAME

Top

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

SYNOPSIS

Top

  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

Top

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

METHODS

Top

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

Top

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

AUTHORS

Top

Loic Dachary (loic@senga.org)


Text-Query-SQL documentation  | view source Contained in the Text-Query-SQL distribution.