- dancer-users - lists.preshweb.co.uk

table records into updateable checkbox list
by Richard Reina 31 Aug '15

31 Aug '15

Does template toolkit provide of any sort of way to iterate a query results like below but to also allow a space to the right (like an addon) for user to type in text? So that I would have: [checkbox] [table columns] [small text area] I have been struggling with how to go about this for about a day and I believe it is beyond my pay-grade. I feel like I am close but have been stuck for so long that I am beginning to question if I am going about this entirely the wrong way and that perhaps there is an easier TT method. <div class="container" style="margin-top:20px;"> <div class="row"> <div class="col-xs-12"> <form role="form" action="openchallenges" method="POST"> <h3 class="text-center">Open To Do</h3> <div class="well" style="max-height: 300px;overflow: auto;"> <ul class="list-group">  <table style="width:100%"> <% FOREACH ID IN Chlngs.keys.sort %> <tr class="list-group-item"> <td width="5"> <input type="checkbox" name="<% Chlngs.$ ID.ID %>"</input> </td> <td width="70"><% Chlngs.$ID.SNAME %></td> <td width="75"><% Chlngs.$ID.ANAME %></td> <td width="35"><% Chlngs.$ID.SSN %></td> <td width="35"><% Chlngs.$ID.YR %></td> <td width="250"><% Chlngs.$ID.CHNAME %></td> <td width="550"><% Chlngs.$ID.DESCRIP %></td> <% END %> </tr> </ul> </table> </div> <hr class="colorgraph"> <div class="row"> <div class="col-xs-12 col-md-12"><input type="submit" value="Submit" class="btn btn-primary btn-block btn-lg"></div> </form> </div> </div> </div> Thanks, Richard

2 2

Reminder on Call for Papers for Perl Dancer Conference in Vienna
by Stefan Hornburg (Racke) 30 Aug '15

30 Aug '15

The submission deadline ends August 31th, midnight CET. Please use http://www.perl.dance/talks/submit for submitting your talk or write to 2015(a)perl.dance if you need help or more time to prepare your proposal. We already confirmed a number of interesting talks and there are a few more prominent speakers like Peter Rabbitson and Russell Jenkins which are going to present at the Perl Dancer Conference. Regards Racke -- Perl and Dancer Development Visit our Perl::Dancer conference 2015. More information on https://www.perl.dance.

1 0

Trapping parameters from a dynamic list of checkboxes.
by Richard Reina 28 Aug '15

28 Aug '15

I am trying to find a way to get values back from a dynamic list of checkboxes. Within my template I have figured out how to create the list of checkboxes based on values from a hash reference. Like so: <% FOREACH ID IN Accomps.keys %> <div> <label><input type="checkbox" name="<% Accomps.$ID.NAME %>" value="<% Accomps.$ID.ID %>"><% Accomps.$ID.NAME %> <% Accomps.$ID.descrip %></label> </div> <% END %> </div> However, I can't figure out how dancer would go about getting back the values from the list of checkboxes as each checkbox input's name is different. I normally get values back in Dancer with: like this: my $input_hash = { Tech => param('tech), Type => param('type'), } But I cannot figure out how to do it in this case since the name of the input type is based on the values in the has ref. I have tried to create them based on the values that are fed into the template from the SQL query like this: my $input_hash = { Tech => param('tech), Type => param('type'), while ($sth->fetch) { $ANAME => param($ANAME), } } But this causes plackup start to crash with: Error while loading /home/richard/Dancer2/MyApp/bin/app.psgi: syntax error at /home/richard/Dancer2/MyApp/bin/../lib/MyApp.pm line 549, near "while" syntax error at /home/richard/Dancer2/MyApp/bin/../lib/MyApp.pm line 555, near "}" So I am beginning to think that I am heading down the wrong path. Any help would be greatly appreciated. Thanks

7 15

Re: [dancer-users] dancer-users Digest, plugins
by Rick Leir 27 Aug '15

27 Aug '15

On Mon, 20 Apr 2015, Yanick Champoux wrote: > On 2015-04-19 07:59 AM, Sawyer X wrote: >> Yanick Champoux and Russell Jenkins have both produces two different >> implementations that resolve our current problems in different ways. >> They are available online. > > Mine is at > https://github.com/PerlDancer/Dancer2/compare/master...yanick:plugins-yanick > > And Russell's is at > https://github.com/PerlDancer/Dancer2/compare/master...veryrusty:playground… What are the pro's and con's of these ways? (and what are the current problems?) Thanks Rick

2 2

2015 Perl Dancer Conference Sponsorship
by Sam Batschelet 27 Aug '15

27 Aug '15

