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@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