These are strings that are fed directly into the
connect method of DBI.
The <dsn> attribute is not required as long as you pass an active database handle into the
dbh attribute (see below).
password default to
"" (which is useful if,
you're using a SQLite database).
The hash reference
attributes contains any optional key-value pairs to be passed to DBI's
See the DBI documentation for more details.
These strings represent the source of the data within the database represented by
In other words,
if your data source is from DBI,
then you can pull data via a table name (
table) or via a query (
Don't set both of these,
as this will cause your script to die.
This optional attribute is the database handle that will be used to grab the data.
If it is not supplied,
then a connection will be made using the
attributes attributes (if possible).
This method grabs the resulting data from the query returned by the
The returned data structure is a hash reference of array references where the keys correspond to column names (ie the elements of the
@columns array) and the values of the hash reference are the values of the given column returned by the query from the
The optional hash reference argument allows for the overriding of the query generated by the
Jack Maney <firstname.lastname@example.org>
This software is copyright (c) 2012 by Jack Maney.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.