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¶
Copyright (c) 2005 - 2009 the Catalyst::Model::DBI "AUTHOR" as listed
above.
LICENSE¶
This program is free software, you can redistribute it and/or modify it under
the same terms as Perl itself.