Greetings Dancer Enthusiast, We are closing in fast on the 2015 Perl Dancer Conference held in Vienna, Austria October 19 - 22 . Sponsoring the Perl Dancer Conference is an oppourtunity to present your company or association to an international audience for Perl, Dancer and DBIx:Class related topics. We have a great cast of speakers ( https://www.perl.dance/speakers ) from the #dancer community this year including core developers Stefan Hornburg (racke), Sawyer X, Russell Jenkins (veryrusty) and other names you might remember from the mailing list or IRC. Another exciting community fact is the new conference site https://perl.dance is powered by Dancer and Interchange 6. Feel free to fork our repo https://github.com/interchange/Perl-Dancer-Conference and see the exciting advances in this project. The conference is a great event and with your support will continue to build the sense of community that is the foundation of #dancer. Please take a moment and look over our sponsorship page for ideas or contact us directly at 2015(a)perl.dance and we can come up with a custom package for you. Thank You, Sam Batschelet 2015 Perl Dancer Conference http://perl.dance | 2015(a)perl.dance https://www.facebook.com/pages/Perl-Dancer-Conference/670529456366338

1 0

In-code template configuration - order matters?
by Gabor Szabo 27 Aug '15

27 Aug '15

Hi, given this simple template: <h2><% name %></h2> And this code: #!/usr/bin/env perl use Dancer2; set engines => { template => { template_toolkit => { start_tag => '<%', end_tag => '%>', } } }; set template => "template_toolkit"; get '/' => sub { template 'demo', { name => 'Perl Maven' }; }; dance; I see the expected display, but if I change the order of the two 'set' statements then I just get <h2><% name %></h2> as output. Why is that? Gabor ps. I don't have any configuration files. This is a stand-alone script with an external tt file.

4 4

list order from a hash
by Richard Reina 27 Aug '15

27 Aug '15

I have this table data that I load into a template as follows. $q = "SELECT ID, NAME FROM jobs ORDER BY NAME"; $sth = $dbh->prepare($q); $sth->execute(); my $Jobs_ref = $sth->fetchall_hashref('ID'); template 'sport_add.tt', { 'Jobs' => $Jobs_ref, 'Testing' => "This is text to test to make sure this will come through", # to test, use this like <% Testing %> on your template page }, {}; To display it in the template as a drop-down select I do: <select class="selectpicker" name="jobselect" id="jobselect" style="width: 500px;"> <% FOREACH ID IN Jobs.keys %> <option value="<% Jobs.$ID.ID %>"><% Jobs.$ID.NAME %></option> <% END %> And it works great. Except for one thing, the list is not in order by name. I have read more than a few posts about how once you save a query as a hashref that the order is lost. Most of those posts suggested fetching as a arrayref instead. However, I have no idea how to do that and then display it in a select like the above code does. So I wanted to see if somebody perhaps knows of a not too complicated of a solution to get the select list into alphabetical order by name. Thanks

5 9

Re: [dancer-users] dancer-users Digest, Vol 66, Issue 30
by Dancer New 25 Aug '15

25 Aug '15

> > Date: Tue, 25 Aug 2015 11:45:28 +0100 > From: Andrew Beverley <andy(a)andybev.com> > To: Perl Dancer users mailing list <dancer-users(a)dancer.pm> > Subject: Re: [dancer-users] database connection in dancer > Message-ID: <1440499528.28975.7.camel(a)andybev.com> > Content-Type: text/plain; charset="UTF-8" > > On Tue, 2015-08-25 at 11:38 +0100, Dancer New wrote: > > Hi, > > Hi, > > > I am trying to implement a user login on a website. > > > > Each time a user logon, the session record the user name. > > Firstly, have you considered using an existing authentication module, such > as > Dancer2::Plugin::Auth::Extensible? This will save reinventing the wheel. > > I am using Dancer. > > The problem I have now was the database connection in 'before hook' ( > > setting user context) and the db connection in the route for actual query > > seems two different db connections. So the database doesn't know they are > > from the same user request and therefore doesn't return the right > results. > > It sounds like you are initiating a new database connection for each page > request? > If so, that's very expensive, and not likely to be very scalable. > I would like to know how to make one db connection and use it in all requests. where to store the database handler? > > How to keep the database connection in 'before hook' and pass the same > > database connection to other route? > > If you still decide to do it this way, then you could save the database > connection > using var and then read that value later: > > var mydb => $db; > ... > my $db = var 'mydb'; > > Andy > > > >

3 2

database connection in dancer
by Dancer New 25 Aug '15

25 Aug '15

Hi, I am trying to implement a user login on a website. Each time a user logon, the session record the user name. In the database side, there is a store procedure to set the user context so that for subsequent query, the database will return results based on the different user. In my application, there is a 'before hook' to checks the session first and connect to the database, pass the username to the stored procedure to set the user context. so for each request, it will call the 'before hook' first and then start to query the database. The problem I have now was the database connection in 'before hook' ( setting user context) and the db connection in the route for actual query seems two different db connections. So the database doesn't know they are from the same user request and therefore doesn't return the right results. How to keep the database connection in 'before hook' and pass the same database connection to other route? Your help will be much appreciated! Tom

2 1

passing session user name from route sub to route sub
by Richard Reina 25 Aug '15

25 Aug '15

When a user signs in I do this to send them to their page with log in. # Logged in successfully session username => $input_hash->{FName}; redirect '/userpage'; However, I am wondering how I can pass the username from on sub to another sub call within my MyApp.pm. So that as a user bounces to another page I can do a database query for that user. For example, if the user goes to. get '/JobsView' => sub { #query open jobs for the user } How do I get the username inside '/JobsView' so that I can use it for SQL queries? Thanks

2 1