NAME

Catalyst::Model::DBI - DBI Model Class

SYNOPSIS

# use the helper
create model DBI DBI dsn username password

# lib/MyApp/Model/DBI.pm
package MyApp::Model::DBI;

use base 'Catalyst::Model::DBI';

__PACKAGE__->config(
	dsn           => 'dbi:Pg:dbname=myapp',
	password      => '',
	username      => 'postgres',
	options       => { AutoCommit => 1 },
);

1;

my $dbh = $c->model('DBI')->dbh;
#do something with $dbh ...

DESCRIPTION

This is the DBI model class.

METHODS

new

Initializes DBI connection

$self->dbh

Returns the current database handle.

$self->stay_connected

Returns a connected database handle.

$self->connected

Returns true if the database handle is active and pingable.

$self->connect

Connects to the database and returns the handle.

$self->disconnect

Executes rollback if AutoCommit is active, disconnects and unsets the database handle.

SEE ALSO

Catalyst, DBI

AUTHOR

Alex Pavlovic, alex.pavlovic@taskforce-1.com

COPYRIGHT

This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.