| 1 | package App::MadEye::Plugin::Agent::TheSchwartz::Error; | ||
| 2 | use strict; | ||
| 3 | use warnings; | ||
| 4 | use App::MadEye::Plugin::Agent::Base; | ||
| 5 | |||
| 6 | use DBI; | ||
| 7 | |||
| 8 | sub is_dead { | ||
| 9 | my ($self, $dsn) = @_; | ||
| 10 | |||
| 11 | my $conf = $self->config->{config}; | ||
| 12 | my $user = $conf->{user} or die "missing user"; | ||
| 13 | my $password = $conf->{password} || ''; | ||
| 14 | |||
| 15 | my $dbh; | ||
| 16 | eval { | ||
| 17 | $dbh = DBI->connect( | ||
| 18 | $dsn, | ||
| 19 | $user, | ||
| 20 | $password, | ||
| 21 | {RaiseError => 1, AutoCommit => 1} | ||
| 22 | ); | ||
| 23 | }; | ||
| 24 | |||
| 25 | if ($@) { | ||
| 26 | return $@; | ||
| 27 | } else { | ||
| 28 | my ($cnt) = $dbh->selectrow_array(q{select count(*) from error}); | ||
| 29 | if ($cnt > 0) { | ||
| 30 | return "error count: $cnt"; | ||
| 31 | } else { | ||
| 32 | return; # alive | ||
| 33 | } | ||
| 34 | } | ||
| 35 | } | ||
| 36 | |||
| 37 | 1; | ||
| 38 | __END__ |