Catalyst::Model::DBI(3pm)				User Contributed Perl Documentation				 Catalyst::Model::DBI(3pm)

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.

perl v5.14.2							    2010-01-28						 Catalyst::Model::DBI(3pm)