Catalyst::Model::DBI::SUQsLe:r:LCiobnrtarriyb(u3t)ed PerClatDaolcyusmte:n:tMaotdieoln::DBI::SQL::Library(3)



NNAAMMEE
       Catalyst::Model::DBI::SQL::Library - SQL::Library DBI Model Class

SSYYNNOOPPSSIISS
               # use the helper
               create model DBI::SQL::Library DBI::SQL::Library dsn user password

               # lib/MyApp/Model/DBI/SQL/Library.pm
               package MyApp::Model::DBI::SQL::Library;

               use base 'Catalyst::Model::DBI::SQL::Library';

               __PACKAGE__->config(
                       dsn           => 'dbi:Pg:dbname=myapp',
                       password      => '',
                       user          => 'postgres',
                       options       => { AutoCommit => 1 },
                       sqldir        => 'root/sql' #optional, will default to $c->path_to ( 'root/sql' )
               );

               1;

               my $model = $c->model( 'DBI::SQL::Library' );
               my $sql = $model->load ( 'something.sql' ) ;

               #or my $sql = $model->load ( [ <FH> ] );
               #or my $sql = $model->load ( [ $sql_query1, $sql_query2 ] ) )

               my $query = $sql->retr ( 'some_sql_query' );

               #or my $query = $model->sql->retr ( 'some_sql_query );

               $model->dbh->do ( $query );

               #do something else with $sql ...

DDEESSCCRRIIPPTTIIOONN
       This is the "SQL::Library" model class. It provides access to
       "SQL::Library" via sql accessor. Please refer to "SQL::Library" for
       more information.

MMEETTHHOODDSS
       new Initializes database connection

       $self->load
           Initializes "SQL::Library" instance

       $self->dbh
           Returns the current database handle.

       $self->sql
           Returns the current "SQL::Library" instance

SSEEEE AALLSSOO
       Catalyst, DBI

AAUUTTHHOORR
       Alex Pavlovic, "alex.pavlovic@taskforce-1.com"

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



perl v5.8.8                       2006-05-C3a0talyst::Model::DBI::SQL::Library(3)