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 so you do not have to use My::Table. The configuration is pretty flexible:

# in Mojolicious startup()
$self->plugin('DSC', {
  dsn => 'dbi:SQLite:database=:memory:;host=localhost'
});
#or
$self->plugin('DSC', {
  driver => 'mysqlPP',
  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 => {AutoCommit=>0},
  namespace => 'My',
  
  #will load My::User, My::Content, My::Pages
  load_classes =>['User', 'Content', 'My::Pages'],
  
  #now you can use $app->DBIX instead of $app->dbix
  dbix_helper => 'DBIX' 
});

METHODS

Mojolicious::Plugin::DSC inherits all methods from Mojolicious::Plugin and implements the following new ones.

register

$plugin->register(Mojolicious->new);

Register plugin in Mojolicious application.

config

This plugin own configuration. Returns a HASHref.

#debug
$app->log->debug($app->dumper($plugin->config));

SEE ALSO

DBIx::Simple::Class, Mojolicious, Mojolicious::Guides, http://mojolicio.us.

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.