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

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

transfer log object
by Arjan Widlak 25 Aug '15

25 Aug '15

Dear all, How can I get the log object? (outside of a specific route) I have this Dancer2 application that is an interface to a backend. If I could handover the Dancer2 log object to the backend, it could write to the same log. What I would like to do is something like: |use Dancer2;|| || ||my $dancer2_log = XXX->get_dancer2_logger;|| || ||my $backend_environment = Backend::Env->new({|| || log => $dancer2_log,|| ||});|||| || ||get '/' => sub {|| || my $env = $env; ... |Is it possible to obtain the log object somehow, or do I have to instantiate Dancer2::Core::Role::Logger myself, and hand it all the config information myself? Kind regards, Arjan.

2 7

Redirect with scalar value
by Richard Reina 24 Aug '15

24 Aug '15

I have the following post that gets a user's selection from a page then looks up the corresponding record for the selection. post '/mypage' => sub { # let user make a selection my $select_id = params->{sportselect}; print "\n\nLooks Like They Selected No: $select_id\n\n"; # take them to the add_sport (but somehow with selected no hook 'before' => sub { var sport_id => $select_id; request->path('/sport_add') };}get '/sport_add' => sub { my ($selID) = splat; # print "In sport_add we got: $selID as the chosen number\n"; }

2 2

passing a variable to a new subroutine route
by Richard Reina 24 Aug '15

24 Aug '15

PLEASE IGNORE MY POST SENT MOMENTS AGO. I WAS NOT FINISHED TYPING. I have the following post that gets a user's selection from a page then looks up the corresponding records for the selection and put them into a hash refrence. THat part works fine. How can I then call another page/route with that hash_refrence? For example; post '/mypage' => sub { # let user make a selection my $select_id = params->{Sselect}; print "\n\nLooks Like They Selected No: $select_id\n\n"; # look up DB records corresponding to $select_id; # store them in hash refrence $sel_ref } Now I would like to call template/page sport_add but I would like it to have $sel_ref so that it could put that data into the template sport_add get '/sport_add' => sub { template 'sport_add.tt', { 'MyTypes' => $sel_ref, # 'Testing' => "This is text to test to make sure this will come through", # to test, use this like <% Testing %> on your template page }, {}; }; Thanks for any help. Have a great afternoon.

2 5

Accepting JSON in a POST request
by Gabor Szabo 24 Aug '15

24 Aug '15

Hi, When I send a POST request with JQuery or with a plan HTML form I see 'CONTENT_TYPE' => 'application/x-www-form-urlencoded; charset=UTF-8', and the data looks like this: 'body' => 'foo=23&bar=19', If I understand it correctly then this is what Dancer turns into the values accessible via param() When I use Angular to send a POST request to the Dancer back-end, by default it send 'CONTENT_TYPE' => 'application/json;charset=UTF-8', and the data looks like this: 'body' => '{"foo":23,"bar":19}', and Dancer2 does not parse this. Shouldn't Dancer2 look at the content type of the POST request and handle the data accordingly? Or is that the job of PSGI? Do I need to tell something to Dancer2 or to PSGI to do this? regards Gabor

2 3

Does dancer have a post-return hook or something of that nature?
by Robert Smith 24 Aug '15

24 Aug '15

Here’s what I want to do: post '/info' => sub { info "\n\n\tIn /info with params:\n" . Dumper params; my $tmp_href = params; if (&do_some_stuff_here($tmp_href)) { $tmp_href->{status_code} = "200"; } return $tmp_href; # THEN DO SOME POST RETURN STUFF HERE (Obviously not here, but somehow a callback function for post-return or something like that?) }; Does it exist? I feel like I’ve been through the documentation pretty thoroughly. -Robert

3 3

How to data into webpage
by Richard Reina 21 Aug '15

21 Aug '15

Have been learning Dancer2 over the last few weeks and really like it. Wondering if someone can tell me how I can load data from a MySQL database into a dancer rendered page. I am comfortable writing SQL in perl via perl->DBI just don't have any idea how to bring the data from a fetch into a webpage so that I can display it directly on the page or load it into a dropdown menu. Any help is greatly appreciated. Thanks

4 11

Re: [dancer-users] plugins-yanick
by Rick Leir 21 Aug '15

21 Aug '15

On Fri, Aug 21, 2015 at 7:00 AM, <dancer-users-request(a)dancer.pm> wrote: > At last news, the ball was in my court to clean, tweak up and document > https://github.com/yanick/Dancer2/tree/plugins-yanick I'm still trying > to find the few hours to do this. If anybody want to help, don't be shy > to give me a shout. :-) What is the goal or purpose of this this fork? I looked around a bit, but it is not jumping out at me. Thanks Rick

2 1