use Dancer2;
use Dancer2::Plugin::Database;

set serializer => 'JSON';

get '/:stock/date/:date' => sub {
    database->quick_select('price', {
        stock => params->{stock},
        date  => params->{date},
    }),
};
 
dance;

##</code><code>##

plugins:
    Database:
        driver:        'mysql'
        database:      'test'
        host:          'localhost'
        port:          3306
        username:      'your_app_id'
        password:      's3kr1t'
        on_connect_do: ["SET NAMES 'utf8'", "SET CHARACTER SET 'utf8'" ]
        dbi_params:
            RaiseError: 1
            AutoCommit: 1