NAME
Class::Classless::DBI - provides a Classless object-oriented database interface
SYNOPSIS
use DBI;
use DBIx::Interpolate;
use Class::Classless::DBI;
my $dbh = DBI->connect(...);
my $dbx = DBIx::Interpolate->new($dbh);
my $dbo = $Class::Classless::DBI::ROOT->clone;
$dbo->{METHODS}->{table} = 'table_name';
$dbo->{METHODS}->{dbx} = $dbx;
$dbo->insert_into_table(
{
values => [
{col1 => 'A', col2 => 'B', col3 => 'C'},
{col1 => 'a', col2 => 'b', col3 => 'c'},
{col1 => '1', col2 => '2', col3 => '3'}
]
}
);
$dbo->update_table(
{
values => {col1 => 'i', col2 => 'ii'},
where => {col1 => '1'}
}
);
$dbo->delete_from_table(
{
where => {col3 => [qw(C c)]}
}
);
$dbo->select_from_table(); # [{col1 => 'i', col2 => 'ii', col3 => '3'}]DESCRIPTION
This module provides basic methods for classless objects to make database calls. It is designed to use DBIx::Interpolate, so future changes to that module are likely to affect this module as well.
METHODS
delete_from_table
insert_into_table
select_from_table
update_table
These methods do what you would expect them to do. Each method can accept a hashref as its argument. The following keys are used by these methods.
Note: select_from_table returns an arrayref of hashrefs. All other methods return the same information as &DBI::do.
columns
The value of this key should be a hashref. It allows you to use a key other than the column name when specifying table entries. For instance, the following two queries are equivalent.
$dbo->select_from_table(
{
where => {id => 5, val => 6}
}
);
$dbo->select_from_table(
{
where => {foo => 5, val => 6},
columns => {foo => 'id'}
}
);This key applies to the values key for insert_into_table and the where key for the other methods.
group
This key applies only to select_from_table. Its value should be an arrayref containing the names of columns by which to group results.
values
This key applies to the methods insert_into_table and update_table. Its value should be a hashref containing (column_name => value) entries. For insert_into_table it may also be an arrayref containing several hashrefs. In that case, each hashref must contain the same number of columns. Column values may also be arrayrefs, in which case a row will be inserted for each element of the referenced array.
select
This key applies only to select_from_table. Its value should be an arrayref containing the names of columns to select from the table.
where
This key applies to all methods but insert_into_table. Its value should be a hashref or an arrayref containing hashrefs. Each hashref should contain (column_name => value) entries that should all be satisfied for one row. An empty hashref will match all rows. All rows that match any of the hashrefs will be used. If the arrayref is empty, then no rows will be matched. However, if where is undefined, all rows will be matched. In order to simplify some queries, column values may also be arrayrefs, in which case rows that match any element of the referenced array will be used. For example, the following two queries are identical.
$dbo->select_from_table(
{
where => [
{id => 5, val => 6},
{id => 5, val => 7},
{id => 6, val => 6},
{id => 6, val => 7}
]
}
);
$dbo->select_from_table(
{
where => {id => [5,6], val => [6,7]}
}
);make_where_clause
make_from_clause
These methods are used internally by the previous methods but are also available for public use. They generate fragments of SQL queries to be used with SQL::Interpolate. make_where_clause expects the where key to be present in the same format as specified above. make_from_clause expects a key named from in the same format as values in a insert_into_table method call. Both accept the columns key as well.
AUTHOR
Mark Tiefenbruck <mdash@cpan.org>
LEGAL STUFF
Copyright (c) 2005, Mark Tiefenbruck. All rights reserved. This module is free software. It may be used, redistributed and/or modified under the same terms as Perl itself.
SEE ALSO
L<Class::Classless>
L<DBIx::Interpolate>
L<Class::DBI>