What's the right way to display a DBIx::Class ResultSet in my Catalyst project that uses Template To

Posted by Thelema on Stack Overflow See other posts from Stack Overflow or by Thelema
Published on 2009-01-15T15:59:27Z Indexed on 2010/03/30 16:33 UTC
Read the original article Hit count: 339

Given a DBIx::Class resultset, for example:

my $rs = $c->model("DB::Card")->search({family_name => "Smith"});

the tutorials I've read use the stash to pass an arrayref of rows:

$c->stash->{cards} = [$rs->all];

This results in the query getting executed at this point, and the resulting objects stuffed into the stash, so they can be used in TemplateToolkit as:

[% FOREACH card IN cards %] 
    [% card.given_name %] [% card.family_name %] 
[%END%]

Is there a proper way to have TT iterate over the rows as they get fetched from the DB?

© Stack Overflow or respective owner

Related posts about template-toolkit

Related posts about perl