| 1 | package Mojolicious::Plugin::PgAsync; | ||
| 2 | use Mojo::Base 'Mojolicious::Plugin'; | ||
| 3 | |||
| 4 | use DBD::Pg ':async'; | ||
| 5 | use Data::Dumper; | ||
| 6 | use Mojolicious::Plugin::PgAsync::Pool; | ||
| 7 | |||
| 8 | our $VERSION = '0.03'; | ||
| 9 | |||
| 10 | has ttl => 30; | ||
| 11 | has pool => sub { Mojolicious::Plugin::PgAsync::Pool->new }; | ||
| 12 | |||
| 13 | our $debug = $ENV{DEBUG_PG}; | ||
| 14 | |||
| 15 | sub register { | ||
| 16 | my ($self, $app, $config) = @_; | ||
| 17 | |||
| 18 | $self->pool->dbi($config->{dbi})->ttl($config->{ttl} || $self->ttl); | ||
| 19 | |||
| 20 | $app->renderer->add_helper(pg => sub{ $self->execute(@_) }); | ||
| 21 | $app->renderer->add_helper(pg_listen => sub{ $self->listen(@_) }); | ||
| 22 | } | ||
| 23 | |||
| 24 | sub execute { | ||
| 25 | my $self = shift; | ||
| 26 | my $c = shift; | ||
| 27 | my $cb = pop; | ||
| 28 | my($sql, $attr, @values) = @_; | ||
| 29 | |||
| 30 | $self->pool->get | ||
| 31 | ->callback($cb) | ||
| 32 | ->sql($sql) | ||
| 33 | ->attr($attr) | ||
| 34 | ->execute(\@values) | ||
| 35 | ; | ||
| 36 | } | ||
| 37 | |||
| 38 | sub listen { | ||
| 39 | my $self = shift; | ||
| 40 | my $c = shift; | ||
| 41 | my $cb = pop; | ||
| 42 | my($channel) = @_; | ||
| 43 | |||
| 44 | $self->pool->get | ||
| 45 | ->callback($cb) | ||
| 46 | ->listen($channel) | ||
| 47 | ; | ||
| 48 | } | ||
| 49 | |||
| 50 | 1 | ||
| 51 | |||
| 52 | __END__ |