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

howto query between date ?
by Tonton 13 Feb '14

13 Feb '14

hello i write this in my sub my $count_DossiersClos = database('asav')->quick_count( 'DossierClos', {DateCloture =>{ 'lt' => "2013-12-01 00:00:01"},DateCloture => { 'gt' => "2013-11-01 00:00:01"}}); return $count_DossiersClos; but the query just use the last Date cloture and in mysql.log i read 140212 17:05:21 18 Connect admin@localhost on asav 18 Query set autocommit=1 18 Query SELECT COUNT(*) FROM `DossierClos` WHERE `DateCloture` > '2013-11-01 00:00:01' ingenuous i hope : SELECT COUNT(*) FROM `DossierClos` WHERE `DateCloture` > '2013-11-01 00:00:01' and `DateCloture` < '2013-12-01 00:00:01' does it better to write the query ? regards T.

2 2

Re: [dancer-users] Dancer app in production on Starman : Dancer::Plugin::Database Child process cannot use database handle created in parent
by Scott Penrose 11 Feb '14

11 Feb '14

Without any actual internal knowledge, my one guess would be forking. If you make a database connection into a variable (e.g. database, or $dbh) then you fork, then you can no longer access that connection. There is a way to share a pool of connections (in apache aka Apache::DBI) or I used to use PerChild directive on Apache to make a connection. Now it should all be handled, but maybe it isn’t? Scott On 11 Feb 2014, at 9:23 am, Anthony Milan <anthony.milan(a)laposte.net> wrote: > Le 10/02/2014 22:57, Anthony Milan a écrit : >> Hi, >> >> I tried to deploy my little app with Starman: >> plackup -E deployment -s Starman -p 5001 --workers=2 -a bin/app.pl >> >> I had this error: >> Child process cannot use database handle created in parent >> >> I used Dancer::Plugin::Database to manage database >> >> In this thread: >> http://lists.preshweb.co.uk/pipermail/dancer-users/2011-July/001681.html >> I read that Dancer::Plugin::Database ensure that handles are not >> shared between processes/threads. >> >> Most probably, I do something wrong :( > > I googled around starman and DBI and I execute > Starman without plackup. > > starman -p 5000 --workers=2 -a ../bin/app.pl > > It seems to work. Any idea? > > Thanks > -- > Anthony Milan > _______________________________________________ > dancer-users mailing list > dancer-users(a)dancer.pm > http://lists.preshweb.co.uk/mailman/listinfo/dancer-users

3 2

State of Dancer2 debugging support?
by Warren Young 10 Feb '14

10 Feb '14

Do the 'show_errors' and 'traces' config settings work in Dancer2? I ask because I have both set in my environment/development.yml file, but I am still seeing it render 500 errors using public/500.html, rather than the custom error screen the docs claim. I have verified that the development.yml file is being read by putting unparseable junk in it, which prevents my app from starting, as expected. Also, I put this at the top of the route handler I'm having trouble with: debug "Dancing on the ", (config->{'environment'}), " dancefloor."; It does say "development". By the way, the 'startup_info' configuration flag is documented as showing the "dancefloor" in the banner, but I only get this here: Dancer2 v0.11 server 19360 listening on http://0.0.0.0:30000 I wouldn't have needed to add this 'debug' call if the banner did show the dancefloor as documented. Here are my 3 config files, slightly sanitized: config.yml: appname: "MyApp" charset: "UTF-8" environment: "development" port: 30000 session: "simple" template: "Xslate" engines: session: Simple: cookie_name: "myapplogin" cookie_duration: "30 days" session_duration: 3600 environments/development.yml: logger: "Console" warnings: 1 show_errors: 1 startup_info: 1 traces: 1 engines: logger: Console: log_level: core environments/production.yml: log: "warning" logger: "File" warnings: 0 show_errors: 0 route_cache: 1 Not to pile on, but it seems that changing 'environment' to 'production' in config.yml doesn't do anything. The errors still keep going to the console instead of a log file, and the verbosity level doesn't drop to 'warning'. The 'debug' line I added to my problem route does show up, and it says 'production'. The fact that this happens at 'debug' level corroborates my claim that the verbosity level isn't changing.

1 0

Dancer app in production on Starman : Dancer::Plugin::Database Child process cannot use database handle created in parent
by Anthony Milan 10 Feb '14

10 Feb '14

Hi, I tried to deploy my little app with Starman: plackup -E deployment -s Starman -p 5001 --workers=2 -a bin/app.pl I had this error: Child process cannot use database handle created in parent I used Dancer::Plugin::Database to manage database In this thread: http://lists.preshweb.co.uk/pipermail/dancer-users/2011-July/001681.html I read that Dancer::Plugin::Database ensure that handles are not shared between processes/threads. Most probably, I do something wrong :( Thanks for any help, -- Anthony Milan

1 1

updating a form
by Gert van Oss 10 Feb '14

10 Feb '14

Hi, I’m trying to build a small app to comment on images. Probably I’m almost there but currently stuck with updating a ‘file.yml' by a html-form. I’ve made two routes (shown below) “get ‘/:id/edit’ for showing the form with the particular image to comment on. When hitting save the ‘post ‘/edit’ will be called. My problem is that the post route doesn’t have the $id initialised. Is there someone around who can tell me how to solve this or point to me what I’m doing wrong? Thanks, Gert The structure is an AoH. The file.yml is like --- - collection: '' description: good id: 0 imgf: photo.jpg tags: '' - collection: '' description: '' etc.. ————end of yaml #--------------------------------------------------------------------- # # get EDIT # #--------------------------------------------------------------------- get '/:id/edit' => sub { my $filename = Dancer::FileUtils::read_file_content( Dancer::FileUtils::path( setting('appdir'), 'myImages.yml' ) ); my $data = from_yaml $filename; my @data = @{$data}; #print Dumper \@data; my $id = param('id'); template 'edit', { data => $data[$id], id => $id, }; }; #--------------------------------------------------------------------- # # post EDIT # #--------------------------------------------------------------------- post '/edit' => sub { my $data = get_AoH_imagelist(); my @data = @{$data}; my $id = param('id'); $data[$id] { description}= params->{description} ; #$data[2] { description}= params->{description} ; # this works but then all descriptions end up in the third group of hashes. my $filename = "myImages.yml"; write_file $filename, to_yaml($data); redirect '/'; };

6 8

Applicability of Dancer and Dancer vs. Dancer2
by Lutz Gehlen 09 Feb '14

09 Feb '14

Hello everybody, I tend to think that the following questions have been asked before, but I my search has been unsuccessful. So if someone could point me to existing documentation or mailing list threads I'd be happy as well. 1) I am trying to decide whether to use Dancer for a small to middle size web application. The key advantages that seem to keep coming up when people talk about Dancer is simplicity and light weight and that people recommend it for small or toy applications. That raises the question if there is a price to pay for this simplicity and light weight. So from your point of view, are there any important features missing or in general is there any reason not to recommend Dancer for serious and/or not-so-small applications? 2) The second question I am facing is whether to use Dancer or Dancer2. I know that Dancer2 is a OO rewrite of Dancer, but I couldn't figure out how the two relate to each other with respect to the devoloping community. Intriguingly, the webpage perldancer.org does not seem to mention Dancer2 at all. More specifically: a) Are Dancer and Dancer2 developed by the same people? b) Is Dancer2 supposed to supersede Dancer? c) Is Dancer more mature than Dancer2? d) How do the two compare to each other with respect to performance? e) In general, are there any reasons to prefer one over the other except my taste for procedure or object orientation? Thanks a lot and best wishes, Lutz

3 3

How do you measure code coverage?
by Иван Бессарабов 04 Feb '14

04 Feb '14

I have a small Dancer1 app and I have started writing tests for the web part. I used to write unit tests, but I have never written tests that test web component. With Dander::Test the task of writing tests is very simple, thank you for that module. But I don't understand one thing. I'm using Devel::Cover to find out what I haven't tests. It works fine with my application model that is created without Dacner, but it does not work for the Dancer routes. Devel::Cover does not create any metrics for such code: any ['get', 'post'] => '/login' => sub { ... } Devel::Cover shows that all my Dacner code is 100% coverd, but this is not true. So this tool does not answer the question what is tested and what is not. So my question is how do you measure coverage of code that is tested?

2 3

Dancer v1.3121 on its way to CPAN
by Yanick Champoux 02 Feb '14

02 Feb '14

Hey everybody, A new release of Dancer is making its way to CPAN as we speak. The changelog is below. As usual, mucho thanks to the contributors and bug reporters and everybody who made the release possible. Y'all rock. :-) Joy, `/anick 1.3121 2.02.2014 [ ENHANCEMENTS ] * GH #994: change heuristic so that 'application/vnd.openxmlformats-[...].sheet' is not recognized as text. (Skeeve) * GH #987: get_current_session() now accepts option 'no_update'. (Lee Carmichael) [ DOCUMENTATION ] * GH #983: Correction of various typos. (Akash Ayare) * GH #981: Add synopsis to Dancer::Request::Upload. (smashz) * GH #985: Change mentions of 'PerlHandler' to 'PerlResponseHandler' (Xaerxess)

1 0