SPOPS::SQLInterface

SPOPS::SQLInterface is a Perl module with generic routines for DBI database interaction.
Download

SPOPS::SQLInterface Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Perl Artistic License
  • Price:
  • FREE
  • Publisher Name:
  • Chris Winters
  • Publisher web site:
  • http://search.cpan.org/~cwinters/SPOPS-0.87/SPOPS/SQLInterface.pm

SPOPS::SQLInterface Tags


SPOPS::SQLInterface Description

SPOPS::SQLInterface is a Perl module with generic routines for DBI database interaction. SPOPS::SQLInterface is a Perl module with generic routines for DBI database interaction.SYNOPSIS # Make this class a parent of my class package My::DBIStuff; use SPOPS::SQLInterface; @My::DBIStuff::ISA = qw( SPOPS::SQLInterface ); # You should also be able to use it directly, but you # need to pass in a database object with every request use SPOPS::SQLInterface; my $dbc = 'SPOPS::SQLInterface'; my $db = DBI->connect( ... ) || die $DBI::errstr; my $rows = $dbc->db_select({ select => , from => , where => 'first_name = ? or last_name = ?', value => , db => $db }); foreach my $row ( @{ $results } ) { print "User ID $row-> is $row-> $row->n"; }You are meant to inherit from this class, although you can use it as a standalone SQL abstraction tool as well, as long as you pass the database handle into every routine you call. Requirements: · Perl


SPOPS::SQLInterface Related Software