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/