NAME

HTML::Template::Associate::DBI - HTML::Template::Associate DBI plugin

SYNOPSIS

            

              
              
This class is not intended to be used directly but rather through a 
HTML::Template::Associate. It provides concrete class functionality.
use DBI;        
use HTML::Template;
use HTML::Template::Associate;
#initiliaze your $dbh ...
my $results_foo = $dbh->selectall_hashref ( 
        'SELECT foo FROM bar WHERE baz = ?',
        'foo_id',
        {},
        $baz
);
                 
my $results_bar = $dbh->selectall_hashref ( 
        'SELECT foo, bar FROM bar WHERE baz = ?',
        [ 'foo_id', 'bar_id' ] ,
        {},
        $baz
);
my $results_moo = $dbh->selectrow_hashref ( 'SELECT x, y FROM z LIMIT 1' );
my @results_array = $dbh->selectrow_array ( 'SELECT x FROM z' );
my $associate = HTML::Template::Associate->new( {
        target => 'DBI', 
        create => [ { 
                        results => $results_foo,
                        name => 'my_loop',
                        type => 'selectall_hashref'
                }, {
                        results => $results_bar,
                        name => 'my_other_loop',
                        type => 'selectall_hashref'
                }, {
                        results => $results_moo,
                        type => 'selectrow_hashref',
                        name => 'my_params'
                }, {
                        results => \@results_array,
                        type => 'selectrow_array',
                        name => 'my_array_params'
                }
        ]
} ); 
         
my $template = HTML::Template->new (
        filename => 'test.tmpl', 
        associate => [ $associate ],
        die_on_bad_params => 0
);
print $template->output();
#sample.tmpl
<!-- TMPL_LOOP NAME="my_loop" -->
        Foo is:<!-- TMPL_VAR NAME="foo" -->
<!-- /TMPL_LOOP -->
<!-- TMPL_LOOP NAME="my_other_loop" -->
        Foo is:<!-- TMPL_VAR NAME="foo" --> 
        Bar is:<!-- TMPL_VAR NAME="bar" -->
<!-- /TMPL_LOOP -->       
x is:<!-- TMPL_VAR NAME="my_params.x" -->
y is:<!-- TMPL_VAR NAME="my_params.y" -->
x via $dbh->selectrow_array is:<!-- TMPL_VAR NAME="my_array_params.0 -->
            
          

DESCRIPTION

            

              
              
This class is not intended to be used directly but rather through a 
HTML::Template::Associate. It provides concrete class functionality, it
will take specific DBI method results and reconstruct data structure
to the one appropriate for use by the HTML::Template.   
Supported DBI method types 
* selectall_hashref
* selectrow_hashref
* fetchall_hashref
* fetchrow_hashref
* selectall_arrayref
* selectcol_arrayref
* selectrow_array
* selectrow_arrayref
* fetchrow_array
* fetchrow_arrayref
* fetchall_arrayref
            
          

METHODS

init

Initializes the mapper

init_selectall_hashref

Transform using selectall_hashref return format.

init_selectrow_hashref

Transform using selectrow_hashref return format.

init_selectall_arrayref

Transform using selectall_arrayref return format.

init_selectcol_arrayref

Transform using selectcol_arrayref return format.

BUGS

            

              
              
If you find any please report to author.
            
          

SUPPORT

            

              
              
See License.
            
          

AUTHOR

            

              
              
Alex Pavlovic
alex.pavlovic@taskforce-1.com
http://www.taskforce-1.com
            
          

COPYRIGHT

            

              
              
This program is free software; you can redistribute
it and/or modify it under the same terms as Perl itself.
The full text of the license can be found in the
LICENSE file included with this module.
            
          

SEE ALSO

            

              
              
HTML::Template::Associate HTML::Template::Associate::FormValidator perl(1).