Mojolicious::Plugin::Database - "proper" handling of DBI based connections in Mojolicious
version 1.10
Provides "sane" handling of DBI connections so problems with pre-forking (Hypnotoad, etc.) will not occur.
use Mojolicious::Plugin::Database; sub startup { my $self = shift; $self->plugin('database', { dsn => 'dbi:Pg:dbname=foo', username => 'myusername', password => 'mypassword', options => { 'pg_enable_utf8' => 1, AutoCommit => 0 }, helper => 'db', }); # or if you require multiple databases at the same time $self->plugin('database', { databases => { 'db1' => { dsn => 'dbi:Pg:dbname=foo', username => 'myusername', password => 'mypassword', }, 'db2' => { dsn => 'dbi:MySQL:dbname=bar', username => 'othername', password => 'otherpassword', }, }, }); }
When connecting to a single database, the following configuration options are recognised:
The only required option is 'dsn', every other option is optional.
When you have the need to connect to multiple databases (or different RDBMS types), the following options are recognised:
A helper is created with a name you specified (or 'db' by default) that can be used to get the active DBI connection. When using multiple databases, you also get multiple helpers.
Ben van Staveren, <madcat at cpan.org>
<madcat at cpan.org>
Please report any bugs or feature requests to through the web interface at https://github.com/benvanstaveren/mojolicious-plugin-database/issues. If you want to contribute changes or otherwise involve yourself in development, feel free to fork the Git repository from https://github.com/benvanstaveren/mojolicious-plugin-database/.
You can find documentation for this module with the perldoc command.
perldoc Mojolicious::Plugin::Database
You can also look for information at:
AnnoCPAN: Annotated CPAN documentation
http://annocpan.org/dist/Mojolicious-Plugin-Database
CPAN Ratings
http://cpanratings.perl.org/d/Mojolicious-Plugin-Database
Search CPAN
http://search.cpan.org/dist/Mojolicious-Plugin-Database/
Based on a small example by sri and his request if someone could please write a plugin for this stuff.
alabamapaul (github) for fixing the tests to work on Windows.
Babatope Aloba for pointing out it'd be really useful to be able to connect to multiple databases at once.
Copyright 2011-2015 Ben van Staveren.
This program is free software; you can redistribute it and/or modify it under the terms of either: the GNU General Public License as published by the Free Software Foundation; or the Artistic License.
See http://dev.perl.org/licenses/ for more information.
To install Mojolicious::Plugin::Database, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Mojolicious::Plugin::Database
CPAN shell
perl -MCPAN -e shell install Mojolicious::Plugin::Database
For more information on module installation, please visit the detailed CPAN module installation guide.