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).