NAME

monm_dbi - tiny DBI checker for App::MonM

VERSION

Version 1.00

SYNOPSIS

    monm_dbi [ --dsn=DSN | --sid=SID ] [ --user=DB_USERNAME ]
             [ --password=DB_PASSWORD ] [ --sql=SQL ]
             [-a "DBI_ATTR_1=Value"] [-a "DBI_ATTR_n=Value"]

    monm_dbi -n "DBI:mysql:database=test;host=192.0.0.1"
             -u user -p password -q "SELECT * FROM mytable"
             -a "mysql_enable_utf8=1" -a "PrintError=0"

OPTIONS

-a "DBI_Attribute=Value"
    -a "DBI_Attribute=Value"
    -a "DBI_Attribute Value"

This is multiple option for setting DBI attributes

Default: "PrintError = 0"

-n DSN, --dsn=DSN

DSN of database connection

    DBI:mysql:database=DATABASE;host=HOST;port=PORT
    DBI:Pg:dbname=DATABASE;host=HOST;port=PORT;options=OPTIONS
    DBI:Oracle:SID
    DBI:Oracle:host=HOST;sid=SID
    DBI:SQLite:dbname=mybase.db
    DBI:CSV:f_dir=/path/to/csvdb

Default: "DBI:Sponge:"

See also DBI

-h, --help

Show short help information and quit

-H, --longhelp

Show long help information and quit

-p DB_PASSWORD, --password=DB_PASSWORD

DB password

-q SQL, --sql=SQL

SQL query string

-s SID, --sid=SID

Oracle SID (Service Name)

NOTE! For Oracle only!

-u DB_USERNAME, --user=DB_USERNAME

DB username

DESCRIPTION

Tiny DBI checker for App::MonM. Based on oradebug

DEPENDENCES

DBI

AUTHOR

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

COPYRIGHT

Copyright (C) 1998-2019 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 https://dev.perl.org/licenses/