SQL::QueryBuilder::Simple

SQL::QueryBuilder::Simple is a Perl module that generates simple SQL SELECT queries.
Download

SQL::QueryBuilder::Simple Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Perl Artistic License
  • Price:
  • FREE
  • Publisher Name:
  • Robert Rothenberg
  • Publisher web site:
  • http://search.cpan.org/~rrwo/

SQL::QueryBuilder::Simple Tags


SQL::QueryBuilder::Simple Description

SQL::QueryBuilder::Simple is a Perl module that generates simple SQL SELECT queries. SQL::QueryBuilder::Simple is a Perl module that generates simple SQL SELECT queries.SYNOPSIS use SQL::QueryBuilder::Simple; my $query = SQL::QueryBuilder::Simple->new( table => "MYTABLE", # from table MYTABLE fields => , # select fields FLD1, FLD2 ne => { FLD1 => -1 }, # where FLD1 not equal to -1 ); print $query->sql; # SELECT FLD1, FLD2 FROM MYTABLE WHERE FLD1? use DBI; my $dbh = DBI->connect( ... ) or die; my $sth = $dbh->prepare( $query->sql ) or die; $sth->execute( $query->bindings ) or die;This module generates simple SQL select statements and manages binding parameters, to simplify generating dynamic queries.This module will only generate SQL code. It does not validate the code, nor does it check against any database to see if table or field names are valid. Requirements: · Perl


SQL::QueryBuilder::Simple Related Software