Roger A Hall > DBIx-MySperql > DBIx::MySperql

Download:
DBIx-MySperql-1.01.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Module Version: 1.01   Source  

NAME ^

MySperql - Module to simplify DBI MySQL statements

SYNOPSIS ^

  use DBIx::MySperql qw(DBConnect SQLExec $dbh);
    
  $dbh = &DBConnect(%parameters);
  
  $return = &SQLExec($sql, $type, \%parameters);
  @return = &SQLExec($sql, $type, \%parameters);
  
  $sth = &SQLExecute($sql, %parameters);
  $sth = &SQLParse($test, %parameters);
  $ref = &SQLFetch($sth, $type);

DESCRIPTION ^

MySperql enables one line sql statements when using perl with DBI and MySQL. It supports single or multiple connections to both local and remote databases.

Using the module requires that you understand: 1) how to write the SQL statments you need 2) perl lists ('@') and references ('\')

The second concept is necessary to both understand the "$type" parameter and handle the results. The types are strings that represent the data type expected to be returned. They logically match the data structure returned: '@' is a one-row list, '\@' is a one row reference to a list, and '\@@' is a (potentially) multi-row reference. See below for included examples of each type.

This module was originally created as a database library in 2001 by Roger Hall (Little Rock, AR) and Eric Goldbrenner (San Francisco, CA).

(Thanks again Eric! :)

FUNCTIONS

EXAMPLES

EXPORT

  $dbh      # Database Handle

SEE ALSO ^

http://www.iosea.com/mysperql

AUTHOR ^

Roger Hall <roger@iosea.com>

COPYRIGHT AND LICENSE ^

Copyleft (C) 2007 by Roger Hall

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.5 or, at your option, any later version of Perl 5 you may have available.

syntax highlighting: