config

$table_setting = $dbo->config($option)
$dbo->config($option => $table_setting)

Get or set the global or dbo config settings. When setting an option, the previous value is returned.

dbh

The read-write DBI handle.

rdbh

The read-only DBI handle, or if there is no read-only connection, the read-write DBI handle.

do

$dbo->do($statement)         or die $dbo->dbh->errstr;
$dbo->do($statement, \%attr) or die $dbo->dbh->errstr;
$dbo->do($statement, \%attr, @bind_values) or die ...

This provides access to DBI do method. It defaults to using the read-write DBI handle.

tables

Return a list of DBIx::DBO::Table objects, which will always be this Table object.

column

$t->column($column_name)
$t ** $column_name

Returns the DBO column object for this column.

fetch_value

$t->fetch_value($column, %where)

Fetch the first matching row from the table returning the value in one column.

fetch_hash

$t->fetch_hash(%where)

Fetch the first matching row from the table returning it as a hashref.

fetch_row

$t->fetch_row(%where)

Fetch the first matching row from the table returning it as a Row object.

fetch_column

$t->fetch_column($column, %where)

Fetch all matching rows from the table returning an arrayref of the values in one column.

insert

$t->insert(name => 'Richard', age => 103)

Insert a row into the table.

delete

$t->delete(name => 'Richard', age => 103)

Delete all rows from the table matching the criteria.

cpanm DBIx::DBO

perl -MCPAN -e shell
install DBIx::DBO