NAME HealthCheck::Diagnostic::DBHCheck - Check a database handle to make sure you have read/write access VERSION version v0.500.3 SYNOPSIS my $health_check = HealthCheck->new( checks => [ HealthCheck::Diagnostic::DBHCheck->new( dbh => \&connect_to_read_write_db, db_access => "rw", tags => [qw< dbh_check_rw >] ), HealthCheck::Diagnostic::DBHCheck->new( dbh => \&connect_to_read_only_db, db_access => "ro", tags => [qw< dbh_check_ro >] ), ] ); my $result = $health_check->check; $result->{status}; # OK on a successful check or CRITICAL otherwise DESCRIPTION Determines if the database can be used for read and write access, or read only access. For read access, a simple SELECT statement is used. For write access, a temporary table is created, and used for testing. ATTRIBUTES Those inherited from "ATTRIBUTES" in HealthCheck::Diagnostic plus: label Inherited from "label1" in HealthCheck::Diagnostic, defaults to dbh_check. tags Inherited from "tags1" in HealthCheck::Diagnostic, defaults to [ 'dbh_check' ]. dbh A coderef that returns a DBI DATABASE handle object or optionally the handle itself. Can be passed either to new or check. db_access A string indicating the type of access being tested. A value of ro indicates only read access shoud be tested. A value of rw indicates both read and write access should be tested. DEFAULT is rw. db_class The expected class for the database handle returned by the dbh coderef. Defaults to DBI::db. DEPENDENCIES HealthCheck::Diagnostic CONFIGURATION AND ENVIRONMENT None AUTHOR Grant Street Group COPYRIGHT AND LICENSE This software is Copyright (c) 2019 - 2020 by Grant Street Group. This is free software, licensed under: The Artistic License 2.0 (GPL Compatible)