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 -- Jason Lewis http://emacstragic.net _______________________________________________ dancer-users mailing list dancer-users@dancer.pm http://lists.preshweb.co.uk/mailman/listinfo/dancer-users