Catalyst::Model::DBI - DBI Model Class

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 ...
        
        =head1 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.

 Catalyst::Model::DBI - DBI Model Class