NAME
Mojolicious::Plugin::DSC - use DBIx::Simple::Class in your application.
SYNOPSIS
#load
# Mojolicious
$self->plugin('DSC', $config);
# Mojolicious::Lite
plugin 'DSC', $config;
#use
my $user = $app->dbix->query('SELECT * FROM users WHERE user=?','ivan');
#...and if you added My::User to 'load_classes' (see below)
my $user = My::User->query('SELECT * FROM users WHERE user=?','ivan');
DESCRIPTION
Mojolicious::Plugin::DSC is a Mojolicious plugin that helps you use DBIx::Simple::Class in your application. It also adds a helper ($app->dbix
by default) which is a DBIx::Simple instance.
CONFIGURATION
You can add all classes from your schema to the configuration and they will be loaded when the plugin is registered. The configuration is pretty flexible:
# in Mojolicious startup()
$self->plugin('DSC', {
driver => 'SQLite',
database =>':memory:',
});
#or
$self->plugin('DSC', {
driver => 'mysql',
database => 'mydbname',
host => '127.0.0.1',
user => 'myself',
password => 'secret',
onconnect_do => ['SET NAMES UTF8','SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"'],
dbh_attributes => {RaiseError=>0, AutoCommit=>0},
namespace => 'My',
#will load My::User, My::Content, My::Pages
load_classes =>['User', 'Content', 'Pages'],
#now you can use $app->DBIX instead of $app->dbix
dbix_helper => 'DBIX'
});
LICENSE AND COPYRIGHT
Copyright 2012 Красимир Беров (Krasimir Berov).
This program is free software, you can redistribute it and/or modify it under the terms of the Artistic License version 2.0.
See http://dev.perl.org/licenses/ for more information.