bundle::dbi(3pm) [linux man page]

Bundle::DBI(3pm)					User Contributed Perl Documentation					  Bundle::DBI(3pm)

NAME

       Bundle::DBI - A bundle to install DBI and required modules.

SYNOPSIS

	 perl -MCPAN -e 'install Bundle::DBI'

CONTENTS

       DBI - for to get to know thyself

       DBI::Shell 11.91 - the DBI command line shell

       Storable 2.06 - for DBD::Proxy, DBI::ProxyServer, DBD::Forward

       Net::Daemon 0.37 - for DBD::Proxy and DBI::ProxyServer

       RPC::PlServer 0.2016 - for DBD::Proxy and DBI::ProxyServer

       DBD::Multiplex 1.19 - treat multiple db handles as one

DESCRIPTION

       This bundle includes all the modules used by the Perl Database Interface (DBI) module, created by Tim Bunce.

       A Bundle is a module that simply defines a collection of other modules.	It is used by the CPAN module to automate the fetching, building
       and installing of modules from the CPAN ftp archive sites.

       This bundle does not deal with the various database drivers (e.g.  DBD::Informix, DBD::Oracle etc), most of which require software from
       sources other than CPAN. You'll need to fetch and build those drivers yourself.

AUTHORS

       Jonathan Leffler, Jochen Wiedmann and Tim Bunce.

perl v5.12.3							    2007-01-24							  Bundle::DBI(3pm)

DBD::Sponge(3)						User Contributed Perl Documentation					    DBD::Sponge(3)

NAME

       DBD::Sponge - Create a DBI statement handle from Perl data

SYNOPSIS

	 my $sponge = DBI->connect("dbi:Sponge:","","",{ RaiseError => 1 });
	 my $sth = $sponge->prepare($statement, {
		 rows => $data,
		 NAME => $names,
		 %attr
	     }
	 );

DESCRIPTION

       DBD::Sponge is useful for making a Perl data structure accessible through a standard DBI statement handle. This may be useful to DBD module
       authors who need to transform data in this way.

METHODS

   connect()
	 my $sponge = DBI->connect("dbi:Sponge:","","",{ RaiseError => 1 });

       Here's a sample syntax for creating a database handle for the Sponge driver.  No username and password are needed.

   prepare()
	 my $sth = $sponge->prepare($statement, {
		 rows => $data,
		 NAME => $names,
		 %attr
	     }
	 );

       o   The $statement here is an arbitrary statement or name you want to provide as identity of your data. If you're using DBI::Profile it
	   will appear in the profile data.

	   Generally it's expected that you are preparing a statement handle as if a "select" statement happened.

       o   $data is a reference to the data you are providing, given as an array of arrays.

       o   $names is a reference an array of column names for the $data you are providing.  The number and order should match the number and
	   ordering of the $data columns.

       o   %attr is a hash of other standard DBI attributes that you might pass to a prepare statement.

	   Currently only NAME, TYPE, and PRECISION are supported.

BUGS

       Using this module to prepare INSERT-like statements is not currently documented.

AUTHOR AND COPYRIGHT

       This module is Copyright (c) 2003 Tim Bunce

       Documentation initially written by Mark Stosberg

       The DBD::Sponge module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. In particular
       permission is granted to Tim Bunce for distributing this as a part of the DBI.

SEE ALSO

       DBI

perl v5.18.2							    2013-06-24							    DBD::Sponge(3)