NAME

Catalyst::Model::DBIS - DBIx::Simple model class

SYNOPSIS

  $c->model('DBIS')->insert('test_log_db', {
      user_agent      => $c->req->user_agent,
      insert_datetime => ['NOW()'],
  });
  
  $c->stash->{users} = $c->model('DBIS')->select(
      'tickets', '*', {
          status => $c->req->param('status') || 0,
      },
  )->hashes;
  
  $c->model('DBIS')->query('SELECT 1 + 1')->into( $c->stash->{answer} );

DESCRIPTION

Note: This is a super simple DBIx::Simple model. If you're interested this, Catalyst::Model::DBIC::Schema help you I promise. Catalyst::Model::DBIS will be deprecated.

CREATE APP MODEL CLASS

Using helper...(see Catalyst::Helper::Model::DBIS)

  % ./script/myapp_create.pl model DBIS DBIS dsn user password

Or manually create in lib/MyApp/Model/DBIS.pm

  package MyApp::Model::DBIS;
  use strict;
  use base 'Catalyst::Model::DBIS';
  
  __PACKAGE__->config(
      connect_info => [
          'dbi:mysql:myapp_db',
          'myapp_user',
          'myapp_pass',
          { RaiseError => 1 },
          { on_connect_do => [ 'set names utf8' ] },
      ],
  );
  
  1;

CONFIG

In lib/MyApp/Model/DBIS.pm as above, or in myapp.yaml file like this.

  Model::DBIS:
  connect_info:
      - dbi:SQLite:dbname=myapp.db

connect_info

List of arguments to DBI->connect(). See DBI for more description.

on_connect_do: This module emulates DBIx::Class's on_connect_do feature. connect_info can take a hash at the end.

AUTHOR

Naoki Tomita <tomita@cpan.org>

LICENSE

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

CPAN RT