[dancer-users] Dancer2::Plugin::Database Set transaction isolation level read uncommitted in quick_select

[Stefan Hornburg (Racke)]

Hello Jason,

the object returned by the database keyword is essentially a DBI handle, so you can use it for any SQL operation like DBI does.

Regards
               Racke


On 2 November 2016 05:16:23 CET, Jason Lewis <jason at dickson.st> wrote:
>Fellow dancers,
>
>Is there some way can get database->quick_select in
>Dancer2::Plugin::Database to execute some sql statement prior to the
>select?
>
>Specifically I need to execute "Set transaction isolation level read
>uncommitted" in order to avoid my queries being blocked.
>
>What would be really nice is if there was an additional parameter you
>could pass into quick_select of whatever sql to execute before the
>quick_select.
>
>Any ideas?
>
>Thanks
>
>Jason
>-- 
>Jason Lewis
>http://emacstragic.net
>_______________________________________________
>dancer-users mailing list
>dancer-users at dancer.pm
>http://lists.preshweb.co.uk/mailman/listinfo/dancer-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.preshweb.co.uk/pipermail/dancer-users/attachments/20161102/641ae5dc/attachment.html>