NAME

App::MonM::Checkit::DBI - Checkit DBI subclass

VIRSION

Version 1.01

SYNOPSIS

<Checkit "foo">

    Enable  yes
    Type    dbi
    DSN     DBI:mysql:database=DBNAME;host=127.0.0.1
    SQL     "SELECT 'OK' AS OK FROM DUAL"
    User    USER
    Password PASSWORD
    Timeout 15s
    Set RaiseError  0
    Set PrintError     0
    Set mysql_enable_utf8   0

    # . . .

</Checkit>

DESCRIPTION

Checkit DBI subclass

check

Checkit method. This is backend method of "check" in App::MonM::Checkit

Returns:

code

The DBH error code ($dbh->err)

content

The merged response content

message

OK or ERROR value, see "status"

source

DSN of DBI connection

status

0 if error occured; 1 if no errors found

CONFIGURATION DIRECTIVES

The basic Checkit configuration options (directives) detailed describes in "CONFIGURATION DIRECTIVES" in App::MonM::Checkit

Content, SQL

SQL "SELECT 'OK' AS OK FROM DUAL"

Specifies the SQL query string (as content)

Default: "SELECT 'OK' AS OK FROM DUAL"

DSN

DSN     DBI:mysql:database=DATABASE;host=HOSTNAME

Sets Database DSN string

Default: dbi:Sponge:

Set

Set RaiseError     0
Set PrintError     0

Defines DBI Attributes. This directive allows you set case sensitive DBI Attributes. There can be several such directives.

Examples:

Set sqlite_unicode      1
Set mysql_enable_utf8   0

Default: no specified

Timeout

Timeout    1m

Defines the timeout of DBI requests

Default: off

Username, Password

User        USER
Password    PASSWORD

Defines database credential: username and password

Default: no specified

HISTORY

See Changes file

TO DO

See TODO file

BUGS

* none noted

SEE ALSO

App::MonM

AUTHOR

Serż Minus (Sergey Lepenkov) https://www.serzik.com <abalama@cpan.org>

COPYRIGHT

Copyright (C) 1998-2022 D&D Corporation. All Rights Reserved

LICENSE

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

See LICENSE file and https://dev.perl.org/licenses/