Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Dancer2 - How to loop over a ref to a HoH

by fishmonger (Chaplain)
on Jun 10, 2014 at 03:26 UTC ( #1089380=perlquestion: print w/replies, xml ) Need Help??

fishmonger has asked for the wisdom of the Perl Monks concerning the following question:

I'm just beginning to learn how to use the Dancer2 framework and am having problems displaying the results of a $sth->fetchall_hashref DBI querry.

I started with the example code from the "Our first route handler" section in the Dancer2::Tutorial documentation and adjusted it slightly to match my requirements.

Route Handler:

get '/partners' => sub { my $dbh = get_db_connection(); my $sth = $dbh->prepare("SELECT TPID, TPCOMPNAME, TPTYPE FROM TRADINGPARTNERPROFILE ORDER BY TPID LIMIT 2"); $sth->execute; my $partners = $sth->fetchall_hashref('TPID'); my $dump = Dumper($partners); $dbh->disconnect; template '', { 'dumper' => $dump, 'partners' => $partners, }; };\


<div> <pre><% dumper %></pre> <% FOREACH partner IN partners.keys %> Partner: <% partners.$partner.TPCOMPNAME %> <% partners.$partner.T +PTYPE %><br> <% END %> </div>

Resulting html output

<div> <pre>$VAR1 = { 'AB DISTRIBUTING INC.' => { 'TPTYPE' => '1', 'TPID' => 'AB DISTRIBUTING INC.' +, 'TPCOMPNAME' => 'AB Distributing + Inc.' }, 'A.T. CROSS ' => { 'TPTYPE' => '1', 'TPID' => 'A.T. CROSS ', 'TPCOMPNAME' => 'A.T. Cross ' } }; </pre> Partner: <br> </div>

What am I doing wrong which is preventing the desired output in the loop?

One factor which may be important is that I'm testing this on Win7 perl v5.16.1 and will be deploying the app on a CentOS system which will probably be running perl v5.18.2

Replies are listed 'Best First'.
Re: Dancer2 - How to loop over a ref to a HoH
by arkturuz (Curate) on Jun 10, 2014 at 08:54 UTC
        Sorry about that, somehow I missed it, and it's been a long time since I last hacked on Template Toolkit.

        Could this solve your issue?

        <% FOREACH partner IN partners.values %> Partner: <% partner.TPCOMPNAME %> <% partner.TPTYPE %><br> <% END %>
Re: Dancer2 - How to loop over a ref to a HoH (template engine?)
by Anonymous Monk on Jun 10, 2014 at 07:23 UTC
    What template engine?

      I was using Dancer's "simple" engine, which clearly doesn't parse the template vars the same as TT. I guess I was a little tired and not thinking clearly, because that fact should have been obvious.

      Once I changed the engine to "Template_Toolkit" in config.yml and corrected the syntax in the template files it worked correctly.


Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://1089380]
Approved by boftx
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (11)
As of 2022-01-18 14:10 GMT
Find Nodes?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:

    Results (53 votes). Check out past polls.