Relations::Query 0.93 review

License: Perl Artistic License File size: 10K Developer: Relations::Query Team

0

Relations::Query is a Perl Object for building queries with DBI/DBD::mysql.

SYNOPSIS

# Relations::Query Script that creates some queries.

use Relations::Query;

$query = new Relations::Query(-select => {'fife' => 'barney'},
-from => {'green_teeth' => 'moogoo'},
-where => "flotsam>jetsam",
-group_by => "denali",
-having => {'fortune' => 'cookie'},
-order_by => ['was','is','will'],
-limit => '1');

$get_query = $query->get();

$query->set(-select => {'clean' => 'sparkle'},
-from => {'lean' => 'book'},
-where => "fighting is between courage and chaos",
-limit => '123');

$set_query = $query->get();

$get_add_query = $query->get_add(-select => {'mean' => 'dog'},
-where => "running is null",
-having => {'kitties'=> 'on_tv'},
-limit => ['9678']);

$query = to_string({'select' => 'this',
'from' => 'that'});

Requirements:
Perl